最近在用mysqldump备份数据库,不过报错如下:
mysqldump: Got error: 1044: Access denied for user 'root'@'localhost' to database 'information_schema' when using LOCK TABLES
最后解决办法如下:
mysqldump --single-transaction -u user -p DBNAME > backup.sql
原创文章,作者:章郎虫,如若转载,请注明出处:http://www.szl724.com/database/mysql/2771.html