How to Repair MyISAM Tables

Written by

MyISAM tables (.MYI and .MYD) can be repaired using myisamchk command.

To find list of corrupted tables

myisamchk /var/lib/mysql/DB_NAME/*.MYI >> /root/1.txt

To rapier a table

cd  /var/lib/mysql/DB_NAME/
myisamchk -r TABLE_NAME_HERE.MYI

To check and repair all tables

myisamchk --silent --force --fast --update-state /var/lib/mysql/DB_NAME/*.MYI

Look like newer version of MySQL, you need to specify just table name, no extension, for example

cd /var/lib/mysql/DB_NAME/
myisamchk -r TABLE_NAME

Comments