If your website displays errors like “table marked as crashed” or “cannot find file”, it means that one or more tables in your MySQL database are corrupted. Don’t worry! cPanel allows you to repair them easily using phpMyAdmin, even if you have no coding knowledge.
Table of Contents
Always Back Up Before Repairing
Before doing anything, back up your database to avoid any accidental data loss.
How to do it:
- Go to cPanel > phpMyAdmin
- Select your database from the left-hand column
- Click on the Export tab
- Leave the default “Quick” option selected and click Export
This downloads a .sql backup file.
Check and Repair MySQL Tables with phpMyAdmin
- Check the tables you want to inspect, or click Select All at the bottom of the list
- In the “With selected:” dropdown menu, choose Check table
phpMyAdmin will notify you if any table is corrupted
If an error appears:
- Stay on the same page and re-check the tables
- From the same dropdown menu, select Repair table
Once done, a message like “OK” or “repaired” should appear.
Optional: Optimize Tables
After the repair, you can choose Optimize table to improve overall performance.
If you still need assistance, feel free to contact our support team.