Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm investigating running regular MySQL dumps to an S3 bucket as part of a disaster recovery strategy (partly spurred by the current zero cost of inbound data transfer!). In the event of a disaster, I would want to restore the dump file from S3 to a new RDS instance. Despite extensive searching, I can't find any examples of this. Does anyone know if this is possible?

To give a bit of context, it's a 500GB write-heavy read-light 24x7 MySQL database. I'm planning to use MySQL replication to a slave, which we can then take dumps from to send to S3 in case of a host failure (we use the same hosting provider for the replication master and slave, although they are in different data centres).

share|improve this question

Currently there's not such feature in RDS, as explained in:

But AWS guys recommend this procedure:

share|improve this answer

It worked for me when I tried to backup a mysql server running in my machine to RDS mysql. (my machine was running windows, but it should work for linux mysql dump as well)

mysqldump -u root -p --databases 'mydatabase' > dump.sql

then, just upload to the RDS instance:

mysql -h -u myuser -p < dump.sql

share|improve this answer
Thanks for the suggestion, but I'm not sure that really helps. This will push the data from your local machine using your MySQL client to the RDS instance. I need to get the data from an S3 bucket straight into RDS. As I said in the question, the database is pretty big - our zipped dump files are around 25GB, so I can't wait several hours for them to download to a local machine and then transfer up to RDS. – Mark B Sep 16 '11 at 7:18

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.