MySQL Dump Error: The user specified as a definerdoes not exist when using LOCK TABLES

The user specified as a definerdoes not exist when using LOCK TABLES

This error happens on exporting the MySQL database through mysqldump command. Because MySQL will lock the entire database during mysqldump bydefault.

We can resolve this problem by using one argument with mysqldump command.

#mysqldump --single-transaction db > db.sql

Here we need to replace the db with the name of the required database.

That's all…

Leave a Reply

Your email address will not be published. Required fields are marked *