download RDS snapshot

MysqlAmazon Web-ServicesAmazon Rds

Mysql Problem Overview


I recently downgraded my EC2 instance. I can no longer connect to RDS. I think it might be that the internal IP is different and now the logins are attached to that specific IP. I haven't been able to figure it out. I would like to be able to get a backup from the snapshot. Is there a way to download it through AWS?

Mysql Solutions


Solution 1 - Mysql

You can't download an RDS snapshot. You can however connect to it and export your databases. Downgrading your instance should not affect connectivity unless you had set up your security groups incorrectly (Opening ports to an IP instead of another security group).

Solution 2 - Mysql

The accepted answer is not up-to-date anymore. Instead of using command line tools, you can use the AWS console.

Navigate to RDS -> Snapshots -> Manual/System ->

Select Snapshot -> Actions -> Export to S3

Going through S3 is common in most production environments, as you won't have direct access to the DB instance.

AWS RDS Console with Export to S3

Solution 3 - Mysql

In addition to datasage answer.

As an option for production instance you can create a readonly replica in RDS and make dumps from this replica. You could avoid freezing of production DB this way.

We use this scheme for PostgreSQL + pg_dump. Hope it will be helpful to somebody else too.

Solution 4 - Mysql

I use:

pg_dump -v -h RDS_URL -Fc -o -U username dbname > your_dump.sql

Solution 5 - Mysql

I also needed to do this so I created a dump of the db (MySQL) by logging into my app server which has permissions to access the db. I then downloaded the dump to my local machine using scp. I used:

mysqldump -uroot -p -h<HOST> --single-transaction <DBNAME> > output.sql

Solution 6 - Mysql

Another option is to share your snapshot if you don't need to download it and just want to share it with a different AWS account ID.

Solution 7 - Mysql

It sounds like your RDS is within a VPC inside a private subnet with security group and ACL. The only way to solve your issue is to take a snapshot and cerate a new DB instance out of it within the default VPC where all connections are allowed. After that you take backup classic backup using a db client or CLI.

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionWilliamView Question on Stackoverflow
Solution 1 - MysqldatasageView Answer on Stackoverflow
Solution 2 - MysqlrfreytagView Answer on Stackoverflow
Solution 3 - MysqlabguyView Answer on Stackoverflow
Solution 4 - MysqlÉdipo FéderleView Answer on Stackoverflow
Solution 5 - MysqlKazView Answer on Stackoverflow
Solution 6 - MysqlDavid DehghanView Answer on Stackoverflow
Solution 7 - MysqlJava MainView Answer on Stackoverflow