mysql db backup error
Posted: Wed Nov 20, 2013 2:35 pm
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
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