How to quickly repair MySQL database table using phpMyAdmin?
If the MySQL server crashed and your database becomes corrupt, here is now to easily repair it using phpMyAdmin:
- Login to phpMyAdmin
- Choose the affected database (click on the database name on the left)
- In the panel on the right, you should see a list of your database tables. Check the boxes by the tables that need repair.
- At the bottom of the window just below the list of tables, there is a drop down menu. Choose “Repair Table”
This should fix the problem and let your program access the database again. On some cases, the damage can’t be repaired. It is a good idea to backup your database from time to time. Maybe this script is helpful to you: backupdb
