AWS RDS MySQL Backup to S3

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.

If you decide to use the Database Backup Server you can add it by going to the servers page on your dashboard and clicking "Enable Remote Database Backups". Afterwards you will find a server added under your account which you can use when creating database backups. Don't forget to whitelist the following IP addresses and allow them to connect to your database.

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



тнаBack to blog

Ready to automate your backups?

Sign up for FREE. Get started in less than one minute.

Secure your backups

No credit card required. Free 7-day trial.