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 start

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 backups

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 backups

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 backups

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 backups

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.