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.
mysqldump: got error: 144
mysqldump: got error: 144
Last edited by dwhitfield on Wed Jan 18, 2017 9:49 am, edited 1 time in total.
Reason: marking with green check mark
Reason: marking with green check mark
-
dwhitfield
- Former Nagios Staff
- Posts: 4583
- Joined: Wed Sep 21, 2016 10:29 am
- Location: NoLo, Minneapolis, MN
- Contact:
Re: mysqldump: got error: 144
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!
Please run through that document and let us know if you are still having issues. Thanks!
Re: mysqldump: got error: 144
Thanks! Fixed it after running this script:
./repair_databases.sh
./repair_databases.sh