I would like to get automatically MySQL backups to sync them to another provider as secondary backup.

The RDS Snapshots itself are not useful in this case because the are "hidden" in AWS and can only be restored in RDS.

Maybe there is already a working solution to get MySQL dumbs to S3.


This is not possible using RDS snapshots. AWS RDS Snapshots are "hidden" (though almost certainly in S3). They are not accessible to you, the user, at all. They can only be restored to RDS.

The only way to get data out from RDS MySQL instances is to export it using mysqldump (http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.SmallExisting.html is a guide to importing, but works equally well for exporting), or by configuring a MySQL replica (http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Exporting.NonRDSRepl.html).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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