MySQL Backup error logging

Today, there is a problem, MySQL data volume backup error, recorded as follows:

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/47/D1/wKioL1P_6kThejrOAAaxsonf7EI763.jpg "title=" Qq20140829104300.jpg "alt=" Wkiol1p_6kthejroaaaxsonf7ei763.jpg "/>

Error display:

Enter Password:
Mysqldump:got error:1449:the user specified as a definer (' Ljgps ' @ '% ') does not exist when using LOCK TABLES

After multiple queries, the workaround:

mysqladmin-uroot-p123456 Flush-logs;
/opt/mysql/bin/mysql-uroot-p123456

/opt/mysql/bin/mysqldump-uljgps-p Ljgps > Ljgps.sql

Add Ljgps users, do not enter the password 123456, the database will be considered too simple to expose the password is not to execute, you can:

/opt/mysql/bin/mysqldump-uljgps-p Ljgps > Ljgps.sql

Then enter the password: Enter to execute.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/47/CF/wKiom1P_60ujTpjuAAZdYlkyG5I100.jpg "title=" 9999. JPG "alt=" wkiom1p_60ujtpjuaazdylkyg5i100.jpg "/>

This article is from "Ghost" blog, please make sure to keep this source http://caizi.blog.51cto.com/5234706/1546416

MySQL Backup error logging