AWS RDS MySQL Backup to S3

SimpleBackups founder

Laurent Lemaire

Co-founder, SimpleBackups

June 10, 2020

You can back up your MySQL Amazon RDS databases using SimpleBackups similar to how you back up MySQL databases and have it uploaded automatically to your Amazon S3 storage.

This will allow you to create automated SQL dumps hourly, daily or based on your preferred schedule. The dumps are just the standard SQL files which you can import/restore to any MySQL database or locally. Unlike the snapshot feature offered by AWS.

You will need to:

  1. Obtain the database credentials and the endpoint (hostname) shown below
  2. Allow SimpleBackups to connect to your Amazon RDS database

Step 1. Obtain the database credentials and the endpoint (hostname)

SimpleBackups RDS Credentials

Step 2. Allow SimpleBackups to connect to your Amazon RDS database

To do this, you can either add your server to SimpleBackups assuming that your server is whitelisted and can connect to your RDS instance, or you can use one of our cool features which is the Stand-alone Database Backup Server.

You can add the Database Backup Server by going to the database backup creation page and clicking "Enable Remote Database Backups". Afterwards you will find a server added under your account which you can use when creating database backups.

Afterwards, all you need to do is enter your RDS endpoint, database name, username, and password then you are all set.



Back to blog

Stop worrying about your backups.
Focus on building amazing things!

Free 7-day trial. No credit card required.

Have a question? Need help getting started?
Get in touch via chat or at [email protected]

Customer support with experts
Security & compliance
Service that you'll love using