backup script not taking backup of offloaded mysql db

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
nagarjuna
Posts: 133
Joined: Mon Dec 09, 2013 2:11 am

backup script not taking backup of offloaded mysql db

Post by nagarjuna »

Hi Team,

We have configured nagiosxi with offloaded MySQL database on remote machine.
If we are running backup_xi.sh script for taking backup, backup completed properly except mysql database.

Do we have any backup script which we can use and get whole backup with mysql database also(offloaded)
abrist
Red Shirt
Posts: 8334
Joined: Thu Nov 15, 2012 1:20 pm

Re: backup script not taking backup of offloaded mysql db

Post by abrist »

In XI 2012r2.9 we are including an updated backup script to handle offloaded dbs. So you can go ahead and update to it.
Former Nagios employee
"It is turtles. All. The. Way. Down. . . .and maybe an elephant or two."
VI VI VI - The editor of the Beast!
Come to the Dark Side.
nagarjuna
Posts: 133
Joined: Mon Dec 09, 2013 2:11 am

Re: backup script not taking backup of offloaded mysql db

Post by nagarjuna »

Hi Abrist,

Wow, Its released new version, Definitely i will upgrade and get back to you As soon As Possible.

Many Many thanks to you .....
tmcdonald
Posts: 9117
Joined: Mon Sep 23, 2013 8:40 am

Re: backup script not taking backup of offloaded mysql db

Post by tmcdonald »

We'll keep this thread open until you return.
Former Nagios employee
nagarjuna
Posts: 133
Joined: Mon Dec 09, 2013 2:11 am

Re: backup script not taking backup of offloaded mysql db

Post by nagarjuna »

Thank you very much tmcdonald for opening up again this thread.

Actually we want backup script including offloaded mysql database. Usually we are taking backup with /usr/local/nagiosxi/scripts/backup_xi.sh script. but it is not taking backup remote offloaded database backup. its only taking backup of local files and local database.

As i already asked and got resolution for this --> we need to upgrade NagiosXI with latest XI 2012R2.9 . This new backup script will take care of remote server offloaded database also. But i checked its only taking backup of local mysql database not remote mysql database.
sreinhardt
-fno-stack-protector
Posts: 4366
Joined: Mon Nov 19, 2012 12:10 pm

Re: backup script not taking backup of offloaded mysql db

Post by sreinhardt »

The current issues with your database and system will need to be resolved until we can look further into this. abrist is presently in a session with your company, until he gives the OK we would request that no other major changes such as version upgrades or database changes are made.
Nagios-Plugins maintainer exclusively, unless you have other C language bugs with open-source nagios projects, then I am happy to help! Please pm or use other communication to alert me to issues as I no longer track the forum.
nagarjuna
Posts: 133
Joined: Mon Dec 09, 2013 2:11 am

Re: backup script not taking backup of offloaded mysql db

Post by nagarjuna »

Hi Team,

Thank you for suggestion, we will take care of it.
tmcdonald
Posts: 9117
Joined: Mon Sep 23, 2013 8:40 am

Re: backup script not taking backup of offloaded mysql db

Post by tmcdonald »

Going to close this thread until the prior issues are resolved.
Former Nagios employee
Locked