Backup mysqldump error crashed and last (automatic?) repair failed when using LOCK TABLES

พยายายม backup ด้วยคำสั่งนี้
mysqldump -u root -p db_name | gzip -9 > ./`date "+%y%m%d"`_dbname_bak.sql.gz

แต่เจอ error นี้
mysqldump: Got error: 144: Table './db_name/table_name' is marked as crashed and last (automatic?) repair failed when using LOCK TABLES

Solved

use db_name; 

check table table_name; 

repair table table_name;

Refer

• http://www.techrepublic.com/article/checking-and-repairing-mysql-tables/5193721
• http://dev.mysql.com/doc/refman/5.1/en/repair-table.html