开发者

mysql incorrect key file

开发者 https://www.devze.com 2023-03-20 13:27 出处:网络
I am getting this 开发者_如何转开发error in mysql. I tried to repair it many times, but still its persisting. I also repaired all the tables.

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

精彩评论

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

关注公众号