Page 1 of 1

Incomplete backup using backup_xi.sh

Posted: Mon Jan 14, 2013 9:56 am
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?

Re: Incomplete backup using backup_xi.sh

Posted: Mon Jan 14, 2013 10:24 am
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

Re: Incomplete backup using backup_xi.sh

Posted: Mon Jan 14, 2013 12:47 pm
by QS1
That worked..many tahnks

Re: Incomplete backup using backup_xi.sh

Posted: Mon Jan 14, 2013 6:03 pm
by slansing
Excellent, thanks for replying that it resolved your issue!