Unable to run backups

[sreinhardt]

Can you attempt another backup, and immediately following the failure, run the following and send us the output?

Code: Select all

tail -n 200 /var/log/mysqld.log

[bcamp]

Requested log is attached.

[lmiltchev]

You don't have any errors in the log, but try running the following command to force the repair on the "nagios_notifications" table.

Code: Select all

echo "use nagios;repair table nagios_notifications use_frm;" | mysql -pnagiosxi

Let us know if this helped.

[bcamp]

This was it!

Code: Select all

# echo "use nagios;repair table nagios_notifications use_frm;" | mysql -pnagiosxi
Table   Op      Msg_type        Msg_text
nagios.nagios_notifications     repair  status  OK

Code: Select all

Backing up MySQL databases...
mysqldump: Got error: 130: Incorrect file format 'nagios_statehistory' when using LOCK TABLES
Error backing up MySQL database 'nagios' - check the password in this script!

Same error, new table. Ran the same repair on the nagios_statehistory table. Now my backups are working again! This fixed a couple other problems I was running into over the last few days. The event log wasn't showing me any data, same with notifications. That data is back.

Thank you, I appreciate your help. This thread can be locked.