Managing backups of your database is important and something you should consider to do quite often.

Luckily it is easy to create a backup in Helium as well as restoring a backup.


Create a backup

To create a backup, click FILE > Backup.

Select which information to include in the backup, most often all items.

Select the destination path where the backup should be stored (as a ZIP file) and click OK to create it.


Restoring a backup

To restore a backup, click FILE > Restore.

First select the backup file, then click Next >


The next step allows you to select which information you would like to restore, generally all information.

Depending on which database type your backup contains you may also need to fill in additional fields related to the database connections.


Database specific restore options


SQLite

"Database" shall be set to a filename which the database in the backup will be restored into. 


SQL Server

"Server" shall be set to the address of the SQL Server that will be used to restore the backup into.

"Database" shall be set to a database name you would like restore the backup into. This database cannot be an existing database.

"Path" shall be set to a directory where the database in the backup will be restored to physically. It needs to be specificed explicitly due to SQLServer's user system, where not all Windows users might have proper rights to the backup/restore folders. 


MySQL/MariaDB

"Server" shall be set to the address of the MySQL/MariaDb server that will be used to restore the backup into.

"Database" shall be set to a database name you would like restore the backup into. This database cannot be an existing database.

 


When all data is entered, click OK to restore the selected data.