Scheduled Backups Failing

[bpg]

Hi all

Hoping someone can assist me with an issue relating to our scheduled backup ...

It has recently come to light that the scheduled backups are failing.
The notification states the following:

Code: Select all

View your full scheduled backup logs at /usr/local/nagiosxi/var/components/scheduledbackups.log to find out more details about the error. Your backup may have timed out, you can set a backup_timeout variable in config.inc.php to increase it. 

Viewing '/usr/local/nagiosxi/var/components/scheduledbackups.log' shows the following:

Code: Select all

 Backing up MySQL databases...
error: Found option without preceding group in config file: /etc/my.cnf.d/mysql-server.cnf at line: 1
mysqldump: unknown variable 'column-statistics=0'
Error backing up MySQL database 'nagios' - check the password in this script!
05-20-2025 14:45:40 ERROR: Scheduled FTP Backup Failed: Local file to transfer does not exist 

As far as I'm aware, we are using MariaDB not MySQL .. if so, why are the errors reporting issues with backing up a MySQL DB?

Any help appreciated as my knowledge of Linux is lacking to say the least!

Thanks

[lgute]

Hi @bpg,

Thanks for reaching out.

What version of XI are you running and what distro/version?

You can check the "MySQL" version by running the following.

Code: Select all

mysql --version

You should get a response like this (MySQL)...

Code: Select all

mysql  Ver 8.0.41 for Linux on x86_64 (Source distribution)

...or this (MariaDB branch of MySQL)...

Code: Select all

mysql  Ver 15.1 Distrib 10.5.29-MariaDB, for debian-linux-gnu (x86_64) using  EditLine wrapper