MySQL Amazon RDS – How to Automatically Backup Database

amazon-rdsMySQL

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.

Best Answer

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).