Backups and restore

Browse backup jobs and restore files, MySQL, and PostgreSQL data for a host.

The host's Backups tab lets you browse backup jobs and restore data from them. You can restore files and databases to different targets so you can verify recovered data before it overwrites your live environment.

The Backups tab of a host
The Backups tab of a host

This tab covers:

  • Automatic backups - the scheduled backups TurboStack takes for you
  • Browsing backup jobs - find a backup and open its contents
  • Creating an on-demand backup - start a backup yourself
  • Tracking backup jobs - follow backup and restore jobs in progress
  • Restoring files - recover files to a chosen target
  • Restoring MySQL - recover MySQL databases, tables, or a dump
  • Restoring PostgreSQL - recover PostgreSQL databases, tables, or a dump

Automatic backups

TurboStack takes automatic daily backups of your host, kept for 20 days, in addition to the on-demand backups you can start yourself. Backups cover your files and databases. Use the steps below to browse and restore from any available backup.

Browsing backup jobs

Each backup job in the list shows:

Field Description
Job ID The unique identifier for the backup job.
Date/time When the backup was taken.
Size The size of the backup.
Actions A Contents button opens the backup so you can browse it and choose what to restore.

Backups are grouped by content type - Files, MySQL and PostgreSQL - which you select on the left. When you start a restore, a dialog opens and updates automatically with progress until the restore completes.

Creating an on-demand backup

Besides the automatic scheduled backups, you can create a backup yourself at any time.

  1. Open the host's Backups tab and select Create Backup from the left.

  2. In the dialog, tick what to include - Files, MySQL and/or PostgreSQL. The database options appear only for the databases enabled on the host.

  3. Click Create Backup.

The Create Backup dialog with the Files, MySQL and PostgreSQL options
The Create Backup dialog with the Files, MySQL and PostgreSQL options

Tracking backup jobs

The Jobs entry on the left shows the status of backup and restore jobs in progress, so you can follow a running backup or restore to completion. Each row lists the user, the date, the job type, the backup type, the status and the time it finished; the eye icon at the end of a row opens the job's details.

The Jobs list on the Backups tab, with Create and Restore jobs and their statuses
The Jobs list on the Backups tab, with Create and Restore jobs and their statuses

Restoring files

The restore dialog - browse a backup's files and choose a target
The restore dialog - browse a backup's files and choose a target

When you restore files, choose one of the following targets:

Target Description
Recovery folder Restore into the dedicated ~/hprestore folder.
Overwrite existing Restore files back to their original location, overwriting what is there.
Custom path Restore into a path you type, so you can recover to a specific location.

To restore files:

  1. Open the host's Backups tab.

  2. Select the backup job you want to restore from.

  3. Choose Files as the content type.

  4. Select a target: the ~/hprestore recovery folder, overwrite existing files, or a custom path you enter.

  5. Start the restore and follow the progress in the dialog.

Restoring MySQL

To restore MySQL data:

  1. Open the host's Backups tab.
  2. Select the backup job you want to restore from.
  3. Choose MySQL as the content type.
  4. In the tree browser, select the databases (and, if needed, individual tables) to restore from the backup.
  5. Start the restore. The selected data is restored into your ~/hprestore folder, not directly into the live database - from there you can review and import it.

Restoring PostgreSQL

PostgreSQL restores the same way as MySQL:

  1. Open the host's Backups tab.
  2. Select the backup job you want to restore from.
  3. Choose PostgreSQL as the content type.
  4. In the tree browser, select the databases (and, if needed, individual tables) to restore from the backup.
  5. Start the restore. The selected data is restored into your ~/hprestore folder, not directly into the live database - from there you can review and import it.