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 of storage.
You may need certain IAM permissions to carry out some actions described on this page. This means:
- you are the Owner of the Scaleway Organization in which the actions will be carried out, or
- you are an IAM user of the Organization, with a policy granting you the necessary permission sets
- You have an account and are logged into the Scaleway console
- You have a PostgreSQL or MySQL Database Instance
How to create manual backups
- Click the Backups tab on your selected Database Instance’s information page.
- Click Create backup.
- 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.
- Click Create backup to launch the backup process for the database.
How to restore backups
- Click the Backups tab on your selected Database Instance’s information page.
- Click «See more Icon» > Restore next to the name of the backup you want to restore. A pop-up displays.
- Select the Database Instance and the database to which you wish to restore the backup.
- Click Restore backup.
Note:
Large database backups can take up to several hours to restore.
How to export backups
- Click the Backups tab on your selected Database Instance’s information page.
- Click «See more Icon» next to the name of the backup you want to export.
- Click Prepare export. Once the export is prepared, the Download button displays.
- 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.
- Click the Backups tab on your selected Database Instance’s information page.
- Select the backup you wish to delete.
- Click «See more Icon» >Delete
- Click Delete backup to confirm.