mysql_error Crashed table entries in /var/log/messages

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
npolovenko
Support Tech
Posts: 3457
Joined: Mon May 15, 2017 5:00 pm

Re: mysql_error Crashed table entries in /var/log/messages

Post by npolovenko »

@bsivavani, Is there enough hard drive space for a backup? Please show us the output of df -h.
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
bsivavani
Posts: 339
Joined: Tue Oct 06, 2015 9:17 am

Re: mysql_error Crashed table entries in /var/log/messages

Post by bsivavani »

We are able to take backup manually as we forgot to start mysql before taking backup.

but we are still seeing automatic backups are not happening.
User avatar
lmiltchev
Bugs find me
Posts: 13589
Joined: Mon May 23, 2011 12:15 pm

Re: mysql_error Crashed table entries in /var/log/messages

Post by lmiltchev »

Did you change your root mysql password from the default ("nagiosxi")? If you did, open the "/root/scripts/automysqlbackup" file in a text editor, and update the line below with the "new" password:

Code: Select all

PASSWORD=nagiosxi
Be sure to check out our Knowledgebase for helpful articles and solutions!
Locked