...
For the following instructions please run a Windows CMD Shell as administrator.
First the diagserver must be shut down:
| Code Block | ||||
|---|---|---|---|---|
| ||||
net stop diagserver |
But the diagserverdb service (i.e. MariaDB) must still be running!
...
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 below "mariadb\bin".
| Code Block | ||||
|---|---|---|---|---|
| ||||
"Path-to-mysql-bin-Directory"\mysql.exe -uroot -p<Password> diagdb < "Path-to-Backup-Files"\YYYY-MM-DD.db.backup.sql |
...
Afterwards you can restart the custo diagnostic server:
| Code Block | ||||
|---|---|---|---|---|
| ||||
net start diagserver |
Create a Backup
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:
| Code Block | ||||
|---|---|---|---|---|
| ||||
"Path-to-mysql-bin-Directory"\mysqldump.exe -uroot -p<Passwort> -r "Path-to-Backup-Files"\backup.sql diagdb |
| Code Block | ||||
|---|---|---|---|---|
| ||||
"C:\Program Files\custo diagnostic server\mariadb\bin\mysql.exe" -uroot -pSECRET -r "C:\diagserverdata\backup\2020-04-22-002.db.backup.sql" diagdb |
This command creates the file backup.sql which contains a backup of the database diagdb.
...