repair database issue
Posted: Thu Apr 25, 2024 11:22 am
I ran:
it returned: "dbtype" => 'mysql',
then i ran:
all was good except for 1 item
i ran
all was good except:
how do I fix this?
Code: Select all
awk '/"nagiosxi" => array\(/{getline;print}' /usr/local/nagiosxi/html/config.inc.php
then i ran:
Code: Select all
/usr/local/nagiosxi/scripts/repair_databases.sh
Code: Select all
myisamchk: error: 'nagios_systemcommands' is not a MyISAM-table
Code: Select all
mysqlcheck -f -r -u root -pnagiosxi --all-databases
Code: Select all
nagios.nagios_statehistory OK
nagios.nagios_systemcommands
Error : Incorrect file format 'nagios_systemcommands'
error : Corrupt
nagios.nagios_timedeventqueue OK
nagios.nagios_timedevents OK