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

Share/Save/Bookmark

Comments

Leave a Reply