autobackupmysql-svnmail Mailing List for AutoBackupMySQL

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Revision: 6
          http://autobackupmysql.svn.sourceforge.net/autobackupmysql/?rev=6&view=rev
Author:   infyquest
Date:     2010-11-17 22:15:41 +0000 (Wed, 17 Nov 2010)

Log Message:
-----------
Add mysql server port support

Modified Paths:
--------------
    autobackupmysql.sh

Modified: autobackupmysql.sh
===================================================================

--- autobackupmysql.sh	2009-12-22 11:39:58 UTC (rev 5)
+++ autobackupmysql.sh	2010-11-17 22:15:41 UTC (rev 6)
@@ -1,7 +1,7 @@
 #!/bin/bash
 #
 # Automatic MySQL Backup Script
-# VER. 1.3 - http://sourceforge.net/projects/autobackupmysql/
+# VER. 1.4 - http://sourceforge.net/projects/autobackupmysql/
 # Copyright (c) 2009 inf...@gm...
 # Copyright (c) 2002-2006 wip...@ly...
 #
@@ -27,7 +27,7 @@
 # (Detailed instructions below variables)
 #=====================================================================
 
-# Check configuration files
+# Check configuration iles
 if [ -f "autobackupmysql.conf" ] ; then
 	source "autobackupmysql.conf"
 elif [ -f "/etc/autobackupmysql.conf" ] ; then
@@ -44,6 +44,9 @@
 # Host name (or IP address) of MySQL server e.g localhost
 DBHOST='localhost'
 
+# Port on which the MySQL server is reachable e.g. 5710
+PORT=5710
+
 # List of DBNAMES for Daily/Weekly Backup e.g. "DB1 DB2 DB3"
 DBNAMES="DB1 DB2 DB3"
 
@@ -52,10 +55,10 @@
 
 # Mail setup
 # What would you like to be mailed to you?
-# - log   : send only log file
-# - files : send log file and sql files as attachments (see docs)
+# - log    : send only log file
+# - files  : send log file and sql files as attachments (see docs)
 # - stdout : will simply output the log to the screen if run manually.
-# - quiet : Only send logs if an error occurs to the MAILADDR.
+# - quiet  : Only send logs if an error occurs to the MAILADDR.
 MAILCONTENT="stdout"
 
 # Set the maximum allowed email size in k. (4000 = approx 5MB email [see docs])
@@ -232,7 +235,7 @@
 # Please Note!!
 #=====================================================================
 #
-# I take no resposibility for any data loss or corruption when using
+# I take no responsibility for any data loss or corruption when using
 # this script..
 # This script will not help in the event of a hard drive crash. If a 
 # copy of the backup has not be stored offline or on another PC..
@@ -263,9 +266,11 @@
 # Change Log
 #=====================================================================
 #
+# VER 1.4 - (2010-11-17)
+#   Add mysql server port support (based on patch by Eike Starkman)
 # VER 1.3 - (2009-12-22)
-#   Add FreeBSD specific configuration check (thanks fraenski)
-#   Fix typo in the configuration file check (thanks fraenski)
+#   Add FreeBSD specific configuration check (patch by Frank Wall)
+#   Fix typo in the configuration file check (patch by Frank Wall)
 #   Fix for Socket file ignored when DBNAMES="all" given
 #   Minor IO redirection fix
 # VER 1.2 - (2009-12-18)
@@ -301,26 +306,22 @@
 OPT="--quote-names --opt"			# OPT string for use with mysqldump ( see man mysqldump )
 
 # Add --compress mysqldump option to $OPT
-if [ "$COMMCOMP" = "yes" ];
-	then
-		OPT="$OPT --compress"
-	fi
+if [ "$COMMCOMP" = "yes" ]; then
+	OPT="$OPT --compress"
+fi
 
 # Add --compress mysqldump option to $OPT
