How do I download an Amazon RDS database from an instance?

Question

A while ago, I shut down an RDS instance and took a snapshot. Now, a year later, I'd like to download that database. So I restored the snapshot by creating a new instance which is up and running. But I cannot figure out how to download the db.

I have tried connecting to the database via phpMyAdmin but it keeps refusing to connect (even though I have added the IP for phpmyadmin to the security group on amazon). Is there a way to download the database via command line? Something else has to be easier...

Use the `mysqldump` command to dump the database to a text file. — Barmar, Sep 13 '13 at 22:24
Possible duplicate of [download RDS snapshot](https://stackoverflow.com/questions/14916899/download-rds-snapshot) — webjunkie, Nov 28 '18 at 12:19

score 4 · Accepted Answer · edited May 23 '17 at 12:09

4

There is no other way but connecting to your instance and using any tool you might want to use to do the job - backup

This question was answered before.

download RDS snapshot

edited May 23 '17 at 12:09

Community

1
1

answered Sep 15 '13 at 02:38

Felipe Garcia

2,263
1
16
19

How do I download an Amazon RDS database from an instance?

1 Answers1