mysqlバックアップエラー

エラーメッセージ:
Enter password:
mysqldump: Got error: 1449: The user specified as a definer ('startnews24’@’%’) does not exist when using LOCK TABLES

解決対策:
mysqladmin -uroot -pyauu flush-logs;
/opt/mysql/bin/mysql -uroot -pyauu

/opt/mysql/bin/mysqldump -ustartnews24 -pstart_pwd > startnews24_0907.sql

MySQL

Posted by arkgame