We are migrating 30GB size production database from Noah cloud server to Amazon MySQL RDS server.
To reduce the production downtime, we're trying to restore the full DB dump file in one day and binary log file on another day to up the database in Amazon MySQL RDS server.
We restored the full dump file through EC2 instance by moving the MySQL dump file. But when we try to restore the binary log file from Amazon EC2 instance, we're getting the following error:
ERROR 1227 (42000) at line 8: Access denied; you need (at least one of) the SUPER privilege(s) for this operation.
Note: We did google and changed the Amazon MySQL parameter log_bin_trust_function_creators=1
and restarted the server.
But we're still facing the above issue. Please help on fixing the issue. Thanks in advance.
Aucun commentaire:
Enregistrer un commentaire