I took hot backup (dump) from my Master MySQL DB with below command
mysqldump -uroot -p --skip-lock-tables --single-transaction --flush-logs --hex-blob --master-data=2 -A > ~/dump.sql
Master Version: MySQL-server-5.5.41-1.el6.x86_64
At the time of restoration on slave we are getting this error, have I done something wrong.
[root@Slave ~]$ mysql -u root -p < dump.sql
Enter password:
ERROR 1449 (HY000) at line 150536: The user specified as a definer ('lipl_ga_app'@'%') does not exist
Slave Version: mysql-community-server-5.6.28-2.el6.x86_64
The DB is huge and we don't want to start the restoration process again.
@ Nawaz Sohail I have taken backup of mysql user from below command
mysqldump -u root -p mysql user > user_table_dump.sql
Restored
mysql -u root -p mysql < user_table_dump.sql
'lipl_ga_app'@'%'
and grant it proper permissions.