After I rebooted manually my database server I received following message in mysql log:

[ERROR] /usr/libexec/mysqld: Incorrect key file for table <name of the table>.MYI’; try to repair it

The fix is relatively simple

  1. Go to MySQL console – mysql
  2. Point to correct database – use <database name>
  3. Issue command to repair – repair table <name of the table>
  4. Sit back and wait – it will take some time

Comments

One Response to “[ERROR] /usr/libexec/mysqld: Incorrect key file for table”

  1. Rafael Barbosa on January 26th, 2011 11:51 am

    Very good!
    Ty a lot.

Leave a Reply