I have MySQL and Nagios installed Linux PC (Centos5.5)
I have wrote some script to fetch the data from Nagios to Mysql DB (Exactly fetch data in Table)
The data fetching working properly (confirmed with 'COUNT' cmd)
The problem when i run the following command its through error as below,
mysql> select * from nagios_servicechecks;
ERROR 1194 (HY000): Table 'nagios_servicechecks' is marked as crashed and should be repaired
Except this command, all other commands working fine.