mysql数据库备份报错145_在给mysql数据库备份时，报错： mysqldump: Got error: 145: Table '.\shengdaxcom\pre_forum_thread'...

在给mysql数据库备份时，报错：

mysqldump: Got error: 145: Table '.\shengdaxcom\pre_forum_thread' is marked as c

rashed and should be repaired when using LOCK TABLES

如上错误的解决方法如下：

1、进入数据库对该表进行检测：

mysql> check tables pre_forum_thread;

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

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

| Table | Op | Msg_type | Msg_text

|

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

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

| shengdaxcom.pre_forum_thread | check | warning | Table is marked as crashed

|

| shengdaxcom.pre_forum_thread | check | warning | 1 client is using or hasn't

closed the table properly |

| shengdaxcom.pre_forum_thread | check | error | Size of indexfile is: 845824

Should be: 846848 |

| shengdaxcom.pre_forum_thread | check | error | Corrupt

|

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

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

4 rows in set (0.06 sec)

2、使用repair解决方法：

mysql> repair tables pre_forum_thread;

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

| Table | Op | Msg_type | Msg_text |

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

| shengdaxcom.pre_forum_thread | repair | status | OK |

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

1 row in set (0.31 sec)

再次进行dump备份就可以了。

其他参考:

只要在mysqldump的时候加上--lock-tables=false就可以解决问题。

mysqldump -u root -pMyPassword DbName --lock-tables=false > data.sql