Linux Ask!

Linux Ask! is a Q & A web site specific for Linux related questions. Questions are collected, answered and audited by experienced Linux users.

Apr 182010

Repair table in MySQL


If you are using the MyISAM storage engine, database might be corrupted when the computer was shutdown unexpectedly. To repair the table, you can use the following command in the MySQL client.

mysql> REPAIR TABLE my_table;

 Leave a Reply



You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>