|
|
现象：
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
|
|
Posted by glen
in [Linux/BSD] | 评论:0
| 总浏览:1961 | [打印全文]
|
|
|
 关键字:
| 关键字: 修复 Table 'xxx' is marked as crashed and should be repaired,博志,soft,glen'blog,blog,weblog,blog,qzhiwu@msn.com |
|
引用 [0]
| 本文无Trackback |
 |
|
添加评论
|
|
2007-10-25 00:44:57