Error backing up MySQL DB nagios

[WillemDH]

Hello,

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!

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

[slansing]

Well, it may just be throwing that out there because of the crashed table in that DB, can you run the following then try to backup again?:

Code: Select all

/usr/local/nagiosxi/scripts/repairmysql.sh

[WillemDH]

hey Sam,

I was able to repair the nagios db and run the script in cli. i'll check next week if the ftp backup ran succesfully.

Grtz

[abrist]

Alright, keep us posted.

[WillemDH]

Solved! You can close the thread.