Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Amazon RDS automated backup

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?
like image 763
Mohith Thimmaiah Avatar asked Jul 08 '12 07:07

Mohith Thimmaiah


2 Answers

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

like image 172
Mohith Thimmaiah Avatar answered Sep 21 '22 00:09

Mohith Thimmaiah


RDS snapshot as well as EBS snapsots are stored in S3, but not accesible via the S3 interface. You can restore a whole database be clicking "Restore Snapshot" from the AWS Management Console.

like image 43
OK1 Avatar answered Sep 18 '22 00:09

OK1