CODEWITHSUNDEEP
herokuamazon-web-servicesmysqlamazon-rds
rigyt
rigyt

Reputation: 2353

Transfer data between AWS RDS MySQL db's

What is the best way to transfer data out of one amazon rds mySQL instance into another aws account's RDS mySQL instance?

This is for transferring a website on Heroku to a different owner.

Upvotes: 3

Views: 2854

Answers (2)

Stefan
Stefan

Reputation: 603

I sometimes use a MySQL client (Navicat) which let's you migrate data from one DB to another. It supports syncing of DB structure, data or both. Pretty handy.

Upvotes: 2

leonardoborges
leonardoborges

Reputation: 5629

If it's that small just use the mysqldump utility from your mysql client. 

#note I'm piping it through GZip for compression. It will save you bandwidth
$ mysqldump -u user --password=passowrd -h your_rds_host db_name | gzip -c > db.sql.gz

#unzip the dump
$ gunzip db.sql.gz

#restore on the destination
$ mysql -u user --password=passowrd -h your_destination_rds_host db_name < db.sql

That should do the trick.

Upvotes: 8

Related Questions