How Nexcess clients on physical (non-cloud) accounts can repair crashed MySQL tables using either phpMyAdmin or the MySQL CLI.
If you encounter MySQL time-out errors or unexpected restarts, the likely cause is one or more crashed database tables. Repairing the crashed tables will likely solve the issue, though this may cause the loss of some data.
If you are uncomfortable with losing data, then using a recent database dump to restore the database may mitigate this loss. However, if the date of your last database dump is not recent, it can result in greater data loss than simply repairing the table.
This method only applies to Nexcess clients on physical (non-cloud) servers. If you are a Nexcess Cloud client, contact our 24/7 support team for assistance.
You can access phpMyAdmin from your SiteWorx account:
Log in to your SiteWorx account.
On the left, select Hosting Features > MySQL > PhpMyAdmin.
Select the correct database from the list on the left.
Select the check box corresponding to the corrupted table, and from the With selected list, click Repair table.
Use this procedure to repair MySQL tables from the command line:
mysql -u [username] -p
check table [yourtablename];
repair table [yourtablename];
For the complete MySQL documentation, see the MySQL development website.
Our award-winning customer care team is here for you.Contact Support