Page 1 of 1

SQL Errors in Nagios

Posted: Thu Nov 14, 2013 2:56 pm
by c.slagel
Help. How do I resolve this:
Screen Shot 2013-11-14 at 11.55.01 AM.png

Re: SQL Errors in Nagios

Posted: Thu Nov 14, 2013 3:16 pm
by slansing

Re: SQL Errors in Nagios

Posted: Thu Nov 14, 2013 3:38 pm
by c.slagel
Trying to backup the database before running this and getting an error:

Code: Select all

Backing up MySQL databases...
mysqldump: Got error: 145: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired when using LOCK TABLES
Error backing up MySQL database 'nagios' - check the password in this script!

Re: SQL Errors in Nagios

Posted: Thu Nov 14, 2013 3:50 pm
by abrist
You have crashed tables. The backup will not work until the tables are fixed. Run the repair script.