repair myisam table

From WebHostingNeeds.com
Jump to: navigation, search

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