Hello,

I’m sure that many of you, at some point when you we’re trying to backup your MySQL database, have encountered this error: mysqldump: Got error: 1146: Table ‘…’ doesn’t exist when using LOCK TABLES.

Here is a quick-fix for this problem:

mysqldump -uusername -ppassword database_name–skip-lock-tables >backup-database_name.sql

Don’t forget to replace the bold text from the above command.

One Response to “Fix for mysqldump error 1146: Table ‘…’ doesn’t exist when using LOCK TABLES”