Nagios XI - Crashed Database Tables './nagios/nagios_logentr

[FrancisNagios]

Hi,

When making a Nagios Xi 5.4.13 backup in a Centos 6 Server, doesn´t bring the (.tar.gz) to the directory /store/backups/nagiosxi/

I have manually executed ./backup_xi.sh and I get the next mistake:
mysqldump: Got error: 145: Table './nagios/nagios_logentries' is marked as crashed and should be repaired when using LOCK TABLES
The content of the log /var/log/mysqld.log is:
190508 10:18:13 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_logentries' is marked as crashed and should be repaired

in the documentation indicates that you have to execute the following command /usr/local/nagiosxi/scripts/repair_databases.sh to repair the Databases as root and check for possible errors.


I have the following doubts:

1.- Could Nagios be stopped and started and also the database to see if the problem is solved without executing the script?
2.- Is this procedure correct? If so, does it have to be done with the database stopped?

Regards
Thank you

[scottwilkerson]

The procedure is correct and the script will automatically stop and start the database

[FrancisNagios]

When I do it I show the results to help other users

[scottwilkerson]

When I do it I show the results to help other users

Thanks

[FrancisNagios]

The procedure /usr/local/nagiosxi/scripts/repair_databases.sh was applied and the problem was solved and the backup can be done correctly.

Thank you

[scottwilkerson]

The procedure /usr/local/nagiosxi/scripts/repair_databases.sh was applied and the problem was solved and the backup can be done correctly.

Thank you

Great!

Locking thread