AWS RDS MySQL Backup to S3

Published on June 10th, 2020

Islam Essam

Co-founder, SimpleBackups

Follow on Twitter

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

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.