Page 1 of 1

Nagios XI Backup not working anymore

Posted: Wed Oct 05, 2016 7:09 pm
by castroi
Hello,

I am running Nagios XI 5.2.9 and it seems that backup stop working from cli or webui.
When i run it from cli i can see following error:

Backing up MySQL databases...
mysqldump: Got error: 145: Table './nagios/nagios_notifications' is marked as crashed and should be repaired when using LOCK TABLES
Error backing up MySQL database 'nagios' - check the password in this script!

Could you please assist me?

thank you,

Igor

Re: Nagios XI Backup not working anymore

Posted: Wed Oct 05, 2016 7:42 pm
by Box293
Can you please follow this article to run the database repair process as I believe you may have some database issues:

https://support.nagios.com/kb/article.php?id=24

This may take a while to complete. Once it has, please scroll back up through the history to make sure there were not any database errors (you may see an ndo2db error when stopping the service but this is ok).

Once this is fixed the backup process will start working again.

Re: Nagios XI Backup not working anymore

Posted: Thu Oct 06, 2016 8:16 am
by castroi
Hello,

Yes it is now fixed.

Thank you very much

Re: Nagios XI Backup not working anymore

Posted: Thu Oct 06, 2016 10:00 am
by tmcdonald
I'll be closing this thread now, but feel free to open another if you need anything in the future!