RSS

mysqldump: Got error: 1016: Can’t open file: … (errno: 24) when using LOCK TABLES

16 May

While using command

mysqldump  -uusername -ppassword DB_NAME > DUMP_FILE.sql, you may get this error, the fix is simply add
–lock-tables=false

mysqldump –lock-tables=false -uusername -ppassword DB_NAME > DUMP_FILE.sql

 
Leave a comment

Posted by on May 16, 2012 in General, MySQL

 

Tags: , ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: