开发者

mysql incorrect key file

I am getting this 开发者_如何转开发error in mysql. I tried to repair it many times, but still its persisting. I also repaired all the tables.

morein_db/categories.MYI'; try to repair it
110716  9:58:16 [ERROR] /usr/libexec/mysqld: Incorrect key file for table './morein_db/categories.MYI'; try to repair it
110716  9:58:16 [ERROR] /usr/libexec/mysqld: Incorrect key file for table './morein_db/categories.MYI'; try to repair it
110716  9:58:16 [ERROR] /usr/libexec/mysqld: Incorrect key file for table './morein_db/products_stock.MYI'; try to repair it
110716  9:58:16 [ERROR] /usr/libexec/mysqld: Incorrect key file for table './morein_db/products_stock.MYI'; try to repair it

110716 10:01:03 [ERROR] Got an error from thread_id=3586, /builddir/build/BUILD/mysql-5.5.10/storage/myisam/mi_write.c:222


Shutdown MySQL server, change the directory to morein_db while in the MySQL datadir and execute the myisamchk utility

myisamchk --silent --force --fast --update-state --key_buffer_size=64M --sort_buffer_size=64M --read_buffer_size=1M --write_buffer_size=1M *.MYI

This assumes you have more than 64M of available RAM. If you increase these buffers the repair will be faster. You can check the details for the (very handy) myisamchk utility here: http://dev.mysql.com/doc/refman/5.6/en/myisamchk.html

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