Monthly Archives: November 2007

MySQL table issues

When i do a command SHOW TABLE STATUS, along with its table display I’ve found this odd message :
Can’t open file: ‘xxx_table.MYI’. (errno: 145)

I’ve been trying to figure out how to solved this problem and found on the net a solution [1] which is very useful.
The command goes like this : myisamchk -r xxx_table.MYI

There are available commands in fixing the table. There is myisamchk –safe-recover [2] and the Mysql statement : REPAIR TABLE xxx_table[3].
I havent tried it but the command myisamchk -r xxx_table.MYI works for me.

[1] http://www.tech-bits.com/index.php/CategoryID/11/EntryId/41/entry
[2] http://dev.mysql.com/doc/refman/5.0/en/myisamchk-repair-options.html
[3] http://dev.mysql.com/doc/refman/5.0/en/repair-table.html