About This Journal
Technical concerns tend to find a solution as long as there are good people working on them. And Linux has the very best. - Linus Torvalds
MySQL table issues
pepesmith
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
Posted in Miscellaneous |
No Comments »