mysqldump: Error 1194

# mysqldump -uroot -p test> /var/lib/mysql/test.sql
Enter password:
mysqldump: Error 1194: Table 'log' is marked as crashed and should be repaired when dumping table `log` at row: 8521321

# mysql -uroot -p
mysql> check table log;
+---------------+-------+----------+----------------------------------------------------------+
| Table         | Op    | Msg_type | Msg_text                                                 |
+---------------+-------+----------+----------------------------------------------------------+
| test.log | check | warning  | 3 clients are using or haven't closed the table properly |
| test.log  | check | error    | Found wrong packed record at 1049886676                  |
| test.log  | check | error    | Corrupt                                                  |
+---------------+-------+----------+----------------------------------------------------------+
3 rows in set (38.94 sec)

 

mysql> repair table log;
+---------------+--------+----------+-------------------------------------------+
| Table         | Op     | Msg_type | Msg_text                                  |
+---------------+--------+----------+-------------------------------------------+
| test.log  | repair | info     | Found wrong packed record at 1049886676   |
| test.log  | repair | warning  | Number of rows changed from 0 to 10540321 |
| test.log  | repair | status   | OK                                        |
+---------------+--------+----------+-------------------------------------------+
3 rows in set (6 min 45.35 sec)

mysql> check table log;
+---------------+-------+----------+----------+
| Table         | Op    | Msg_type | Msg_text |
+---------------+-------+----------+----------+
| test.log   | check | status   | OK       |
+---------------+-------+----------+----------+
1 row in set (36.82 sec)