Scalingo for MySQL® Dedicated Resources databases are automatically backed up. Point-in-time recovery (PITR) lets you restore your database to a specific point within your plan’s Recovery Window.

You can restore your database either from a managed continuous backup, or from a customer-provided dump.

Restoring from a continuous backup

Point-in-Time Recovery is a fully managed restore operation available from the database dashboard.

Using the Database Dashboard

1. From your web browser, open your database dashboard
2. Click the Backups tab
3. Locate the Point-in-Time Recovery block
4. Click the Start a PiTR button
5. Pick a timezone, then a date and time (default timezone is your browser timezone)
6. Make sure to check the I understand that this action will permanently delete existing data and cannot be cancelled or undone once started. checkbox
7. Validate by clicking the Confirm button

Restoring from a customer-provided dump

On Dedicated Resources, dump restore is a client-managed operation. You must connect to the database yourself and run standard MySQL® tools (mysql).

You can run the restore 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 restore.

From Your Workstation

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

   scalingo --database my-dedicated-db-id 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-id 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-id env-get SCALINGO_MYSQL_URL
   

3. Restore the dump:

   mysql --user=<user> --password --host=<hostname> --port=<port> --ssl-mode=REQUIRED <dbname> < dump.sql
   

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