mysql错误is marked as crashed and should be repaired

我是在centos6.2下跑ecshop的

报错如下

Table './ecshopExtned/mmbk_order_workflow' is marked as crashed and should be repaired.

 

查配置文件、etc/my.cnf找到data目录，默认 /var/lib/mysql/ecshopExtned/mmbk_order_workflow.MYI

找myisamchk工具which mysql 在同级目录下面，默认/usr/bin/myisamchk

myisamchk -c -r  /var/lib/mysql/ecshopExtned/mmbk_order_workflow.MYI

 

结果是

- recovering (with sort) MyISAM-table '/var/lib/mysql/ecshopExtned/mmbk_order_workflow.MYI'
Data records: 146260
- Fixing index 1
Found block that points outside data file at 33333220

备份一下数据，完成