Page 2 of 2
Re: Unable to run backups
Posted: Fri Jul 11, 2014 12:59 pm
by sreinhardt
Can you attempt another backup, and immediately following the failure, run the following and send us the output?
Re: Unable to run backups
Posted: Fri Jul 11, 2014 1:18 pm
by bcamp
Requested log is attached.
Re: Unable to run backups
Posted: Fri Jul 11, 2014 2:05 pm
by 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.
Re: Unable to run backups
Posted: Fri Jul 11, 2014 7:07 pm
by 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.