-if [ "$MAX_ALLOWED_PACKET" ];
-	then
-		OPT="$OPT --max_allowed_packet=$MAX_ALLOWED_PACKET"
-	fi
+if [ "$MAX_ALLOWED_PACKET" ]; then
+	OPT="$OPT --max_allowed_packet=$MAX_ALLOWED_PACKET"
+fi
 
 # Set the suffix for compressed file
-if [ "$COMP" = "gzip" ];
-	then
-		SUFFIX=".gz"
-elif [ "$COMP" = "bzip2" ];
-	then
-		SUFFIX=".bz2"
+if [ "$COMP" = "gzip" ]; then
+	SUFFIX=".gz"
+elif [ "$COMP" = "bzip2" ]; then
+	SUFFIX=".bz2"
 else
-		SUFFIX=""
+	SUFFIX=""
 fi
 
 # Create required directories
@@ -345,12 +346,12 @@
 fi
 
 if [ "$LATEST" = "yes" ]
-then
-	if [ ! -e "$BACKUPDIR/latest" ]	# Check Latest Directory exists.
 	then
+	if [ ! -e "$BACKUPDIR/latest" ]	# Check Latest Directory exists.
+		then
 		mkdir -p "$BACKUPDIR/latest"
 	fi
-eval rm -fv "$BACKUPDIR/latest/*"
+	eval rm -fv "$BACKUPDIR/latest/*"
 fi
 
 # IO redirection for logging.
@@ -369,9 +370,9 @@
 # Database dump function
 dbdump () {
 if [ "$PIPECOMP" = "yes" ]; then
-	mysqldump --user=$USERNAME --password=$PASSWORD --host=$DBHOST $OPT $1 | $COMP > "$2$SUFFIX"
+	mysqldump --user=$USERNAME --password=$PASSWORD --host=$DBHOST --port=$PORT $OPT $1 | $COMP > "$2$SUFFIX"
 else
-	mysqldump --user=$USERNAME --password=$PASSWORD --host=$DBHOST $OPT $1 > $2
+	mysqldump --user=$USERNAME --password=$PASSWORD --host=$DBHOST --port=$PORT $OPT $1 > $2
 fi
 return 0
 }
@@ -443,9 +444,9 @@
 # If backing up all DBs on the server
 if [ "$DBNAMES" = "all" ]; then
 	if [ "$SOCKET" ]; then
-        DBNAMES="`mysql --user=$USERNAME --password=$PASSWORD --host=$DBHOST --socket=$SOCKET --batch --skip-column-names -e "show databases"| sed 's/ /%/g'`"
+        DBNAMES="`mysql --user=$USERNAME --password=$PASSWORD --host=$DBHOST --port=$PORT --socket=$SOCKET --batch --skip-column-names -e "show databases"| sed 's/ /%/g'`"
 	else
-        DBNAMES="`mysql --user=$USERNAME --password=$PASSWORD --host=$DBHOST --batch --skip-column-names -e "show databases"| sed 's/ /%/g'`"
+        DBNAMES="`mysql --user=$USERNAME --password=$PASSWORD --host=$DBHOST --port=$PORT --batch --skip-column-names -e "show databases"| sed 's/ /%/g'`"
 	fi
 	# If DBs are excluded
 	for exclude in $DBEXCLUDE
@@ -476,7 +477,7 @@
 		        MDB="`echo $MDB | sed 's/%/ /g'`"
 
 			if [ ! -e "$BACKUPDIR/monthly/$MDB" ]		# Check Monthly DB Directory exists.
-			then
+				then
 				mkdir -p "$BACKUPDIR/monthly/$MDB"
 			fi
 			echo Monthly Backup of $MDB...
@@ -593,8 +594,7 @@
 echo ======================================================================
 
 # Run command when we're done
-if [ "$POSTBACKUP" ]
-	then
+if [ "$POSTBACKUP" ]; then
 	echo ======================================================================
 	echo "Postbackup command output."
 	echo
