Scalingo for MySQL® Dedicated Resources Databases include automated and managed backups so you don’t have to worry about them.

Dedicated Resources databases come with continuous backups (Point-in-Time Recovery), with a recovery window ranging from 7 to 30 days depending on your database service class.

Point-in-Time Recovery Backups

Creating a Point-in-Time Recovery Backup

Point-in-Time Recovery backups are automatically created by the platform.

Configuring Point-in-Time Recovery Backups

You have nothing to do to be able to use the Point-in-Time Recovery mechanism.

Dumping the Database

On Dedicated Resources, dumps are client-managed operations. You must connect to the database yourself and run standard MySQL® tools (mysqldump).

You can run the dump from your local or development environment. In both cases, you must configure the Dedicated Resources firewall to allow connections from your chosen source before running the dump.

From Your Workstation

1. Make sure your source IP (or range) is allowlisted in the database firewall

   scalingo --database my-dedicated-db database-firewall-rules-add --cidr 203.0.113.0/24 --label "Office network"
   # or directly the public ip of the workstation:
   scalingo --database my-dedicated-db database-firewall-rules-add --cidr <public IP>/32 --label "My workstation"
   # wait for the database to be reachable from workstation
   

2. Get the database connection URI

   scalingo --database my-dedicated-db env-get SCALINGO_MYSQL_URL
   

3. Create the dump:

   mysqldump --user=<user> --password --host=<hostname> --port=<port> --ssl-mode=REQUIRED --single-transaction --set-gtid-purged=OFF --column-statistics=0 --no-tablespaces <dbname> > dump.sql
   

   Use the user, hostname, port and database name from the connection URI. Enter the database password when prompted.