DATABASE: nagios TABLE: /var/lib/mysql/nagios ~ - recovering (with sort) MyISAM-table 'nagios_acknowledgements' Data records: 1122 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'nagios_commands' Data records: 143 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'nagios_commenthistory' Data records: 34282 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'nagios_comments' Data records: 64 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'nagios_configfiles' Data records: 1 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'nagios_configfilevariables' Data records: 131 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'nagios_conninfo' Data records: 3643 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'nagios_contact_addresses' Data records: 2 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'nagios_contactgroup_members' Data records: 12 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'nagios_contactgroups' Data records: 2 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'nagios_contact_notificationcommands' Data records: 156 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'nagios_contactnotificationmethods' Data records: 57718 - Fixing index 1 - Fixing index 2 - Fixing index 3 - Fixing index 4 --------- - recovering (with sort) MyISAM-table 'nagios_contactnotifications' Data records: 57637 - Fixing index 1 - Fixing index 2 - Fixing index 3 - Fixing index 4 - Fixing index 5 --------- - recovering (with sort) MyISAM-table 'nagios_contacts' Data records: 13 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'nagios_contactstatus' Data records: 13 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'nagios_customvariables' Data records: 1380 - Fixing index 1 - Fixing index 2 - Fixing index 3 --------- - recovering (with sort) MyISAM-table 'nagios_customvariablestatus' Data records: 1380 - Fixing index 1 - Fixing index 2 - Fixing index 3 --------- - recovering (with keycache) MyISAM-table 'nagios_dbversion' Data records: 1 --------- - recovering (with sort) MyISAM-table 'nagios_downtimehistory' Data records: 24172 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'nagios_eventhandlers' Data records: 6 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'nagios_externalcommands' Data records: 1347 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'nagios_flappinghistory' Data records: 13598 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'nagios_hostchecks' Data records: 0 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'nagios_host_contactgroups' Data records: 91 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'nagios_host_contacts' Data records: 169 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'nagios_hostdependencies' Data records: 0 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'nagios_hostescalation_contactgroups' Data records: 0 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'nagios_hostescalation_contacts' Data records: 0 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'nagios_hostescalations' Data records: 0 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'nagios_hostgroup_members' Data records: 105 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'nagios_hostgroups' Data records: 4 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'nagios_host_parenthosts' Data records: 2 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'nagios_hosts' Data records: 122 - Fixing index 1 - Fixing index 2 - Fixing index 3 --------- - recovering (with sort) MyISAM-table 'nagios_hoststatus' Data records: 122 - Fixing index 1 - Fixing index 2 - Fixing index 3 - Fixing index 4 - Fixing index 5 - Fixing index 6 - Fixing index 7 - Fixing index 8 - Fixing index 9 - Fixing index 10 - Fixing index 11 - Fixing index 12 - Fixing index 13 - Fixing index 14 - Fixing index 15 - Fixing index 16 - Fixing index 17 - Fixing index 18 - Fixing index 19 --------- - recovering (with sort) MyISAM-table 'nagios_instances' Data records: 1 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'nagios_logentries' Data records: 431686 - Fixing index 1 - Fixing index 2 - Fixing index 3 - Fixing index 4 - Fixing index 5 --------- - recovering (with sort) MyISAM-table 'nagios_notifications' Data records: 9779 - Fixing index 1 - Fixing index 2 - Fixing index 3 - Fixing index 4 - Fixing index 5 --------- - recovering (with sort) MyISAM-table 'nagios_objects' Data records: 3427 - Fixing index 1 - Fixing index 2 - Fixing index 3 - Fixing index 4 - Fixing index 5 --------- - recovering (with sort) MyISAM-table 'nagios_processevents' Data records: 2494 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'nagios_programstatus' Data records: 1 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'nagios_runtimevariables' Data records: 18 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'nagios_scheduleddowntime' Data records: 63 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'nagios_servicechecks' Data records: 0 - Fixing index 1 - Fixing index 2 - Fixing index 3 - Fixing index 4 --------- - recovering (with sort) MyISAM-table 'nagios_service_contactgroups' Data records: 861 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'nagios_service_contacts' Data records: 1948 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'nagios_servicedependencies' Data records: 0 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'nagios_serviceescalation_contactgroups' Data records: 0 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'nagios_serviceescalation_contacts' Data records: 0 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'nagios_serviceescalations' Data records: 0 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'nagios_servicegroup_members' Data records: 124 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'nagios_servicegroups' Data records: 1 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'nagios_service_parentservices' Data records: 0 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'nagios_services' Data records: 1306 - Fixing index 1 - Fixing index 2 - Fixing index 3 --------- - recovering (with sort) MyISAM-table 'nagios_servicestatus' Data records: 1306 - Fixing index 1 - Fixing index 2 - Fixing index 3 - Fixing index 4 - Fixing index 5 - Fixing index 6 - Fixing index 7 - Fixing index 8 - Fixing index 9 - Fixing index 10 - Fixing index 11 - Fixing index 12 - Fixing index 13 - Fixing index 14 - Fixing index 15 - Fixing index 16 - Fixing index 17 - Fixing index 18 - Fixing index 19 --------- - recovering (with sort) MyISAM-table 'nagios_statehistory' Data records: 1216964 - Fixing index 1 - Fixing index 2 - Fixing index 3 --------- - recovering (with sort) MyISAM-table 'nagios_systemcommands' Data records: 92 - Fixing index 1 - Fixing index 2 - Fixing index 3 --------- - recovering (with sort) MyISAM-table 'nagios_timedeventqueue' Data records: 0 - Fixing index 1 - Fixing index 2 - Fixing index 3 - Fixing index 4 - Fixing index 5 - Fixing index 6 --------- - recovering (with sort) MyISAM-table 'nagios_timedevents' Data records: 0 - Fixing index 1 - Fixing index 2 - Fixing index 3 - Fixing index 4 - Fixing index 5 - Fixing index 6 --------- - recovering (with sort) MyISAM-table 'nagios_timeperiods' Data records: 18 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'nagios_timeperiod_timeranges' Data records: 104 - Fixing index 1 - Fixing index 2 ~ =============== REPAIR COMPLETE =============== DATABASE: nagiosql TABLE: /var/lib/mysql/nagiosql ~ - recovering (with sort) MyISAM-table 'tbl_command' Data records: 148 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'tbl_contactgroup' Data records: 3 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'tbl_contact' Data records: 14 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'tbl_contacttemplate' Data records: 2 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'tbl_domain' Data records: 1 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'tbl_hostdependency' Data records: 0 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'tbl_hostescalation' Data records: 0 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'tbl_hostextinfo' Data records: 0 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'tbl_hostgroup' Data records: 5 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'tbl_host' Data records: 124 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'tbl_hosttemplate' Data records: 54 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'tbl_info' Data records: 218 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'tbl_lnkContactgroupToContactgroup' Data records: 0 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkContactgroupToContact' Data records: 1 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkContacttemplateToCommandHost' Data records: 2 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkContacttemplateToCommandService' Data records: 2 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkContacttemplateToContactgroup' Data records: 1 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkContacttemplateToContacttemplate' Data records: 0 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkContacttemplateToVariabledefinition' Data records: 0 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkContactToCommandHost' Data records: 6 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkContactToCommandService' Data records: 6 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkContactToContactgroup' Data records: 0 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkContactToContacttemplate' Data records: 11 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkContactToVariabledefinition' Data records: 3 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkHostdependencyToHost_DH' Data records: 0 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkHostdependencyToHostgroup_DH' Data records: 0 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkHostdependencyToHostgroup_H' Data records: 0 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkHostdependencyToHost_H' Data records: 0 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkHostescalationToContactgroup' Data records: 0 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkHostescalationToContact' Data records: 0 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkHostescalationToHostgroup' Data records: 0 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkHostescalationToHost' Data records: 0 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkHostgroupToHostgroup' Data records: 0 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkHostgroupToHost' Data records: 6 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkHosttemplateToContactgroup' Data records: 4 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkHosttemplateToContact' Data records: 0 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkHosttemplateToHostgroup' Data records: 1 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkHosttemplateToHost' Data records: 0 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkHosttemplateToHosttemplate' Data records: 51 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkHosttemplateToVariabledefinition' Data records: 3 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkHostToContactgroup' Data records: 92 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkHostToContact' Data records: 170 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkHostToHostgroup' Data records: 102 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkHostToHost' Data records: 3 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkHostToHosttemplate' Data records: 123 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkHostToVariabledefinition' Data records: 122 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkServicedependencyToHost_DH' Data records: 0 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkServicedependencyToHostgroup_DH' Data records: 0 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkServicedependencyToHostgroup_H' Data records: 0 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkServicedependencyToHost_H' Data records: 0 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkServicedependencyToService_DS' Data records: 0 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkServicedependencyToService_S' Data records: 0 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkServiceescalationToContactgroup' Data records: 0 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkServiceescalationToContact' Data records: 0 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkServiceescalationToHostgroup' Data records: 0 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkServiceescalationToHost' Data records: 0 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkServiceescalationToService' Data records: 0 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkServicegroupToServicegroup' Data records: 0 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkServicegroupToService' Data records: 25 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToContactgroup' Data records: 1 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToContact' Data records: 1 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToHostgroup' Data records: 0 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToHost' Data records: 0 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToServicegroup' Data records: 0 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToServicetemplate' Data records: 85 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToVariabledefinition' Data records: 2 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkServiceToContactgroup' Data records: 859 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkServiceToContact' Data records: 1945 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkServiceToHostgroup' Data records: 0 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkServiceToHost' Data records: 1307 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkServiceToServicegroup' Data records: 100 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkServiceToServicetemplate' Data records: 1296 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkServiceToVariabledefinition' Data records: 1263 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_lnkTimeperiodToTimeperiod' Data records: 0 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_logbook' Data records: 1 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_mainmenu' Data records: 7 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_servicedependency' Data records: 0 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'tbl_serviceescalation' Data records: 0 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'tbl_serviceextinfo' Data records: 0 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'tbl_servicegroup' Data records: 1 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'tbl_service' Data records: 1307 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_servicetemplate' Data records: 88 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'tbl_session_locks' Data records: 0 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_session' Data records: 0 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_settings' Data records: 13 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'tbl_submenu' Data records: 29 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_timedefinition' Data records: 116 - Fixing index 1 --------- - recovering (with sort) MyISAM-table 'tbl_timeperiod' Data records: 18 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'tbl_user' Data records: 2 - Fixing index 1 - Fixing index 2 --------- - recovering (with sort) MyISAM-table 'tbl_variabledefinition' Data records: 2404 - Fixing index 1 ~ =============== REPAIR COMPLETE =============== DATABASE: nagiosxi TABLE: /var/lib/mysql/nagiosxi ~ - recovering (with sort) MyISAM-table 'xi_eventqueue' Data records: 0 - Fixing index 1 - Fixing index 2 ~ =============== REPAIR COMPLETE =============== ======================= nagios database repair succeeded nagiosql database repair succeeded nagiosxi database repair succeeded