Introduction:
The article descibes Basic information on the MariaDB.
The custo diagnostic server can work with MariaDB databases. (https://mariadb.org/). MariaDB is an open-source MySQL database.
| Table of Contents |
|---|
Installation
The installation runs through the setup, a service is installed "diagserverdb". This service then runs mysqld.exe server, which provides the data.
Default call: c:\Program Files\custo diagnostic server\mariadb\bin\mysqld.exe "--defaults-file=c:\diagserverdata\mariadb\my.ini" "diagserverdb"
Services
The database then runs on the localhost of the server under port 3306.
By default, the MariaDB server data is located in the same directory as the CST files in the mariaDB
Konfiguration-File
It's here: c:\diagserverdata\mariadb\my.ini
And describes the location, data directories and port of the database
Tools
Basic tool to look into the database: HeidiSQL https://www.heidisql.com/
...
Extended tool (fee required, except express version): dbForge Sutdio for MySQL https://www.devart.com/de/dbforge/mysql/studio/
Logfiles
The Basic Logfile is *.err Datei und liegt in c:\diagserverdata\mariadb
...
https://mariadb.com/kb/en/library/overview-of-mariadb-logs/
Issues during installation / Reinstallation
If you reinstall the custo diagnostic server for update purposes (but you should actually use the update function of the setup), errors may occur under certain circumstances.
...
If the error occurs after the new installation that the database can no longer be started, you can correct the error by first uninstalling the custo diagnostic server again as described above. Then you must delete the multi-master.info, all *relay* files and all *.info files in the database directory. Afterwards, you should try a new installation.
Importing the backup
In the Diag data directory there are SQL scripts in the "backup" directory that represent a backup of the entire Diag database in MariaDB. These scripts can be reimported for backup purposes. However, it may be necessary to make a backup before importing the backup itself (see "Making a Backup")
...
| Code Block | ||
|---|---|---|
| ||
net start diagserver |
Create a Backup
You can make a backup at any time (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:
...
This command creates the file backup.sql which contains a backup of the database diagdb.
Automatic Backups
Are created automatically. First one hour after server start, then every 24h.
...