[root@505-u21 www]# mysqldump -u root -p xx> xx_0807.sql
Enter password:
mysqldump: Got error: 145: Table ‘./xx/jieqi_article_searchcache’ is marked as crashed and should be repaired when using LOCK TABLES

 

进入mysql  执行语句repair table jieqi_article_searchcache

mysql> repair table jieqi_article_searchcache
-> ;
+———————————+——–+———-+——————————————–+
| Table | Op | Msg_type | Msg_text |
+———————————+——–+———-+——————————————–+
| xs321.jieqi_article_searchcache | repair | warning | Number of rows changed from 14984 to 14982 |
| xs321.jieqi_article_searchcache | repair | status | OK |
+———————————+——–+———-+——————————————–+
2 rows in set (0.14 sec)

 

然后在执行导出就正常了

发表评论

邮箱地址不会被公开。 必填项已用*标注