Got error 134 from storage engine

1769阅读 0评论2011-02-22 ubuntuer
分类:Mysql/postgreSQL

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)


上一篇:MySQL federated引擎试验
下一篇:starting MySQ Manager of pid-file quit