Nagios Support Forum

Posted: **Tue May 20, 2025 9:15 am**

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

Posted: **Fri May 30, 2025 10:03 am**

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

Nagios Support Forum

Scheduled Backups Failing

Scheduled Backups Failing

Re: Scheduled Backups Failing