below message:
mysqldump: Got error: 144: "Table './nagios/nagios_logentries' 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!
Pls advise on how to resolve the crashed table s.t. i can proceed with the backup.
Backup dies
Re: Backup dies
To repair the Nagios MYSQL database, open a root shell and run this command.
That should repair it so the backup can run.
Code: Select all
mysqlcheck -f -r -u root -pnagiosxi --databases nagios --use-frmBe sure to check out our Knowledgebase for helpful articles and solutions!
-
benjaminsmith
- Posts: 5324
- Joined: Wed Aug 22, 2018 4:39 pm
- Location: saint paul
Re: Backup dies
Wonderful!Yay! Victory!
We'll go ahead and close this out, but feel free to open another post if you have any new issues.
Nagios Support Team
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Be sure to check out our Knowledgebase for helpful articles and solutions!
Be sure to check out our Knowledgebase for helpful articles and solutions!