修复 Table 'xxx' is marked as crashed and should be repaired
现象： mysql> use yourealcn Database changed mysql> select user,company from biz_user where commend='1' order by regtime desc,checked desc limit 0,5; ERROR 145 (HY000): Table './yourealcn/biz_user' is marked as crashed and should be repaired mysql> exit
使用命令myisamchk修复数据库的MYI文件即可
# /usr/local/mysql5/bin/myisamchk -c -r /bak/lib/mysql/yourealcn/biz_user.* myisamchk: error: '/bak/lib/mysql/yourealcn/biz_user.frm' is not a MyISAM-table
---------
myisamchk: error: '/bak/lib/mysql/yourealcn/biz_user.MYD' is not a MyISAM-table
---------
- recovering (with sort) MyISAM-table '/bak/lib/mysql/yourealcn/biz_user.MYI' Data records: 20414 - Fixing index 1 - Fixing index 2 - Fixing index 3 - Fixing index 4
