Re: [Opsview-users] mysql error message

[Neil F. <nei...@al...>]

On Thu, 2007-05-17 at 11:35 -0400, Rob Enders wrote:
> I get the following in the daemon.log file.. How do I fix it?
> =20
> May 17 11:34:28 engmon mysqld[8428]: 070517 11:34:28
> [ERROR] /usr/sbin/mysqld: Table './runtime/nagios_systemcommands' is
> marked as crashed and should be repaired

Connect to the MySQL database:

mysql -u root  (if necessary, also specify -p to enter a password)

Repair the table:

REPAIR TABLE runtime.nagios_systemcommands;

You can also see the status of other tables (i.e. whether or not they
need repairing) using the CHECK TABLE syntax.  The following links may
provide some useful information in this respect:

http://dev.mysql.com/doc/refman/5.0/en/check-table.html

http://dev.mysql.com/doc/refman/5.0/en/repair-table.html


Regards,


Neil