repairmysql.sh errors - INFO

[pnewlon]

I am in the process of upgrading from 1.3 -> 2.3 following the doc at http://assets.nagios.com/downloads/nagi ... ctions.pdf

When executing `mysqldump -u root -pnagiosxi nagios | bzip2 -c > /root/pre-upgrade-backup/my_nagios.sql.bz2` I got an error 'mysqldump: Got error: 144: Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed when using LOCK TABLES'. Searching the forum archives, I found a reference to running repairmysql.sh to fix this issue. I got another error when running that script:

myisamchk: error: Quick-recover aborted; Run recovery without switch 'q'
MyISAM-table 'nagios_logentries.MYI' is not fixed because of errors
Try fixing it by using the --safe-recover (-o), the --force (-f) option or by not using the --quick (-q) flag

Once I edited the script, changing
$cmd -r -q $t
to
$cmd -r $t

The repair ran successfully.

[scottwilkerson]

Thanks for posting this for others!