Sidebar navigationMain contentFooter
Jump toContribute on Github

How to manage backups for Database Instances

Reviewed on 18 December 2023Published on 10 March 2021

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.

Requirements

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.

Security & Identity (IAM)

To perform certain actions described below, you must either be the Owner of the Organization in which the actions will be performed, or an IAM user with the necessary permissions.

Requirements
  • You have an account and are logged into the Scaleway console
  • You have 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.
See also
How to enable autobackupHow to manage snapshots
Cloud Products & Resources
  • Scaleway Console
  • Compute
  • Storage
  • Network
  • IoT
  • AI
Dedicated Products & Resources
  • Dedibox Console
  • Dedibox Servers
  • Network
  • Web Hosting
Scaleway
  • Scaleway.com
  • Blog
  • Careers
  • Scaleway Learning
Scaleway Docs
Follow us
FacebookTwitterSlackInstagramLinkedin
ContractsLegal NoticePrivacy PolicyCookie PolicyDocumentation license
© 1999-2024 – Scaleway SAS