Update RDS db via mysqlbinlog: "you need (at least one of) the SUPER privilege(s)"
- by timoxley
We are moving a production site to EC2/RDS
Followed these instructions:
http://geehwan.posterous.com/moving-a-production-mysql-database-to-amazon
I have set up row-based binary logging on the production server
did a:
mysqldump --single-transaction --master-data=2 -C -q
-u root -p backup.sql
then imported to RDS instance. No dramas.
…
