Clever Geek Handbook

How do I take a backup of my data to my local computer from AWS?

I would like to have a copy of the database on my local machine with Amazon AWS RDS. How can i do this?

+3


source to share


1 answer


You can connect to the instance using any tool that dumps the database for the type of database you are using. For example mysqldump if you have a MySQL or Aurora database.

If the database instance is not accessible to the internet, you will need to dump from the EC2 instance that is on the correct subnet and security groups to talk to the database or ssh tunnel through the instance to run mysqldump.



Note that by default RDS is set to take daily snapshots of your database (which are stored in AWS so you cannot upload them), but you can restore them if something goes wrong. You can also take a manual snapshot at any time using the AWS Web Console or API. You can also start a new database from a snapshot and connect to it to create a local dump from a snapshot instead of the active database.

+8


source






More articles:


All Articles