Mysqldump: Got error: 145错误

Mysql数据库导出时报错mysqldump : Got error : 145的解决方案

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

解决方法如下：

1、check tables t_xxx;

2、repair table t_xxx;

再进行dump就行

或者加上参数--lock-tables=false就行

mysqldump -u root -p'password' dbname --lock-tables=false > dbname.sql