IDO老徐，在深圳，某上市公司质量部负责人，干了十二年软件测试，公号"简尚" ，博客isTester.com ，关注「软件测试从业者综合能力提升」，微信957863300

mysql报错Table is marked as crashed and should be repaired 的解决办法

上一篇 / 下一篇 2020-11-14 13:41:34 / 个人分类：linux

前几天，老徐的istester博客突然挂了；收到了用户的反馈才知道；

折腾了几次没发现原因；

后面查了下数据库，才发现，是库出问题了；

如下是报错内容和解决思路；

mysql> select * from isTeter.com ;

ERROR 145 (HY000): Table './isTeter_Idoxu/isTeter.com' is marked as crashed and should be repaired

mysql> check table isTeter.com ;

+-----------------------------+-------+----------+------------------------------------------------------------+

+-----------------------------+-------+----------+------------------------------------------------------------+51Testing软件测试网:z8_CQ5\n-s.]

+-----------------------------+-------+----------+------------------------------------------------------------+

4 rows in set (0.31 sec)

mysql> repair table isTeter.com;

+-----------------------------+--------+----------+----------+

+-----------------------------+--------+----------+----------+

+-----------------------------+--------+----------+----------+

1 row in set (0.15 sec)

mysql> check table isTeter.com;

+-----------------------------+-------+----------+----------+51Testing软件测试网e;n8C"n]

+-----------------------------+-------+----------+----------+

+-----------------------------+-------+----------+----------+

1 row in set (0.01 sec)

搞定；

TAG:

IDO老徐，坐标深圳，测试经理，干了十年测试，公号"简尚" ，个人博客isTester.com ，关注「软件测试从业者综合能力提升」，微信957863300