Nagios Support Forum

Posted: **Wed May 28, 2014 12:52 pm**

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

Posted: **Wed May 28, 2014 4:58 pm**

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

Nagios Support Forum

Error 130 while backing up or attempting to upgrade

Error 130 while backing up or attempting to upgrade

Re: Error 130 while backing up or attempting to upgrade