How to repair a broken MySQL database in cPanel


Sometimes your MySQL queries or tables may 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 valid" or "table attribute does not exist", then you can use this guide to troubleshoot the problem.


Step 1 - Log into cPanel and click on MySQL Databases.

sqlrepair01.png

Step 2 - (1) Select the Database you would like to repair, then (2) click Repair Database.

sqlrepair02.png

Once the repair is complete you will get this screen:

sqlrepair03.png

If your site does not come back up after this troubleshooting step, we'd recommend contacting your developer. Alternatively, you can restore a backup of your site if necessary by using our automated backups.


Did you find this article useful?