Got error: 145: Table './visualp_tcctxp/txp_log' is marked as
crashed and should be repaired when using LOCK TABLES #
perror 145MySQL error code 145: Table was marked as crashed
and should be repaired
Obviouly the failed backup was caused by table fault. Great
mysql> repair table txp_log;
+------------------------+--------+----------+--------------------+
+------------------------+--------+----------+--------------------+
Table Op Msg_type Msg_text
+------------------------+--------+----------+--------------------+
txp_log repair warning Number of rows changed from 5000 to 5004
txp_log repair status OK
+------------------------+--------+----------+--------------------+
2 rows in set (1.29 sec)
mysql> exit
mysql> exit
Obviouly the failed backup was caused by table fault. Great
to know that mysqldump could be helpful in finding table's
problem which may or may not affect web site or application,
mysqldump provide us an alternative way to diagnose
database problem like what I experienced.
I have two web sites sync each other. primary backup was
automatically restored in secondary every night. In this case,
failed backup couldn't be restored, and then I got 404 alert...
