`

数据库出现Got error 134 from storage engine错误,程序一直抛出错误

阅读更多
Got error 134 from storage engine
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)

切记在修复之前备份数据库,以免出现问题;
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics