Error backing up MySQL DB nagios
Posted: Tue Aug 19, 2014 6:21 am
Hello,
I'm having an issue backing up my Nagios XI QA server.
I was thinking setting a password was no longer required?
FTP backup or local backup also don't seem to work. Setup is the same as my production nagios XI server, where it does seem to work.
Grtz
Willem
I'm having an issue backing up my Nagios XI QA server.
Code: Select all
/usr/local/nagiosxi/scripts/backup_xi.sh
Backing up Core Config Manager (NagiosQL)...
tar: Removing leading `/' from member names
tar: Removing leading `/' from member names
Backing up Nagios Core...
tar: Removing leading `/' from member names
tar: /usr/local/nagios/var/rw/nagios.qh: socket ignored
tar: /usr/local/nagios/var/ndo.sock: socket ignored
Backing up Nagios XI...
tar: Removing leading `/' from member names
Backing up MRTG...
tar: Removing leading `/' from member names
Backing up MySQL databases...
mysqldump: Got error: 145: Table './nagios/nagios_systemcommands' is marked as crashed and should be repaired when using LOCK TABLES
Error backing up MySQL database 'nagios' - check the password in this script!
FTP backup or local backup also don't seem to work. Setup is the same as my production nagios XI server, where it does seem to work.
Grtz
Willem
