Appearance

Amazon RDS Database ​

How to back up and restore AWS RDS Managed databases via SimpleBackups

Creating backups ​

To create backups for Amazon RDS database using SimpleBackups, follow these steps. The process is designed to be straightforward, ensuring that your Amazon RDS database is securely backed up.

You can create a Backup for any Amazon RDS Database type:

  • Amazon RDS MySQL database.
  • Amazon RDS PostgreSQL database.
  • Amazon RDS Aurora MySQL database.
  • Amazon RDS Aurora PostgreSQL database.

Prerequisites ​

  • A SimpleBackups account.
  • Access to your Amazon RDS database
  • Network access from SimpleBackups to your Amazon RDS database.

Step 1: Log in to Your Amazon RDS Account: ​

  • From the menu select “Databases”.

Amazon RDS Database screenshot 1

Step 2: Configure IP Filtering: ​

  • Select the database you want to backup.
  • Make sure that “Publicly accessible” is set to “Yes” or you can change it by “Modify” the database.
  • Open the default “VPC security groups” to add SimpleBackups IP addresses to the “Inbound Rules”:

Amazon RDS Database screenshot 2

Amazon RDS Database screenshot 3

Amazon RDS Database screenshot 4

Amazon RDS Database screenshot 5

Step 3: Copy Connection Data: ​

  • Navigate to “Connectivity & security” section and copy the “Endpoint” and “Port”.

Amazon RDS Database screenshot 6

  • Navigate to “Configuration” section and copy the “Master username”.

Amazon RDS Database screenshot 7

Step 4: Set Up Backup in SimpleBackups: ​

  • Log in to your SimpleBackups account or create a new one if needed.
  • Navigate to creating a new database backup.
  • Choose "Serverless".

Step 5: Fill the connection details: ​

  1. Manual form fill:
  • Choose the Database “Type”.
  • You can either fill the form with connection details or select "Paste Connection string" and paste the service URI.

Amazon RDS Database screenshot 8

  1. Auto form fill:
  • Click on “Connect your DBaaS Provider”.
  • Choose an Amazon RDS provider.
  • Select a managed database.
  • Click on “Load”.

Amazon RDS Database screenshot 9

Step 6: Validate and Activate Backup: ​

  • Click on "validate connection" to ensure all settings are correct and the connection can be established.
  • Once validated, finalize any additional backup settings (like scheduling) and activate the backup.

This process ensures that your Amazon RDS database is securely backed up using SimpleBackups, providing an additional layer of data protection.

Restoring backups ​

In order to restore your backup, Go to your backup page, then navigate into logs.

Amazon RDS Database screenshot 10

Click on the “i” button on the backup that’s on the point of time you’d like to restore to.

Amazon RDS Database screenshot 11

Click on the Restore tab, then generate a new download link, and copy it.

Amazon RDS Database screenshot 12

Based on your database type run these commands (for example: PostgreSQL):

bash
wget -O - "PasteTheSignedDownloadLinkHereBetweenTheQuotes" | gunzip -c > decrypted-backup.pgsql

Then, run the pg_restore command to restore your database like so:

bash
pg_restore -d "your_db_uri" ./decrypted-backup.pgsql

Amazon RDS MySQL Database backup ​

SimpleBackups supports Amazon RDS MySQL Database backup.

Amazon RDS PostgreSQL Database backup ​

SimpleBackups supports Amazon RDS PostgreSQL Database backup.

Amazon RDS Aurora MySQL Database backup ​

SimpleBackups supports Amazon RDS Aurora MySQL Database backup.

Amazon RDS Aurora PostgreSQL Database backup ​

SimpleBackups supports Amazon RDS Aurora PostgreSQL Database backup.