[root@localhost ~]# /opt/mysql/bin/mysqldump --opt xxx_erp > xxx_erp_db03_test01.sql
mysqldump: Got error: 1449: The user specified as a definer ('xxxerp'@'%') does not exist when using LOCK TABLES
解决办法:
mysql>grant all privileges on xxxerp.* to 'xxxerp'@'%' identified by '123456';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
[root@localhost ~]# /opt/mysql/bin/mysqldump --opt xxx_erp > xxx_erp_db03_test01.sql
[root@localhost ~]# ll
total 2320444
-rw-r--r-- 1 root root 2183168822 Oct 29 01:42 xxx_erp_db03_test01.sql
-rw-r--r-- 1 root root 186133946 Aug 16 14:18 all.tar.gz
The end