Menu ▾ ▴

Error log emailed to me (but 'no' error ?)

Open Discussion
Timothy Gott
2011-02-02
2013-05-29

  • Timothy Gott

    Timothy Gott - 2011-02-02

    I'm getting an error log emailed to me. Today of course the attached error log was titled "ERRORS_localhost-257325623.log"  which I've looked at pretty closely and did a CTRL-F for words like "error" or "fail" … It doesn't seem to have 'any' errors but then why am I still getting this error log sent to me? Can I safely assume that all is well and that the script is simply choking on some "unknown"?

    Here is the error log that I'm getting: 

    + '[' no = yes ']'
+ '[' '' ']'
+ '[' '!' -e /home/tg3793/website_backups/ ']'
+ '[' '!' -e /home/tg3793/website_backups//daily ']'
+ '[' '!' -e /home/tg3793/website_backups//weekly ']'
+ '[' '!' -e /home/tg3793/website_backups//monthly ']'
+ '[' no = yes ']'
+ SUFFIX=
+ '[' '' ']'
+ '[' yes = yes ']'
+ '[' no = no ']'
+ OPT='--quote-names --opt --no-create-db'
+ '[' localhost = localhost ']'
++ /bin/hostname
+ HOST=exige.websitewelcome.com
+ '[' '' ']'
+ '[' 'tg3793_sope1 tg3793_wdps1' = all ']'
+ /bin/echo ======================================================================
+ /bin/echo AutoMySQLBackup VER 2.5.1
+ /bin/echo http://sourceforge.net/projects/automysqlbackup/
+ /bin/echo
+ /bin/echo Backup of Database Server - exige.websitewelcome.com
+ /bin/echo ======================================================================
+ '[' yes = yes ']'
++ /bin/date
+ /bin/echo Backup Start Time Tue Feb 1 18:07:56 CST 2011
+ /bin/echo ======================================================================
+ '[' 01 = 01 ']'
+ for MDB in '${MDBNAMES}'
++ /bin/echo tg3793_sope1
+ MDB=tg3793_sope1
+ '[' '!' -e /home/tg3793/website_backups//monthly/tg3793_sope1 ']'
+ /bin/echo Monthly Backup of tg3793_sope1...
+ dbdump tg3793_sope1 /home/tg3793/website_backups//monthly/tg3793_sope1/tg3793_sope1_2011-02-01_18h07m.February.tg3793_sope1.sql
+ /usr/bin/mysqldump --user=tg3793_arch '--password=F1k3P1ssw0rd' --host=localhost --quote-names --opt --no-create-db tg3793_sope1
+ return 0
+ '[' 0 -eq 0 ']'
+ /bin/echo 'Rotating 5 month backups for tg3793_sope1'
+ /usr/bin/find /home/tg3793/website_backups//monthly/tg3793_sope1 -mtime +150 -type f -exec /bin/rm -v '{}' ';'
+ compression /home/tg3793/website_backups//monthly/tg3793_sope1/tg3793_sope1_2011-02-01_18h07m.February.tg3793_sope1.sql
+ '[' gzip = gzip ']'
+ /bin/gzip -f /home/tg3793/website_backups//monthly/tg3793_sope1/tg3793_sope1_2011-02-01_18h07m.February.tg3793_sope1.sql
+ /bin/echo
+ /bin/echo Backup Information for /home/tg3793/website_backups//monthly/tg3793_sope1/tg3793_sope1_2011-02-01_18h07m.February.tg3793_sope1.sql
+ /bin/gzip -l /home/tg3793/website_backups//monthly/tg3793_sope1/tg3793_sope1_2011-02-01_18h07m.February.tg3793_sope1.sql.gz
+ SUFFIX=.gz
+ '[' no = yes ']'
+ return 0
+ BACKUPFILES=' /home/tg3793/website_backups//monthly/tg3793_sope1/tg3793_sope1_2011-02-01_18h07m.February.tg3793_sope1.sql.gz'
+ /bin/echo ----------------------------------------------------------------------
+ for MDB in '${MDBNAMES}'
++ /bin/echo tg3793_wdps1
++ /bin/sed 's/%/ /g'
+ MDB=tg3793_wdps1
+ '[' '!' -e /home/tg3793/website_backups//monthly/tg3793_wdps1 ']'
+ /bin/echo Monthly Backup of tg3793_wdps1...
+ dbdump tg3793_wdps1 /home/tg3793/website_backups//monthly/tg3793_wdps1/tg3793_wdps1_2011-02-01_18h07m.February.tg3793_wdps1.sql
+ /usr/bin/mysqldump --user=tg3793_arch '--password=F1k3P1ssw0rd' --host=localhost --quote-names --opt --no-create-db tg3793_wdps1
+ return 0
+ '[' 0 -eq 0 ']'
+ /bin/echo 'Rotating 5 month backups for tg3793_wdps1'
+ /usr/bin/find /home/tg3793/website_backups//monthly/tg3793_wdps1 -mtime +150 -type f -exec /bin/rm -v '{}' ';'
+ compression /home/tg3793/website_backups//monthly/tg3793_wdps1/tg3793_wdps1_2011-02-01_18h07m.February.tg3793_wdps1.sql
+ '[' gzip = gzip ']'
+ /bin/gzip -f /home/tg3793/website_backups//monthly/tg3793_wdps1/tg3793_wdps1_2011-02-01_18h07m.February.tg3793_wdps1.sql
+ /bin/echo
+ /bin/echo Backup Information for /home/tg3793/website_backups//monthly/tg3793_wdps1/tg3793_wdps1_2011-02-01_18h07m.February.tg3793_wdps1.sql
+ /bin/gzip -l /home/tg3793/website_backups//monthly/tg3793_wdps1/tg3793_wdps1_2011-02-01_18h07m.February.tg3793_wdps1.sql.gz
+ SUFFIX=.gz
+ '[' no = yes ']'
+ return 0
+ BACKUPFILES=' /home/tg3793/website_backups//monthly/tg3793_sope1/tg3793_sope1_2011-02-01_18h07m.February.tg3793_sope1.sql.gz /home/tg3793/website_backups//monthly/tg3793_wdps1/tg3793_wdps1_2011-02-01_18h07m.February.tg3793_wdps1.sql.gz'
+ /bin/echo ----------------------------------------------------------------------
+ for DB in '${DBNAMES}'
++ /bin/echo tg3793_sope1
++ /bin/sed 's/%/ /g'
+ DB=tg3793_sope1
+ '[' '!' -e /home/tg3793/website_backups//daily/tg3793_sope1 ']'
+ '[' '!' -e /home/tg3793/website_backups//weekly/tg3793_sope1 ']'
+ '[' 2 = 7 ']'
+ /bin/echo Daily Backup of Database '(' tg3793_sope1 ')'
+ /bin/echo
+ dbdump tg3793_sope1 /home/tg3793/website_backups//daily/tg3793_sope1/tg3793_sope1_2011-02-01_18h07m.Tuesday.sql
+ /usr/bin/mysqldump --user=tg3793_arch '--password=F1k3P1ssw0rd' --host=localhost --quote-names --opt --no-create-db tg3793_sope1
+ return 0
+ '[' 0 -eq 0 ']'
+ /bin/echo Rotating last weeks Backup...
+ /usr/bin/find /home/tg3793/website_backups//daily/tg3793_sope1 -mtime +6 -type f -exec /bin/rm -v '{}' ';'
+ compression /home/tg3793/website_backups//daily/tg3793_sope1/tg3793_sope1_2011-02-01_18h07m.Tuesday.sql
+ '[' gzip = gzip ']'
+ /bin/gzip -f /home/tg3793/website_backups//daily/tg3793_sope1/tg3793_sope1_2011-02-01_18h07m.Tuesday.sql
+ /bin/echo
+ /bin/echo Backup Information for /home/tg3793/website_backups//daily/tg3793_sope1/tg3793_sope1_2011-02-01_18h07m.Tuesday.sql
+ /bin/gzip -l /home/tg3793/website_backups//daily/tg3793_sope1/tg3793_sope1_2011-02-01_18h07m.Tuesday.sql.gz
+ SUFFIX=.gz
+ '[' no = yes ']'
+ return 0
+ BACKUPFILES=' /home/tg3793/website_backups//monthly/tg3793_sope1/tg3793_sope1_2011-02-01_18h07m.February.tg3793_sope1.sql.gz /home/tg3793/website_backups//monthly/tg3793_wdps1/tg3793_wdps1_2011-02-01_18h07m.February.tg3793_wdps1.sql.gz /home/tg3793/website_backups//daily/tg3793_sope1/tg3793_sope1_2011-02-01_18h07m.Tuesday.sql.gz'
+ /bin/echo ----------------------------------------------------------------------
+ for DB in '${DBNAMES}'
++ /bin/echo tg3793_wdps1
++ /bin/sed 's/%/ /g'
+ DB=tg3793_wdps1
+ '[' '!' -e /home/tg3793/website_backups//daily/tg3793_wdps1 ']'
+ '[' '!' -e /home/tg3793/website_backups//weekly/tg3793_wdps1 ']'
+ '[' 2 = 7 ']'
+ /bin/echo Daily Backup of Database '(' tg3793_wdps1 ')'
+ /bin/echo
+ dbdump tg3793_wdps1 /home/tg3793/website_backups//daily/tg3793_wdps1/tg3793_wdps1_2011-02-01_18h07m.Tuesday.sql
+ /usr/bin/mysqldump --user=tg3793_arch '--password=F1k3P1ssw0rd' --host=localhost --quote-names --opt --no-create-db tg3793_wdps1
+ return 0
+ '[' 0 -eq 0 ']'
+ /bin/echo Rotating last weeks Backup...
+ /usr/bin/find /home/tg3793/website_backups//daily/tg3793_wdps1 -mtime +6 -type f -exec /bin/rm -v '{}' ';'
+ compression /home/tg3793/website_backups//daily/tg3793_wdps1/tg3793_wdps1_2011-02-01_18h07m.Tuesday.sql
+ '[' gzip = gzip ']'
+ /bin/gzip -f /home/tg3793/website_backups//daily/tg3793_wdps1/tg3793_wdps1_2011-02-01_18h07m.Tuesday.sql
+ /bin/echo
+ /bin/echo Backup Information for /home/tg3793/website_backups//daily/tg3793_wdps1/tg3793_wdps1_2011-02-01_18h07m.Tuesday.sql
+ /bin/gzip -l /home/tg3793/website_backups//daily/tg3793_wdps1/tg3793_wdps1_2011-02-01_18h07m.Tuesday.sql.gz
+ SUFFIX=.gz
+ '[' no = yes ']'
+ return 0
+ BACKUPFILES=' /home/tg3793/website_backups//monthly/tg3793_sope1/tg3793_sope1_2011-02-01_18h07m.February.tg3793_sope1.sql.gz /home/tg3793/website_backups//monthly/tg3793_wdps1/tg3793_wdps1_2011-02-01_18h07m.February.tg3793_wdps1.sql.gz /home/tg3793/website_backups//daily/tg3793_sope1/tg3793_sope1_2011-02-01_18h07m.Tuesday.sql.gz /home/tg3793/website_backups//daily/tg3793_wdps1/tg3793_wdps1_2011-02-01_18h07m.Tuesday.sql.gz'
+ /bin/echo ----------------------------------------------------------------------
++ /bin/date
+ /bin/echo Backup End Tue Feb 1 18:07:57 CST 2011
+ /bin/echo ======================================================================
+ /bin/echo Total disk space used for backup storage..
+ /bin/echo Size - Location
++ /usr/bin/du -hs /home/tg3793/website_backups/
+ /bin/echo 948K /home/tg3793/website_backups/
+ /bin/echo
+ /bin/echo ======================================================================
+ /bin/echo If you find AutoMySQLBackup valuable please make a donation at
+ /bin/echo 'http://sourceforge.net/project/project_donations.php?group_id=101066'
+ /bin/echo ======================================================================
+ '[' '' ']'
+ exec
+ exec

    Any direction in this is appreciated.

     

  • Timothy Gott

    Timothy Gott - 2011-02-02

    And I'm 'really' inexperienced at this scripting stuff; so the only think that looks a little odd to me is all of those "//" all throughout the log file … Is that normal ?

     

  • Timothy Gott

    Timothy Gott - 2011-02-02

    Ok so here goes step one in correcting myself:
    I  found a line in the config file "BACKUPDIR=" and took that last "/" off the back of the line.
    Now the error file that I am being emailed is a little smaller but it is still happening. Here is the error file I was emailed just a few minutes ago after running the script again. 

    + '[' no = yes ']'
