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.