Nagios Support Forum

We have recently enabled Nagios backups. But for some reason daily mysql backups under nagios dir are taking lot of space and are not zipped. Example below :

path : /store/backups/mysql/daily/nagios

[root@NagiosXI nagios]# ls -l
total 5533120
-rw-r--r-- 1 root root 85077832 Dec 1 2013 nagios_2013-12-01_07h00m.Sunday.sql.gz
-rw-r--r-- 1 root root 89799234 Dec 2 2013 nagios_2013-12-02_07h00m.Monday.sql.gz
-rw-r--r-- 1 root root 91895116 Dec 3 2013 nagios_2013-12-03_07h00m.Tuesday.sql.gz
-rw-r--r-- 1 root root 91817287 Dec 4 2013 nagios_2013-12-04_07h00m.Wednesday.sql.gz
-rw-r--r-- 1 root root 5307314176 Sep 5 07:03 nagios_2014-09-05_07h00m.Friday.sql

As you can see the latest file(nagios_2014-09-05_07h00m.Friday.sql) generated is ~5.0G. Anyway we can have the daily file that is being generated zipped by default.
In /root/scripts/automysqlbackup script, COMP=gzip, but still the daily file is not zipped.

-- Anil

We have recently enabled Nagios backups.

What do you mean? These backups should be enabled by default. They are run on a cron.
Have you modified the "/root/scripts/automysqlback" script?

lmiltchev wrote:

We have recently enabled Nagios backups.

What do you mean? These backups should be enabled by default. They are run on a cron.

Code: Select all

grep auto /etc/cron.d/nagiosxi

Have you modified the "/root/scripts/automysqlback" script?

I have to disagree with that comment. ever since 2014 came out backups have not been automatically scheduled on any of my 2014 servers, here or the old job. Fresh install and 2012 upgrade to 2014 saw backups not enabled by default, even though they were on the 2012 server.

I have to disagree with that comment. ever since 2014 came out backups have not been automatically scheduled on any of my 2014 servers, here or the old job. Fresh install and 2012 upgrade to 2014 saw backups not enabled by default, even though they were on the 2012 server.

If you haven't already, aside from this post, this would have been great to know about. As far as we have known and tested, backups should be working. Want to start a new thread for that one, so as not to hijack anil's?

As for OP, have you checked the size of your current mysql databases compared with the gziped files? Also have you tried gunzipping them and seeing if they inflate to a larger size?