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.



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



Once the repair is complete you will get this screen:



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.