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

David Yin

David is a blogger, geek, and web developer — founder of FreeInOutBoard.com. If you like his post, you can say thank you here

Leave a Reply

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