Manage MySQL backups

Create a new backup

You can create a manual backup of your MySQL database under Services > MySQL in just two easy steps:

1. Select the database by clicking on its label
2. Navigate to the Backups tab and locate the "Create new backup" section
3. Pick a label for the backup you're creating that describes its usage, for example before-destructive-migration. If you don't specify a label we'll generate one for you.
4. Click Create new backup.

Your backup will be created on the background. This might take a few moments, depending on the size of your database.

Restoring a backup in place

WARNING

Restoring a backup in place will overwrite the existing data in your database! If you want to keep the existing data in your database, check out restoring a backup to a new database.

To restore a backup of your database in place, you can follow these five steps under Services > MySQL:

1. Select the database by clicking on its label
2. Navigate to the Backups tab and locate the backup you want to restore in place
3. Click the Restore button
4. Locate the "Restore in place" section
5. Click Restore in place.

Your backup will be restored into your existing database. This might take a few moments, depending on the size of your database.

Restoring a backup to a new database

You can restore a backup to a new MySQL database under Services > MySQL in these easy steps:

1. Select the database by clicking on its current label
2. Navigate to the Backups tab and locate the backup you want to restore to another database
3. Click the Restore button
4. Locate the "Restore to new database" section
5. Pick a new label for the database that describes its usage, for example production-db
6. Click Restore to a new database.

Your backup will be restored to a new database. This might take a few moments, depending on the size of your database.