Appearance

OVH Database ​

How to back up and restore OVH Managed databases via SimpleBackups

Creating backups ​

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

You can create a Backup for any OVH Database type:

  • OVH MySQL database.
  • OVH PostgreSQL database.
  • OVH Redis database.
  • OVH MongoDB database.

Prerequisites ​

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

Step 1: Log in to Your OVH Account: ​

  • Navigate to the databases section under public cloud in your OVH dashboard.

OVH Database screenshot 1

Step 2: Configure IP Filtering: ​

  • Select the database you want to backup.
  • Go to the "Authorised IPs" section.
  • Add SimpleBackups IP addresses to the whitelist:

OVH Database screenshot 2

OVH Database screenshot 3

Step 3: Copy Connection Data: ​

  • From the "Login Information" section.
  • Copy connection details or copy the service URI .
  • Download the CA Certificate.
  • From the “Users” tab you can get user details or reset user password.

OVH Database screenshot 4

OVH Database screenshot 5

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.

OVH Database screenshot 6

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

OVH Database screenshot 7

  • Under "Certificate / TLS," select "REQUIRED" mode.
  • Paste the downloaded CA certificate in the designated field.

OVH Database screenshot 8

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 OVH 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.

OVH Database screenshot 9

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

OVH Database screenshot 10

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

OVH Database screenshot 11

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

OVH MySQL Database backup ​

SimpleBackups supports OVH MySQL Database backup.

OVH PostgreSQL Database backup ​

SimpleBackups supports OVH PostgreSQL Database backup.

OVH Redis Database backup ​

SimpleBackups supports OVH Redis Database backup.

OVH MongoDB Database backup ​

SimpleBackups supports OVH MongoDB Database backup.