FREEBSD服务器突然断电SS出问题数据库修复

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

© 版权声明
THE END
喜欢就支持以下吧
点赞0 分享