Update RDS db via mysqlbinlog: "you need (at least one of) the SUPER privilege(s)"

Posted by timoxley on Server Fault See other posts from Server Fault or by timoxley
Published on 2011-07-15T02:06:10Z Indexed on 2012/06/06 16:42 UTC
Read the original article Hit count: 630

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.

Due to the size of the db, and minimal downtime requirements, I've got to update the ec2 db to the latest datas via the binlogs, and it won't let me.

mysqlbinlog mysql-bin.000004 --start-position=360812488 | mysql -uroot -p -h

and it says:

ERROR 1227 (42000) at line 6: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

My guess, based on what is on line 6 of the binlog, is that it's the 'write to the BINLOG' statements in the SQL backup, and because RDS doesn't support this, it can't run these statements, or something, I don't really know.

Please help.

© Server Fault or respective owner

Related posts about mysql

Related posts about replication