All Categories
Database Backup
Vultr Database

Vultr Database

How to back up and restore Vultr Managed databases via SimpleBackups

Creating backups

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

You can create a Backup for any Vultr Database type:

  • Vultr MySQL database.
  • Vultr PostgreSQL database.
  • Vultr Redis database.

Prerequisites

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

Step 1: Log in to Your Vultr Account:

  • Navigate to the databases section under products in your Vultr dashboard.
      • Notion image

Step 2: Configure IP Filtering:

  • Select the database you want to backup.
  • Go to the "Trusted Sources" section.

Step 3: Copy Connection Data:

  • From the "Connection Details" section.
  • Copy connection details or copy the service URI “Copy MySQL URL”.
  • Download the CA Certificate.
      • Notion image

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.
          • Notion image
  1. Auto form fill:
      • Click on “Connect your DBaaS Provider”.
      • Choose a Vultr provider.
      • Select a managed database.
      • Click on “Validate”.
          • Notion image
  • Under "Certificate / TLS," select "REQUIRED" mode.
  • Paste the downloaded CA certificate in the designated field.
      • Notion image

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

Notion image

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

Notion image

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

Notion image

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

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

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

pg_restore -d "your_db_uri" ./decrypted-backup.pgsql
💡
Make sure that you have pg_restore updated to the latest version to avoid facing restore issues.
 

Vultr MySQL Database backup

SimpleBackups supports Vultr MySQL Database backup.

Vultr PostgreSQL Database backup

SimpleBackups supports Vultr PostgreSQL Database backup.

Vultr Redis Database backup

SimpleBackups supports Vultr Redis Database backup.

Did this answer your question?
😞
😐
🤩

Last updated on June 13, 2024

Exoscale PostgreSQL OVH Database