Nagios Support Forum

Posted: **Mon Apr 05, 2021 3:55 pm**

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.

Posted: **Mon Apr 05, 2021 4:09 pm**

To repair the Nagios MYSQL database, open a root shell and run this command.

Code: Select all

mysqlcheck -f -r -u root -pnagiosxi --databases nagios --use-frm

That should repair it so the backup can run.

Posted: **Tue Apr 06, 2021 7:57 am**

Yay! Victory!

Posted: **Tue Apr 06, 2021 8:50 am**

Yay! Victory!

Wonderful!

We'll go ahead and close this out, but feel free to open another post if you have any new issues.

Nagios Support Team

Nagios Support Forum

Backup dies

Backup dies

Re: Backup dies

Re: Backup dies

Re: Backup dies