Database backup and restore

(Note: The following doesn't apply to the SaaS version of Asset Center)

OT-BASE Asset Center automatically produces database backups every twelve hours that are stored in the directory that you have defined for backups in the installation process (/var/ot-base/backup by default).

If for any reason you want to trigger the creation of a database backup manually, you can do so on your server's command line by invoking the command

$ docker exec ot-base backup

Restoring a backup after installing a product update

When you install a new version of OT-BASE Asset Center, the installation script (ot-base.install) will

1. Automatically perform a backup of the current database and associated user provided file attachments
2. Automatically restore that backup after installing the new software version is completed.

Restoring a backup for crash recovery

In case you want to / have to force a recovery because your data was corrupted, your VM was destroyed etc., the recommended procedure is:

1. On the target system, manually create the folder /var/ot-base/backup
2. Make the OT-BASE distribution medium with the latest version accessible by the server
3. Execute the installation script with the parameter --no-backup, which will prevent the script to attempt producing a backup of the non-existing or corrupt database:

$ bash ot-base.install --no-backup