MariaDB database backup

Due to specific features of the data storage of Jems you should rely on the tool below to keep the backup data consistent.

Jems uses 'system-versioned' tables in MariaDB, therefore mysqldump will not work as desired, i.e. no historical data will be exported.

MariaDB is running in a container

In case your MariaDB is running in a container, your data is being stored in a data volume. Backup of a docker data volume can be easily done, see docker documentation: https://docs.docker.com/storage/volumes/#backup-restore-or-migrate-data-volumes

MariaDB is installed as normal service

In case you have MariaDB as normal linux process (not in a container) you will need to do backup in the most desirable form:

1. Your IT provider has snapshots of the logic drive where DB is stored.

2. You “manually” compress the whole directory where MariaDB stores your data.

   1. Data directory location is controlled by the datadir variable. Look at your /etc/mysql/my.cnf file to see where your installation of MariaDB is configured to store data. The default is /var/lib/mysql but it is often changed, like for example if you are using a RAID array.

3. You use an official tool that supports the proper backup of MariaDB data: https://mariadb.com/docs/recovery/mariadb-enterprise-backup/