How to manage backups for Database Instances

Manual backups are useful in cases when you need to have a backup of a specific state of the Database Instance. They can be created for all Database Instances with Local Storage.

You can create manual backups for Database Instances with Block Storage if the Database Instance storage is inferior or equal to 585 GB.

Before you startLink to this anchor

To complete the actions presented below, you must have:

• A Scaleway account logged into the console
• Owner status or IAM permissions allowing you to perform actions in the intended Organization
• A PostgreSQL or MySQL Database Instance

How to create manual backupsLink to this anchor

1. Click the Backups tab on your selected Database Instance’s information page.
2. Click Create backup.
3. Enter a name for the backup, choose the database and set an expiration date for the backup to be removed automatically.
   Note

   You can click «See more Icon» > Edit to change the name and expiration anytime.

4. Click Create backup to launch the backup process for the database.

How to restore backupsLink to this anchor

1. Click the Backups tab on your selected Database Instance’s information page.
2. Click «See more Icon» > Restore next to the name of the backup you want to restore. A pop-up displays.
3. Select the Database Instance and the database to which you wish to restore the backup.
4. Click Restore backup.
   Note

   Large database backups can take up to several hours to restore.

How to export backupsLink to this anchor

1. Click the Backups tab on your selected Database Instance’s information page.
2. Click «See more Icon» next to the name of the backup you want to export.
3. Click Prepare export. Once the export is prepared, the Download button displays.
4. Click Download.
   Note

   PostgreSQL backups are exported in the PostgreSQL compression format. MySQL backups are compressed in .gzip.

How to delete backupsLink to this anchor

When you delete a Database Instance, the backups and snapshots created with the autobackup feature are not automatically deleted. Automatic backups can be manually deleted or will be purged after the retention period defined in the backup schedule configuration.

1. Click the Backups tab on your selected Database Instance’s information page.
2. Select the backup you wish to delete.
3. Click «See more Icon» >Delete
4. Click Delete backup to confirm.