修复 Table 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

本文转自
http://www.china-lg.com/?id=489