MySQL Table is marked as crashed 解决方法

MYSQL数据表出现问题,提示:
ERROR 144 (HY000): Table './dpt/dpt_production' is marked as crashed and last (automatic?) repair failed

修复数据表操作:

service mysqld stop;
cd /var/lib/mysql/dpt
myisamchk -r dpt_production.MYI
mysqlcheck -r dpt -uroot -p

注意:操作第三步前一定要把mysql服务停掉。

posted @ 2016-07-29 16:45  回首郑板桥  阅读(2941)  评论(0编辑  收藏  举报