+ '[' '' ']'
+ '[' '!' -e /home/tg3793/website_backups ']'
+ '[' '!' -e /home/tg3793/website_backups/daily ']'
+ '[' '!' -e /home/tg3793/website_backups/weekly ']'
+ '[' '!' -e /home/tg3793/website_backups/monthly ']'
+ '[' no = yes ']'
+ SUFFIX=
+ '[' '' ']'
+ '[' yes = yes ']'
+ '[' no = no ']'
+ OPT='--quote-names --opt --no-create-db'
+ '[' localhost = localhost ']'
++ /bin/hostname
+ HOST=exige.websitewelcome.com
+ '[' '' ']'
+ '[' all = all ']'
++ /usr/bin/mysql --user=tg3793_arch '--password=F1k3P1ssw0rd' --host=localhost --batch --skip-column-names -e 'show databases'
++ /bin/sed 's/ /%/g'
+ DBNAMES='information_schema
tg3793_sope1
tg3793_wdps1'
+ for exclude in '${DBEXCLUDE}'
++ /bin/echo information_schema tg3793_sope1 tg3793_wdps1
++ /bin/sed 's/\binformation_schema\b//g'
+ DBNAMES=' tg3793_sope1 tg3793_wdps1'
+ MDBNAMES=' tg3793_sope1 tg3793_wdps1'
+ /bin/echo ======================================================================
+ /bin/echo AutoMySQLBackup VER 2.5.1
+ /bin/echo http://sourceforge.net/projects/automysqlbackup/
+ /bin/echo
+ /bin/echo Backup of Database Server - exige.websitewelcome.com
+ /bin/echo ======================================================================
+ '[' yes = yes ']'
++ /bin/date
+ /bin/echo Backup Start Time Wed Feb 2 01:33:50 CST 2011
+ /bin/echo ======================================================================
+ '[' 02 = 01 ']'
+ for DB in '${DBNAMES}'
++ /bin/echo tg3793_sope1
++ /bin/sed 's/%/ /g'
+ DB=tg3793_sope1
+ '[' '!' -e /home/tg3793/website_backups/daily/tg3793_sope1 ']'
+ '[' '!' -e /home/tg3793/website_backups/weekly/tg3793_sope1 ']'
+ '[' 3 = 7 ']'
+ /bin/echo Daily Backup of Database '(' tg3793_sope1 ')'
+ /bin/echo
+ dbdump tg3793_sope1 /home/tg3793/website_backups/daily/tg3793_sope1/tg3793_sope1_2011-02-02_01h33m.Wednesday.sql
+ /usr/bin/mysqldump --user=tg3793_arch '--password=F1k3P1ssw0rd' --host=localhost --quote-names --opt --no-create-db tg3793_sope1
+ return 0
+ '[' 0 -eq 0 ']'
+ /bin/echo Rotating last weeks Backup...
+ /usr/bin/find /home/tg3793/website_backups/daily/tg3793_sope1 -mtime +6 -type f -exec /bin/rm -v '{}' ';'
+ compression /home/tg3793/website_backups/daily/tg3793_sope1/tg3793_sope1_2011-02-02_01h33m.Wednesday.sql
+ '[' gzip = gzip ']'
+ /bin/gzip -f /home/tg3793/website_backups/daily/tg3793_sope1/tg3793_sope1_2011-02-02_01h33m.Wednesday.sql
+ /bin/echo
+ /bin/echo Backup Information for /home/tg3793/website_backups/daily/tg3793_sope1/tg3793_sope1_2011-02-02_01h33m.Wednesday.sql
+ /bin/gzip -l /home/tg3793/website_backups/daily/tg3793_sope1/tg3793_sope1_2011-02-02_01h33m.Wednesday.sql.gz
+ SUFFIX=.gz
+ '[' no = yes ']'
+ return 0
+ BACKUPFILES=' /home/tg3793/website_backups/daily/tg3793_sope1/tg3793_sope1_2011-02-02_01h33m.Wednesday.sql.gz'
+ /bin/echo ----------------------------------------------------------------------
+ for DB in '${DBNAMES}'
++ /bin/echo tg3793_wdps1
++ /bin/sed 's/%/ /g'
+ DB=tg3793_wdps1
+ '[' '!' -e /home/tg3793/website_backups/daily/tg3793_wdps1 ']'
+ '[' '!' -e /home/tg3793/website_backups/weekly/tg3793_wdps1 ']'
+ '[' 3 = 7 ']'
+ /bin/echo Daily Backup of Database '(' tg3793_wdps1 ')'
+ /bin/echo
+ dbdump tg3793_wdps1 /home/tg3793/website_backups/daily/tg3793_wdps1/tg3793_wdps1_2011-02-02_01h33m.Wednesday.sql
+ /usr/bin/mysqldump --user=tg3793_arch '--password=F1k3P1ssw0rd' --host=localhost --quote-names --opt --no-create-db tg3793_wdps1
+ return 0
+ '[' 0 -eq 0 ']'
+ /bin/echo Rotating last weeks Backup...
+ /usr/bin/find /home/tg3793/website_backups/daily/tg3793_wdps1 -mtime +6 -type f -exec /bin/rm -v '{}' ';'
+ compression /home/tg3793/website_backups/daily/tg3793_wdps1/tg3793_wdps1_2011-02-02_01h33m.Wednesday.sql
+ '[' gzip = gzip ']'
+ /bin/gzip -f /home/tg3793/website_backups/daily/tg3793_wdps1/tg3793_wdps1_2011-02-02_01h33m.Wednesday.sql
+ /bin/echo
+ /bin/echo Backup Information for /home/tg3793/website_backups/daily/tg3793_wdps1/tg3793_wdps1_2011-02-02_01h33m.Wednesday.sql
+ /bin/gzip -l /home/tg3793/website_backups/daily/tg3793_wdps1/tg3793_wdps1_2011-02-02_01h33m.Wednesday.sql.gz
+ SUFFIX=.gz
+ '[' no = yes ']'
+ return 0
+ BACKUPFILES=' /home/tg3793/website_backups/daily/tg3793_sope1/tg3793_sope1_2011-02-02_01h33m.Wednesday.sql.gz /home/tg3793/website_backups/daily/tg3793_wdps1/tg3793_wdps1_2011-02-02_01h33m.Wednesday.sql.gz'
+ /bin/echo ----------------------------------------------------------------------
++ /bin/date
+ /bin/echo Backup End Wed Feb 2 01:33:52 CST 2011
+ /bin/echo ======================================================================
+ /bin/echo Total disk space used for backup storage..
+ /bin/echo Size - Location
++ /usr/bin/du -hs /home/tg3793/website_backups
+ /bin/echo 592K /home/tg3793/website_backups
+ /bin/echo
+ /bin/echo ======================================================================
+ /bin/echo If you find AutoMySQLBackup valuable please make a donation at
+ /bin/echo 'http://sourceforge.net/project/project_donations.php?group_id=101066'
+ /bin/echo ======================================================================
+ '[' '' ']'
+ exec
+ exec
     

  • Timothy Gott

    Timothy Gott - 2011-02-03

    Ok I got some help on this and it was a newbie error ; me being the newbie.

    I executed the script on the server using "bash -x" and for some reason (which I do not yet know) this caused the script to do something that in turn generated a ERRORS_localhost-xxxxxxxx.log that was emailed to me each time.

    Executing the script using "./autobackupmysql" fixed it.

    Hope this helps future readers.

     

  • Timothy Gott

    Timothy Gott - 2011-02-03

    err ; I mean "./AutoMySQLBackup" fixed it :-)

     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.