How to repair a broken database
MySQL queries or tables stop working
If you get an error which says, “so-and-so is marked as crashed and needs to be repaired,” then you can easily fix this in cPanel.
Even if you are getting a different kind of error like “supplied argument is not a valid” or “table attribute does not exist”, then you can use this test to try and fix the problem.
- Login to cPanel and click MySQL Databases.
- Under Modify Databases, look for the drop-down called “Check DB”.
- Select the database name which is having trouble.
- Click the Check DB button.
This should reveal the cause of the problem. If the problem is “marked as crashed”, then proceed.
- Go back to MySQL Databases.
- Under Modify Databases, look for the drop-down called “Repair DB”.
- Select the database name which is having trouble.
- Click the Repair DB button.
- Once complete, reload your web site.