SupeSite info: MySQL Query Error
User: guest
Time: 2008-6-7 7:42am
Script: /index.php
SQL: SELECT uid FROM [Table]userspaces WHERE domain=’web0034′
Error: Table ‘./000000/[Table]userspaces’ is marked as crashed and should be repaired
Errno.: 145
SupeSite info: MySQL Query Error
User: guest
Time: 2008-6-7 7:42am
Script: /index.php
SQL: SELECT uid FROM [Table]userspaces WHERE domain=’web003′
Error: Table ‘./000000/[Table]userspaces’ is marked as crashed and should be repaired
Errno.: 145
使用修复
/usr/local/mysql/bin/myisamchk -c -r /usr/local/mysql/var/000000/*
参考http://www.china-lg.com/?id=489
导读:
现象:
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 InnoDB-table
———
myisamchk: error: ‘/bak/lib/mysql/yourealcn/biz_user.MYD’ is not a InnoDB-table
———
- recovering (with sort) InnoDB-table ‘/bak/lib/mysql/yourealcn/biz_user.MYI’
Data records: 20414
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4