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.

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.