Fixing Mysqldump Lock Tables Error
If you ever find yourself doing a mysqldump on a large database, you may end up seeing this error:
user@computer:$
mysqldump: Got error: 29: File './db/table_1001269.MYD' not found (Errcode: 24) when using LOCK TABLES
mysqldump: Got error: 29: File './db/table_1001269.MYD' not found (Errcode: 24) when using LOCK TABLES
If this happens, just re-run the mysqldump command and add the –skip-lock-tables flag:
user@computer:$ mysqldump -uuser -ppassword --skip-lock-tables database > database.sql
MySQL sometimes tries to incorrectly lock tables on the information_schema database.
Full View >>
January 4th, 2012 at 6:37 am
Thanks! This resolved my issue.
But I would like to know if this have any consequences!Is all data backed up? or any chance of some data missing?
January 4th, 2012 at 10:59 pm
I haven’t had any problems with it. Please let me know if you do.