Page 1 of 1

mysqldump: got error: 144

Posted: Thu Jan 05, 2017 7:53 pm
by justine
I encountered this error in Nagios while backing up.

mysqldump: Got error: 144: Table './nagios/nagios_statehistory' is marked as crashed and last (automatic?) repair failed when using LOCK TABLES
Error backing up MySQL database 'nagios' - check the password in this script!

Please help how to fix this.

Re: mysqldump: got error: 144

Posted: Fri Jan 06, 2017 10:48 am
by dwhitfield
There are a number of solutions presented at https://support.nagios.com/kb/article.php?id=24

Please run through that document and let us know if you are still having issues. Thanks!

Re: mysqldump: got error: 144

Posted: Wed Jan 18, 2017 2:04 am
by justine
Thanks! Fixed it after running this script:
./repair_databases.sh