遇到的問題：
mysqldump: Error 1194: Table 'user' is marked as crashed and should be repaired when dumping table `user` at row: 1161435

登陸到數(shù)據(jù)庫：
mysql> select count(*) from user;
+----------+
| count(*) |
+----------+
|??1840589 |?
+----------+
1 row in set (0.00 sec)
mysql> repair table user;
+--------------+--------+----------+------------------------------------------------+
| Table? ?? ???| Op? ???| Msg_type | Msg_text? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?|
+--------------+--------+----------+------------------------------------------------+
| txtotal.user | repair | warning??| Number of rows changed from 1840589 to 1161435 |?
| txtotal.user | repair | status? ?| OK? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?|?
+--------------+--------+----------+------------------------------------------------+
2 rows in set (50.04 sec)
mysql> select count(*) from user;? ?? ???
+----------+
| count(*) |
+----------+
|??1161435 |?
+----------+
1 row in set (0.20 sec)
mysql> check table??user;? ?? ???
+--------------+-------+----------+----------+
| Table? ?? ???| Op? ? | Msg_type | Msg_text |
+--------------+-------+----------+----------+
| txtotal.user | check | status? ?| OK? ?? ? |?
+--------------+-------+----------+----------+
1 row in set (15.05 sec)

數(shù)據(jù)表已經(jīng)修復(fù)完成，只是記錄從原來的1840589 條減少到了1161435 條，不是太清楚還有沒有更好的方法去實現(xiàn)修復(fù)。


本文來自ChinaUnix博客，如果查看原文請點：http://blog.chinaunix.net/u1/38871/showart_1996523.html

轉(zhuǎn)載于:https://www.cnblogs.com/L-H-R-X-hehe/p/4084404.html

總結(jié)

以上是生活随笔為你收集整理的mysqldump表损坏问题的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。