Incomplete backup using backup_xi.sh

This support forum board is for support questions relating to Nagios xi, our flagship commercial network monitoring solution.
QS1
Posts: 195
Joined: Tue Sep 21, 2010 3:30 pm

Incomplete backup using backup_xi.sh

Post by QS1 »

Nagios xi 2011R3.3
CENTOS 5.7 32 BIT
VMWARE Image
KDE desktop

Our Nagiosxi recovery process consists of VM snapshots held for seven days. This process has worked well in the past and we've never needed a process similar to the backup_xi.sh script. I want to start incorporating the backup_xi.sh but get mysql password errors when the script is executed. The passwords are verified as the screenshots in the attachment are included...any ideas how I can further troubleshoot this issue?
You do not have the required permissions to view the files attached to this post.
slansing
Posts: 7698
Joined: Mon Apr 23, 2012 4:28 pm
Location: Travelling through time and space...

Re: Incomplete backup using backup_xi.sh

Post by slansing »

Good morning,

It looks like you have a crashed table, before backing up you want to make sure that you have fixed any Database issues so that they do not follow you, the check password error is the most common issue with running a backup but it is also triggered when you have crashed tables and it can not make contact with them. To fix this issue simply run through the database repair document and you should be good to go:

http://assets.nagios.com/downloads/nagi ... tabase.pdf
QS1
Posts: 195
Joined: Tue Sep 21, 2010 3:30 pm

Re: Incomplete backup using backup_xi.sh

Post by QS1 »

That worked..many tahnks
slansing
Posts: 7698
Joined: Mon Apr 23, 2012 4:28 pm
Location: Travelling through time and space...

Re: Incomplete backup using backup_xi.sh

Post by slansing »

Excellent, thanks for replying that it resolved your issue!