Tag: MyISAM

  • How to Repair MyISAM Tables

    How to Repair MyISAM Tables

    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
    

    Back to MySQL Repair