http://www.tczgw.cn/index.php mysql报错Table is marked as crashed and should be re,同城购 同城推广 同城购物 同城直购.中国-020同城营销门户网与电子商务平台|网上建站|开店|团购|拍卖|秒杀|促销|抢购|预定|资询|论坛|圈子|城乡上网工程|同城爱淘| 同城交易
拒绝撞衫
今日最大牌－心相印
崇尚绿色
数码电器科技 >> mysql报错Table is marked as crashed and should be re

mysql报错Table is marked as crashed and should be re

点击数：178 作者：tczgw 发布时间：2022-07-11 11:21:32

很尴尬 ，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)



搞定 ；

上一篇文章：外链和反链有什么区别？下一篇文章：系统自动启动的信息推荐

同城直购网

客服中心

18638849361

服务时间：7 x 24 小时全天服务

E-mail：lyscxxw@qq.com

传真：0379-65999110

电话：13007583872

客服：点击这里给我发消息  点击这里给我发消息