is marked as crashed and should be repaired快速解决

作者:阿川 发布时间:December 25, 2013 分类:服务器

在SHELL下直接执行:

myisamchk -c -r /var/lib/mysql/dbname/tabname

例如:
[root@v121211 /]# myisamchk -c -r /var/lib/mysql/maillotsfoot_pascher/sessions
- recovering (with sort) MyISAM-table '/var/lib/mysql/maillotsfoot_pascher/sessions'
Data records: 3
- Fixing index 1
Found block that points outside data file at 1452972
Data records: 2

这样就已经修复了