Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to find the location of automatic S3 backups generated by Amazon RDS?

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:

  1. I'm paranoid, am new to the service and haven't experienced a failure to know that the backup process will actually work.
  2. 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?

like image 213
tim peterson Avatar asked Jul 23 '12 03:07

tim peterson


Video Answer


1 Answers

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.

like image 87
ceejayoz Avatar answered Sep 22 '22 11:09

ceejayoz