Saturday, June 20, 2009

MySQL mysqldump tablename.MYD not found (Errcode: 24) when using LOCK TABLES

In mysql 4.1 --opt option of mysqldump was made default.

This makes mysql to LOCK TABLES.

SOLUTION:
Use --skip-lock-tables to disable.

No comments: