How to find the location of automatic S3 backups generated by Amazon RDS?
amazon-rds, amazon-s3, amazon-web-services, database-backups, mysql
Solution
No, you can't access the S3 bucket RDS uses. If you'd like to confirm that the backups work, you can restore to a point in time via the RDS console. This creates a new RDS instance that uses the backup for that point in time.
Problem
I've read that Amazon RDS automatically backs up your database to S3. I'm wondering how can I actually see these backups and their contents? The reasons I want to see them are: - I'm paranoid, am new to the service and haven't experienced a failure to know that the backup process will actually work. - I've read that the backups don't work if some of your tables are MyISAM. That is, I need to have all my tables be InnoDB and not a mix of the two for the s3 backups to be generated. Does anyone have more information on this?