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

很尴尬 ，isTester.com博客突然挂了；收到了用户的反馈才知道 ；

折腾了几次没发现原因；

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

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

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 ;

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

| Table                       | Op    | Msg_type | Msg_text                                                   |

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

| isTeter_Idoxu.isTeter.com | check | warning  | Table is marked as crashed                                 |

| isTeter_Idoxu.isTeter.com | check | warning  | 102 clients are using or haven't closed the table properly |

| isTeter_Idoxu.isTeter.com | check | error    | Checksum for key:  4 doesn't match checksum for records    |

| isTeter_Idoxu.isTeter.com | check | error    | Corrupt                                                    |

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

4 rows in set (0.31 sec)

mysql> repair table isTeter.com;

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

| Table                       | Op     | Msg_type | Msg_text |

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

| isTeter_Idoxu.isTeter.com | repair | status   | OK       |

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

1 row in set (0.15 sec)

mysql> check table isTeter.com;

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

| Table                       | Op    | Msg_type | Msg_text |

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

| isTeter_Idoxu.isTeter.com | check | status   | OK       |

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

1 row in set (0.01 sec)

搞定 ；