Backup and restore

A database containing important information should be backed up regularly. This is a universal pattern for all applications using a database.

PermeAgility allows for the database to be backed up and restored. 

To perform a backup or restore operation, select the Backup/Restore menu item:

Backup

You can enter a file name or accept the default generated file name.  Click Backup now to backup the database to a file in the backup directory. 

Hint: Call the backup 'starterdb' and you can put it up into the main directory when you want to deploy the application with the database. It will be automatically loaded when a new database is created.

Restore

Click the Restore Now button beside the backup file you want to load. You will be asked to confirm and the database will be restored.

Note: Your existing database directory is renamed to <db>_saved in this process and the server will be restarted (or exit if not running in a script that supports restart - restart the server to restart the server and load the backup)

Note: During this process, the server will lock out users. A property will also be written to the init.pa file to indicate the file to restore - cleared when the restore is complete.

Note: You can only do restore function on a default embedded database, restore is not supported on a remote database (you can still restore, but you will have to do it manually)