Errors such as: ..."Got error: 1016: Can't open file: 'YOUR_TABLE_NAME.MYI'. (error:145) when using LOCK TABLES"... is caused by MySQL table corruption. Table corruption can be caused by a variety of events, and will make some or all of a table unavailable.

The corruption can also significantly decrease the performance of queries on effected tables. It can be repaired by using the the Repair Database command in phpMyAdmin.

Some other errors that may also be caused by table corruption include:

• Can't find file table.MYI.
• Duplicate unique key or constraint on write or update.
• Got error ERR from table handler. (ERR being a number).
• Index file is crashed / Wrong file format.
• No more room in index file.
• No more room in record file.
• Old database file.
• Record file is crashed.
• Record was already deleted (or record file crashed).
• table.frm is locked against change.
• Table is crashed and last repair failed.
• Tables was marked as crashed and should be repaired.
• Unexpected end of file.

How helpful was this article to you?