Introduction

This article describes how you can move an existing MariaDB custo diagnostic database to another DB host computer.

Moveing the Database

To move an existing database you can use the "Database Converter" as descibed in this article.


Preparation

  1. First create a database backup by running the database backup task in custo service center:



  2. Wait a few minutes until the backup is complete. You'll now find a current .sql file in the "diagserverdata\backup" subdirectory:

3. Check the size of the backup file and verifry if it has more or less the same size as other previoulsy created backups - check for plausbility!

4. Set both - the custo diagnostic service and the diag DB (or Maria DB for custo diagnostic server service) to deactivated and best reboot the source system. Alternatively makle sure that both services are fully stopped and deactivated.

5. Create a new diagserverdata directory on the new system.

6. Copy the folders "backup", "blood pressure", "ecg", "ext", "lufu", "lzekg", "manuals" and "reha" (if available) from the folder "diagserverdata" from the source system to the newly created diagserverdata directory on the target system.
Please note: Do not copy the whole "mariadb" directory under any circumstances. 

7. Install custo diagnostic server on the target computer and select the newly created diagserverdata directory as data directory.

8. Make sure that the newly installed server is up and running with a custo diagnostic client, but do not be surprised about missing data (will only come back with the next steps).

9. Close the custo diagnostic clients and service centers.

10 Open a Windows CMD shell as administrator and run


Command

net stop diagserver

But the service "diagserverdb" (i.e. MariaDB) must still be running!

Now you can import the backup file with the following command to overwrite the database with the backup. For this we need the password for the database. You will find the password in the file "conf\diag.properties" located in the custo diagnostic server installation directory. This file contains the entry diag.dbPass=[...]. The password is the characters after the "=".

We first change to the directory with the backup files. Than execute the mysql command located in the installation directory of the custo diagnostic server below "mariadb\bin".
Command

"Path-to-mysql-bin-Directory\mysql.exe" -u<User> -p<Password> diagdb < "Path-to-Backup-Files\YYYY-MM-DD.db.backup.sql"

Make sure that you use here the file name which is the most recent backup you crearted before the data copy.
Example

"C:\Program Files\custo diagnostic server\mariadb\bin\mysql.exe" -uroot -pSECRET diagdb < "C:\diagserverdata\backup\2020-04-22.db.backup.sql"

This would bring back the backup from DD.MM.YYYY. Please replace this with the filename with the backup you will have to restore. Please note:

  • The password comes after -p but without spaces!
  • The user comes after -u without spaces and is always root
  • After the password comes the name of the database, which is called diagdb

Afterwards you can start the custo diagnostic server:
Command

net start diagserver


  • No labels