mysqldump表时候,会出现表锁死情况,当前无权限dump数据
例如:
mysqldump --single-transaction -h1.1.1.1 -P1111 -umyuser -pmypass dbname tbname > tbname.sql
出现错误:
mysqldump: Got error: 1044: Access denied for user 'myuser'@'1.1.1.1' to database 'dbname' when using LOCK TABLES
解决方法:
加上 --single-transaction
mysqldump --single-transaction -h1.1.1.1 -P1111 -umyuser -pmypass dbname tbname > tbname.sql