Error 130 while backing up or attempting to upgrade

[[email protected]]

I am receiving an error when trying to backup or upgrade my current Nagios XI Version 2012R2.5.

The error during an upgrade is...

Error 130 at line 5: Incorrect file format 'nagios_contactnotificationmethods' Upgrade from mysql-upgrade-2.0.0.sql filed at ./upgradedb line 106.

During a backup the error is similar.

I have tried several repair suggestions on the forum with zero success.

Thoughts or suggestions?

Thanks,

Joe

[abrist]

You most likely have a damaged db. Try the repair scripts first:

Code: Select all

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

If you continue to have problems, force a repair of the affected table with:

Code: Select all

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