• 欢迎访问Ppabc博客网站,专注于Linux、CentOS、Apache、Nginx、MySQL、PHP等开源工具安装优化的技术博客,推荐使用最新版火狐浏览器和Chrome浏览器访问本网站,欢迎加入Ppabc博客
  • 如果您觉得本站非常有看点,那么赶紧使用Ctrl+D 收藏Ppabc博客吧

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

mysql技术 admin 11年前 (2008-06-07) 288次浏览

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


Selinux 中国 , 版权所有丨如未注明 , 均为原创丨本网站采用BY-NC-SA协议进行授权
转载请注明原文链接:FREEBSD 服务器突然断电 SS 出问题数据库修复
喜欢 (0)