Introduction
The This article descibes Basic basic information on the MariaDB.
The custo diagnostic server can work with MariaDB databases. (https://mariadb.org/). MariaDB is an open-source MySQL database.toc
Installation
The installation runs through the setup, a service is installed "diagserverdb". This service then runs mysqld.exe server, which provides the data.
Default setting: c:\Program Files\custo diagnostic server\mariadb\bin\mysqld.exe "--defaults-file=c:\diagserverdata\Default call:mariadb\my.ini" "diagserverdb"
Services
The database then runs on the localhost of the server under with port TCP 3306.
By default, the MariaDB server data is located in the same directory as the CST .cst files in the mariaDBMariaDB
...
Configuration File
It's The default location is here: c:\diagserverdata\mariadb\my.ini
And describes the location, data directories and port of the database.
Tools
Basic tool to look into work with the database: HeidiSQL https://www.heidisql.com/
...
Extended tool (fee required, except express version): dbForge Sutdio Studio for MySQL https://www.devart.com/de/dbforge/mysql/studio/
...
The main logfile is *.err
and is located in c:\diagserverdata\mariadb
The name consists of the workstation server computer name and the file extension .err
...
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\mysqldump.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.
...