Q:

Migrating existing database to Amazon RDS

How can I import existing MySQL database into Amazon RDS?

A:

I found this page on the AWS docs which explains how to use mysqldump and pipe it into an RDS instance. 
Here's their example code (use in command line/shell/ssh):
mysqldump acme | mysql --host=hostname --user=username --password acme
where acme is the database you're migrating over, and hostname/username are those from your RDS instance.
You can connect to RDS as if it were a regular mysql server, just make sure to add your EC2 IPs to your security groups per this forum posting.
I had to include the password for the local mysqldump, so my command ended up looking more like this:
mysqldump --password=local_mysql_pass acme | mysql --host=hostname --user=username --password acme
FWIW, I just completed moving my databases over. I used this reference for mysql commands like creating users and granting permissions.
Hope this helps!

A:

There are two ways to import data : 

mysqldump : If you data size is less than 1GB, you can directly make use of mysqldump command and import your data to RDS.
mysqlimport : If your data size is more than 1GB or in any other format, you can compress the data into flat files and upload the data using sqlimport command.

A:

I'm a big fan of the SqlYog tool.  It lets you connect to your source and target databases and sync schema and/or data.  I've also used SQLWave, but switched to SqlYog.  Been so long since I made the switch that I can't remember exactly why I switched.  Anyway, that's my two cents.  I know some will object to my suggestion of Windows GUI tools for MySQL.  I actually like the SqlYog product so much that I run it from Wine (works flawlessly from Wine on Ubuntu for me). 
This blog might be helpful.

