Backup, restore, and import data

You can create, import, and delete backups of your database or addon from the backups page, as well as restore your database or addon from an existing backup.

You can also use backups to fork an existing addon.

Snapshot (disk backup)

Snapshots save the state of the whole volume. Each new snapshot you create will only store the differences from the previous snapshot.

Snapshots are the best method for regular backups as the incremental way of storing backup data is highly efficient and uses a minimal amount of storage space.

Snapshots cannot be downloaded and do not support logging.

Dump (native backup)

Creates a text dump of the full existing database and stores it in a compressed file. Native backups are not available for all databases.

You can select either gzip or Zstandard compression when creating the dump.

Dumps can be downloaded, and logs can be viewed for backups and restores.

You can configure up to three separate backup schedules for each database or addon.

You can create one hourly, one daily, and one weekly schedule to meet your operational and legal requirements.

Create a schedule

You can add schedule from the backups schedule page on an addon to begin configuring a new backup schedule. You can also add a backup schedule to a new addon on creation.

Choose the backup type, and how often to run the backup: hourly, daily, or weekly.

You can configure each schedule by minute, hour, and day. Your schedule will then run the backup at the selected times, per the schedule frequency (hourly, daily, or weekly).

• Retention time defines how many days a backup will be stored for.
• If any backup schedules overlap, only one backup will be created at the overlapping time.
• After creating a schedule you will only be able to edit the retention period. To change any other settings, delete the current schedule and create a new one.
• Schedules can produce a maximum of 500 backups before any expire, you will be unable to create schedules that would produce more than this.

Backups from schedule

Backups created by schedule are available on the backups page for the database or addon, and detail the schedule they were created by. You can click on an individual backup to see more details and select retain backup forever to override the schedule's retention policy.

You can manually create a new backup from the backups page on a running database or addon. Choose the backup type and it will be immediately scheduled for creation. Check the entry on the backups page to view its status.

You can import a backup from a file or directly from another running database. Once imported you can restore from the imported backup.

URL or file upload

You can restore a database from a file by providing the URL to the hosted file, for example https://yourdomain.com/backups/data.db.gz, or uploading a file. If the file ends in .gz or .zst Northflank will attempt to unzip it, otherwise it will be treated as clear text. Northflank will copy the imported file, which will be used as a source when restoring the backup.

Please note that when you restore from this kind of import:

• All existing user databases will be removed. The default admin and access users and system databases will not be affected.
• All databases from the backup source will be imported
• The default admin and access users will have full access to the imported database. If these users have been deleted they will be recreated before restoring.
• If the source includes user manipulation commands (create user, grant permissions), they will be executed unless they grant too many rights

Connection string

You can restore or import from another database by providing a connection string with relevant credentials and parameters. Northflank will create a dump from the source database which you can then restore from. You can choose the type of compression to use when Northflank creates a dump of the live database.

You can download the created dump after it has been imported, in whichever compression format you selected to create it.

Please note that when you restore from this kind of import:

• All existing user databases will be removed. The default admin and access users and system databases will not be affected.
• All databases, except users, from the backup source will be imported (depending on the access of the specified user when importing by connection string)
• The default admin and access users will have full access to the imported database. If these users have been deleted they will be recreated before restoring.

You can restore your database or addon from a specific backup on the backups page. Select restore backup to immediately schedule a restoration.

Each listed backup displays the following information:

You can click on the entry in the list to view the backup logs, restore history, and abort scheduled restorations. Each backup has the following available actions:

You can reset an addon from the billing page. Resetting an addon will erase all the data, and restore it to the state of a newly-provisioned addon. If you reset an addon that was created by forking an existing addon, the backup must still be available to restore from.

This can be used to reset the addon's data while retaining the same connection details used in any environment variables, secret groups, or to connect locally.