Page 1 of 1

mysql db backup error

Posted: Wed Nov 20, 2013 2:35 pm
by ravish78
We are getting below error while doing backups

tmproot@usa7061lv955>/usr/local/nagiosxi/scripts/backup_xi.sh
Backing up Core Config Manager (NagiosQL)...
tar: Removing leading `/' from member names
tar: Removing leading `/' from member names
Backing up Nagios Core...
tar: Removing leading `/' from member names
tar: /usr/local/nagios/var/ndo.sock: socket ignored
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: 29: File './nagios/nagios_externalcommands.MYD' not found (Errcode: 2) when using LOCK TABLES
Error backing up MySQL database 'nagios' - check the password in this script!
tmproot@usa7061lv955>ls
‎‎

Unknowingly myteam zipped below files when space is full.

-rw-rw---- 1 mysql mysql 237350063 Nov 5 05:20 nagios_externalcommands.MYD.gz
-rw-rw---- 1 mysql mysql 61441702 Nov 5 05:38 nagios_logentries.MYD.gz
-rw-rw---- 1 mysql mysql 27455026 Nov 5 05:38 nagios_statehistory.MYD.gz


I am not sure how does it effect nagios application or historical data.I tried to replicate in test (zipping this 3 files ,created same backup error and unzipped them and able to backup).Can I unzip and backup in production as well.

Please suggest

Re: mysql db backup error

Posted: Wed Nov 20, 2013 4:35 pm
by tmcdonald
Unzipping them should be fine.

Re: mysql db backup error

Posted: Mon Dec 09, 2013 9:59 am
by ravish78
you may close this..This is resolved