MyISAM

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, … Read more