Nagios Backup

Upatel · Post by **Upatel** » Mon Jan 27, 2014 3:05 pm

Hi There,

How to change the time for postgres and mysql Nagios db backup daily/weekly/monthly ?

abrist · Post by **abrist** » Mon Jan 27, 2014 3:41 pm

The backups are handled by cron:

cat /etc/cron.d/nagiosxi

Upatel · Post by **Upatel** » Mon Jan 27, 2014 4:15 pm

So different places for daily, weekly and monthly backup. We would like change the default time for all this backups.

abrist · Post by **abrist** » Mon Jan 27, 2014 4:18 pm

What times would you like?

Upatel · Post by **Upatel** » Tue Jan 28, 2014 11:18 am

for postgres 4 AM and mysql 5 AM

Post by **lmiltchev** » Tue Jan 28, 2014 12:16 pm

You need to have the following lines in the "/etc/cron.d/nagiosxi".:

# Backup MySQL & PostgreSQL Databases
0   5 * * * root   /root/scripts/automysqlbackup
0   4 * * * root   /root/scripts/autopostgresqlbackup

Save, and exit.

The backup will run daily. The backups are then rotated weekly & monthly. Hope this helps.

Nagios Support Forum