Nagios Support Forum

Posted: **Tue Oct 21, 2014 7:17 am**

When I try to backup my nagios xi with the following command am getting the error below

[root@xxx]# /usr/local/nagiosxi/scripts/backup_xi.sh

tar: /usr/local/nagios/var/rw/nagios.qh: socket ignored
tar: /usr/local/nagios/var: file changed as we read it
tar: /usr/local/nagios/share/perfdata/etw01: file changed as we read it
Backing up Nagios XI...
tar: Removing leading `/' from member names
Backing up MRTG...
tar: Removing leading `/' from member names
Backing up MySQL databases...
mysqldump: Got error: 1017: Can't find file: 'nagios_logentries' (errno: 2) when using LOCK TABLES
Error backing up MySQL database 'nagios' - check the password in this script!

I have run the new script suggested here: http://support.nagios.com/forum/downloa ... hp?id=4428

My MYSQL password is ok:
[root@xxxx]# grep -i password= /root/scripts/automysqlbackup | head -n 1
PASSWORD=nagiosxi
[root@xxxx]#

Please advice what could be wrong with my nagios XI

Posted: **Tue Oct 21, 2014 1:21 pm**

First, check for the table's existence, and then check for crashed tables:

Code: Select all

ls -la /var/lib/mysql/nagios/nagios_logentrie*
tail -100 /var/log/mysqld.log | grep crashed

If you have crashed tables, follow the doc below:
http://assets.nagios.com/downloads/nagi ... tabase.pdf

Nagios Support Forum

Cannot find file nagios_logentries Error backing up MySQL da

Cannot find file nagios_logentries Error backing up MySQL da

Re: Cannot find file nagios_logentries Error backing up MySQ