Skip to main content

Restore from backup

Restoring recovers your data as it stood at a chosen restore point. Every successful backup job run produces one, so what you can recover to is decided by how often your backup jobs run.

Restore works on every supported engine. If you need the state at an exact moment rather than at the last backup, use Recover to point in time instead.

warning

Restoring creates a new database. It does not overwrite the existing one, so plan for the additional quota and update your application's connection details afterward.

Prerequisites​

  • At least one successful backup exists, giving you a restore point. See Configure backup schedule.
  • Enough remaining quota for a second database alongside the original.

Restore a database​

  1. From the main menu, select Database Platform → All Database, or your engine category.

  2. Click the database ID, open the Backup tab, then the Restore sub-tab. The page lists Available restore point with each backup's type, full or differential.

    List of available restore points with backup types

  3. In the Actions column, click the ellipsis icon for your restore point, then select Restore.

    Restore Database dialog with cluster name and flavor fields

  4. Fill in the fields:

    • Restore cluster name: the name for the new database.
    • Flavor: the compute configuration for the new database.

  5. Click Restore.

The new database appears in the database list holding the data from that backup.

After restoring​

The restored database is independent of the original. Nothing is carried over automatically, so before you cut traffic across:

  • Point your application at the new endpoint. The old connection string still reaches the original database.
  • Set up the backup service and backup jobs again on the new database.
  • Delete the database you replaced once you are satisfied with the restore, so it stops consuming quota.

Next steps​