Incorrect key file for table '.\xx\xxx.MYI'; try to repair it解决方法

本来运行得好好的程序,没有人修改,突然报MYSQL查询错误。到PM里面手动执行一下SQL语句,发现错误提示:

Incorrect key file for table ‘.\xx\xxx.MYI’; try to repair it

提示一张日志表损坏,需要修复。
停掉相关服务:

1
2
net stop Apache2.2
net stop MySQL

冷备数据库后,执行check table xxxrepair table xxx修复表后恢复正常。

更多
One Response Post a comment

Leave a Reply

Note: You may use basic HTML in your comments. Your email address will not be published.

Subscribe to this comment feed via RSS