@@ -607,56 +607,47 @@
 exec 1>&6 6>&-      # Restore stdout and close file descriptor #6.
 exec 2>&7 7>&-      # Restore stderr and close file descriptor #7.
 
-if [ "$MAILCONTENT" = "files" ]
-then
-	if [ -s "$LOGERR" ]
-	then
+if [ "$MAILCONTENT" = "files" ]; then
+	if [ -s "$LOGERR" ]; then
 		# Include error log if is larger than zero.
 		BACKUPFILES="$BACKUPFILES $LOGERR"
 		ERRORNOTE="WARNING: Error Reported - "
 	fi
 	#Get backup size
 	ATTSIZE=`du -c $BACKUPFILES | grep "[[:digit:][:space:]]total$" |sed s/\s*total//`
-	if [ $MAXATTSIZE -ge $ATTSIZE ]
-	then
+	if [ $MAXATTSIZE -ge $ATTSIZE ]; then
 		BACKUPFILES=`echo "$BACKUPFILES" | sed -e "s# # -a #g"`	#enable multiple attachments
 		mutt -s "$ERRORNOTE MySQL Backup Log and SQL Files for $HOST - $DATE" $BACKUPFILES $MAILADDR < $LOGFILE		#send via mutt
 	else
 		cat "$LOGFILE" | mail -s "WARNING! - MySQL Backup exceeds set maximum attachment size on $HOST - $DATE" $MAILADDR
 	fi
-elif [ "$MAILCONTENT" = "log" ]
-then
+elif [ "$MAILCONTENT" = "log" ]; then
 	cat "$LOGFILE" | mail -s "MySQL Backup Log for $HOST - $DATE" $MAILADDR
-	if [ -s "$LOGERR" ]
-		then
-			cat "$LOGERR" | mail -s "ERRORS REPORTED: MySQL Backup error Log for $HOST - $DATE" $MAILADDR
+	if [ -s "$LOGERR" ]; then
+		cat "$LOGERR" | mail -s "ERRORS REPORTED: MySQL Backup error Log for $HOST - $DATE" $MAILADDR
 	fi	
-elif [ "$MAILCONTENT" = "quiet" ]
-then
-	if [ -s "$LOGERR" ]
-		then
-			cat "$LOGERR" | mail -s "ERRORS REPORTED: MySQL Backup error Log for $HOST - $DATE" $MAILADDR
-			cat "$LOGFILE" | mail -s "MySQL Backup Log for $HOST - $DATE" $MAILADDR
+elif [ "$MAILCONTENT" = "quiet" ]; then
+	if [ -s "$LOGERR" ]; then
+		cat "$LOGERR" | mail -s "ERRORS REPORTED: MySQL Backup error Log for $HOST - $DATE" $MAILADDR
+		cat "$LOGFILE" | mail -s "MySQL Backup Log for $HOST - $DATE" $MAILADDR
 	fi
 else
-	if [ -s "$LOGERR" ]
-		then
-			cat "$LOGFILE"
-			echo
-			echo "###### WARNING ######"
-			echo "Errors reported during AutoBackupMySQL execution.. Backup failed"
-			echo "Error log below.."
-			cat "$LOGERR"
+	if [ -s "$LOGERR" ]; then
+		cat "$LOGFILE"
+		echo
+		echo "###### WARNING ######"
+		echo "Errors reported during AutoBackupMySQL execution.. Backup failed"
+		echo "Error log below.."
+		cat "$LOGERR"
 	else
 		cat "$LOGFILE"
 	fi	
 fi
 
-if [ -s "$LOGERR" ]
-	then
-		STATUS=1
-	else
-		STATUS=0
+if [ -s "$LOGERR" ]; then
+	STATUS=1
+else
+	STATUS=0
 fi
 
 # Clean up Logfile


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.




2009	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec (5)
2010	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov (1)	Dec

autobackupmysql-svnmail Mailing List for AutoBackupMySQL

autobackupmysql-svnmail — Receives SVN commit notifications