Offline
Online
Viewers

Fixing Mysqldump Lock Tables Error

If you ever find yourself doing a mysqldump on a large database, you may end up seeing this error:


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:

mysqldump -uuser -ppassword --skip-lock-tables database > database.sql

MySQL sometimes tries to incorrectly lock tables on the information_schema database.

2 Comments

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Affiliates