Monday, October 15, 2012

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



No comments:

Post a Comment