Backup OpenLM Server – MariaDB with HeidiSQL

Whenever an upgrade is planned or required, make sure that the database is backed up. This action is strongly recommended in order to avoid any data loss during the upgrade process. To do so, perform the steps below:

1. Open the Windows Services and stop the OpenLM Server service.

   

2. Go to Windows Start → MariaDB → HeidiSQL.

   a. Enter the following details: User, Password, Port.

   b. Select the database name.

   

   c. Click Open.

   d. If the following pop-up window appears, click Yes.

   

   The connection to the database has been established.

3. Right-click on the database name and select Export database as SQL:

   

4. Check the Create box.

   a. Data: Replace existing data.

   b. Output: ZIP compressed .sql file.

   c. Select the folder where the database backup file will be stored.

   

5. Once the backup process is completed, a message appears at the bottom: Compressing done. Click Close.