Amazon RDS automated backup

amazon-web-services backup amazon-rds database-backups
Mohith Thimmaiah picture Mohith Thimmaiah · Jul 8, 2012 · Viewed 9.5k times · Source

I can see from the AWS console that my RDS instance is being backed up once a day. From the FAQ I understand that it is being backup on S3. But when I use the console to view my S3 buckets, I don't see the RDS backup.

So:

  1. How do I get my hands on my RDS backup?
  2. Once I have it how do I use it to restore my DB i.e is it a regular mysqldump file or something else?

Answer

Mohith Thimmaiah picture Mohith Thimmaiah · Jul 8, 2012

OK - I see it under the DB snapshots, Automated Snapshots (Had it selected to Manual Snapshots and hence could not see it)

Related questions

Backup strategies for AWS S3 bucket

I'm looking for some advice or best practice to back up S3 bucket. The purpose of backing up data from S3 is to prevent data loss because of the following: S3 issue issue where I accidentally delete this data from …

Read More
Backup: Amazon S3 or Glacier - lots of little files?

I'm trying to understand the complicated Amazon Glacier pricing model. I don't want to store a huge amount of data, a few GB's say 10. I hope never to download the files and if I did need to I don't care …

Read More
Permission denied (publickey) when SSH Access to Amazon EC2 instance

I want to use my Amazon ec2 instance but faced the following error: Permission denied (publickey). I have created my key pair and downloaded .pem file. Given: chmod 600 pem file. Then, this command ssh -i /home/kashif/serverkey.pem ubuntu@…

Read More