Page History

...

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

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

"Path-to-mysql-bin-Directory"cd \diagserverdata\backup
"C:\Program Files\custo diagnostic server\mariadb\bin\mysql.exe" -uroot -p<Passwort>p<Password> diagdb < 2020-01-10"Path-to-Backup-Files"\YYYY-MM-DD.db.backup.sql

Fix Example with password:
"C:\Program Files\custo diagnostic server\mariadb\bin\mysql.exe" -uroot -pbAPOhp37hpBtpSECRET diagdb < "C:\diagserverdata\backup\2020-0104-1022.db.backup.sql"

This would bring in the backup from 10DD.MM.1.2020YYYY. 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

...

You can make a backup at any time manually (even when the custo diagnostic server is running). To do so, you need the password of the database, as in "Importing the backup". The following command is used for this:

"c:\Program Files\custo diagnostic server\mariadb\binPath-to-mysql-bin-Directory"\mysqldump.exe" -uroot -p<Passwort> -r "Path-to-Backup-Files"\backup.sql diagdb

This command creates the file backup.sql which contains a backup of the database diagdb.

...

Are created automatically. First one hour after server start, then every 24h. The default location is "diagserverdata\backup".