How to repair a broken MySQL database in cPanel
Print
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.
- 23-03-2018 14:49
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.
Related Articles
© Crucial