If your MySQL database is experiencing errors, crashes, or corruption, cPanel provides a built-in repair tool that can fix common issues without requiring command-line access.
Steps to Repair a Database via cPanel
- Log in to your cPanel account.
- Navigate to the Databases section and click MySQL® Databases.
- Scroll down to the Modify Databases section.
- Select the database you want to repair from the Repair Database drop-down list.
- Click the Repair Database button.
- cPanel will attempt to repair all tables in the selected database. Results are displayed on the page — each table will show OK or an error message.
Important Notes
- The cPanel repair tool runs the MySQL
REPAIR TABLEcommand on all tables in the selected database. It works for MyISAM tables. InnoDB tables will report that the storage engine does not support repair — this is normal. - For InnoDB tables, cPanel will attempt an
ANALYZE TABLEorCHECK TABLEinstead. If InnoDB tables are corrupted, you may need to restore from backup or contact your hosting provider. - Always back up your database before attempting a repair. You can export it via phpMyAdmin if cPanel’s backup is unavailable.
Troubleshooting
- Repair was not successful: If errors persist after repair, the corruption may be severe. Restore from a recent backup or ask your hosting provider to investigate at the server level.
- Database not listed: Ensure you are looking under the correct cPanel account. Databases attached to other users will not appear in your list.
- Frequent corruption: Recurring database corruption often indicates a hardware issue (e.g. failing disk). Report this to your hosting provider.
