全部博文(930)
分类: Mysql/postgreSQL
2011-02-22 19:23:04
storage engine错误,一般就是表出错了吧
使用以下步骤尝试修复:
检查表:check table tablename;
如:
mysql> check table member;
+--------------------+-------+----------+-----------------------------+
| Table | Op | Msg_type | Msg_text |
+--------------------+-------+----------+-----------------------------+
| bbs.member | check | error | Found 165614 keys of 165613 |
| bbs.member | check | error | Corrupt |
+--------------------+-------+----------+-----------------------------+
2 rows in set (0.03 sec)
修复表:repair table tablename;
如:
mysql> repair table member;
+--------------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+--------------------+--------+----------+----------+
| bbs.member | repair | status | OK |
+--------------------+--------+----------+----------+
1 row in set (1.54 sec)