Nagios Support Forum

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

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

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

FrancisNagios wrote:When I do it I show the results to help other users

Thanks

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

FrancisNagios wrote: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