How to Repair a Corrupted MySQL table

Open a command prompt on your Windows server and enter the following:
(replace the values with your MySQL username, password, and database name)


mysqlcheck -u<USERNAME> -p<PASSWORD> --databases <DB-NAME>

(Note there are no spaces before the username and password)


This will then check your database and if you do have a corrupt table you will see some errors, such as:


DATABASENAME.wp_ngg_album OK
DATABASENAME.wp_ngg_gallery OK
DATABASENAME.wp_ngg_pictures OK
warning : Table is marked as crashed
warning : 1 client is using or hasn't closed the table properly
warning : Auto-increment value: 121441 is smaller than max used value: 121443
error : Checksum for key: 1 doesn't match checksum for records
error : Corrupt


To attempt a repair, log into your database:



Then at the MySQL prompt, enter:
(replace DB-NAME with your database  name) 

use <DB-NAME>;

and then type:




For example, the above example shows that table wp_options is corrupt, so to repair this table we do:


mysql> REPAIR TABLE `wp_options`;

| Table                   | Op     | Msg_type | Msg_text
| DATABASENAME.wp_options | repair | status   | OK      




Add Feedback