Backup / Restore Database

Backup / Restore Database

Backup OpenRMA Data

In order to backup the database, you have to go to settings, then database management tool.

You will see the above menu. From this menu you can press the “Backup OpenRMA database” button and a backup dump (.sql file) will be created on OpenRMA folder inside the users Document directory. For example “c:\users\<username>\Documents\OpenRMA” folder.

This is a complete backup with all data used by OpenRMA (Customers, Services, Attachments, Settings and so on).

You can use this backup file (.sql file) to restore to a second OpenRMA instance machine.

 

Restore OpenRMA backup file

To restore a backup file, press the “Restore OpenRMA Database” button.

A new Dialog window opens and ask you to select a backup file to restore. After selecting your file a warning window appears and warning you about restoration. WARNING: This action will DELETE all data of the program (customers, services, attachments and so on) and it will restore the data from the backup file. So it is wise to backup your database first.

 

OpenRMADB