Having done this a few times with mysql-to-mysql moves across datacenters theres a couple things I would like to mention. I dont know what Amazon RDS is like r

Having done this a few times with mysql-to-mysql moves across datacenters theres a couple things I would like to mention. I dont know what Amazon RDS is like replaying binary logs but in mysql 5.0 I faced a bug where temporary table creation statements were being ignored. This was a huge problem from us and at the time could not find a work around. Here is the related mysql bug http://bugs.mysql.com/bug.php?id=35583 http://bugs.mysql.com/bug.php?id=35583 While this move has successfully worked for the author I hope if you ever do a database move you'll do a test run first. I've experience numerous bugs in mysql replication and replaying binary logs due to temporary tables, duplicate keys due to different auto insert ids and procs/trigs/funcs causing some havoc.