mysqldump: Got error: 145:

检查数据库备份日志看到以下错误：

 mysqldump: Got error: 145: Table './shopex/sdb_members' is marked as crashed and should be repaired when using LOCK TABLES

原因可能是未正常关闭数据库，导致表损坏。

解决：

 

mysql> check table happy_tea_userlog;

…

……

………………

 

mysql> repair table happy_tea_userlog;

…

……

………

mysql> check table happy_tea_userlog;

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

| Table                 | Op    | Msg_type | Msg_text |

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

| shopex.sdb_members | check | status   | OK       | 

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

1 row in set (0.78 sec)

 

 

 

转载于:https://blog.51cto.com/sndapk/1134855