Cheap VPS & Xen Server

Residential Proxy Network - Hourly & Monthly Packages

MySQL – mysqldump: Got error: 1016: Can’t open file: ‘./exampledb/xxx.frm’ (errno: 24) when using LOCK TABLES


You try to create a MySQL database dump and get the following error:

mysqldump -u root -pmysecretpassword –opt exampledb > exampledb.sql

root@server11:/tmp/mysql# mysqldump -u root -pmysecretpassword –opt exampledb > exampledb.sql
mysqldump: Got error: 1016: Can’t open file: ‘./exampledb/xxx.frm’ (errno: 24) when using LOCK TABLES
root@server1:/tmp/mysql#

 

Solution

Add –lock-tables=false to the mysqldump command:

mysqldump -u root -pmysecretpassword –opt exampledb –lock-tables=false > exampledb.sql

Comments

comments