How to solve mysqldump 1044 error

I do a database backup very ofter with mysqldump command.
Just found an error come when I run the command, mysqldump as below.

mysqldump: Got error: 1044: Access denied for user ‘root’@’localhost’ to database ‘information_schema’ when using LOCK TABLES

I google it and found one solution for it.

Add –single-transaction

$ mysqldump --single-transaction -u user -p DBNAME > backup.sql

Leave a Reply

Your email address will not be published.