repairmysql.sh errors - INFO
Posted: Thu Apr 19, 2012 1:05 pm
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.
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.