Changes - j0ke.net Open Build Service

Changes of Revision 20

[-] [+]	Changed	automysqlbackup.spec
@@ -1,6 +1,6 @@ Name: automysqlbackup Version: 2.6.4 -Release: 2 +Release: 3 Group: System/Backup Summary: MySQL backup script License: GPL @@ -59,6 +59,10 @@ %{_mandir}/man8/automysqlbackup.8* %changelog +* Tue Feb 28 2012 Carsten Schoene <cs@linux-administrator.com> - 2.6.4-3 +- enhanced multimysqlbackup.sh & automysqlbackup to use different + Port numbers + * Fri Oct 21 2011 Carsten Schoene <cs@linux-administrator.com> - 2.6.4-2 - enhanced multimysqlbackup.sh for use on plesk systems - silent errors flag in multimysqlbackup.sh x 1 @@ -1,6 +1,6 @@ 2 Name: automysqlbackup 3 Version: 2.6.4 4 -Release: 2 5 +Release: 3 6 Group: System/Backup 7 Summary: MySQL backup script 8 License: GPL 9 @@ -59,6 +59,10 @@ 10 %{_mandir}/man8/automysqlbackup.8* 11 12 %changelog 13 +* Tue Feb 28 2012 Carsten Schoene <cs@linux-administrator.com> - 2.6.4-3 14 +- enhanced multimysqlbackup.sh & automysqlbackup to use different 15 + Port numbers 16 + 17 * Fri Oct 21 2011 Carsten Schoene <cs@linux-administrator.com> - 2.6.4-2 18 - enhanced multimysqlbackup.sh for use on plesk systems 19 - silent errors flag in multimysqlbackup.sh 20
[-] [+]	Changed	automysqlbackup-2.6.4.sh ^
@@ -43,6 +43,9 @@ # Host name (or IP address) of MySQL server e.g localhost DBHOST=`echo ${DBHOST:=localhost}` + + # Port where MYSQL Server is listening + DBPORT=`echo $[DBPORT:=3306}` # List of DBNAMES for Daily/Weekly Backup e.g. "DB1 DB2 DB3" DBNAMES=`echo ${DBNAMES:="DB1 DB2 DB3"}` @@ -536,7 +539,7 @@ # Database dump function dbdump () { -${MYSQLDUMP} --user=${USERNAME} --password=${PASSWORD} --host=${DBHOST} ${OPT} ${1} > ${2} +${MYSQLDUMP} --user=${USERNAME} --password=${PASSWORD} --host=${DBHOST} --port=${DBPORT} ${OPT} ${1} > ${2} return $? } @@ -544,12 +547,12 @@ if [ "$COMP" = "gzip" ]; then ${ECHO} Backup Information for "${1}.gz" SUFFIX=".gz" - ${MYSQLDUMP} --user=${USERNAME} --password=${PASSWORD} --host=${DBHOST} ${OPT} ${1} \| ${GZIP} > ${2}${SUFFIX} + ${MYSQLDUMP} --user=${USERNAME} --password=${PASSWORD} --host=${DBHOST} --port=${DBPORT} ${OPT} ${1} \| ${GZIP} > ${2}${SUFFIX} ${GZIP} -l "$1.gz" elif [ "$COMP" = "bzip2" ]; then ${ECHO} Compression information for "${1}.bz2" SUFFIX=".bz2" - ${MYSQLDUMP} --user=${USERNAME} --password=${PASSWORD} --host=${DBHOST} ${OPT} ${1} \| ${BZIP2} -v 2>&1 > ${2}${SUFFIX} + ${MYSQLDUMP} --user=${USERNAME} --password=${PASSWORD} --host=${DBHOST} --port=${DBPORT} ${OPT} ${1} \| ${BZIP2} -v 2>&1 > ${2}${SUFFIX} else ${ECHO} "No compression option set, check advanced settings" fi @@ -560,7 +563,7 @@ if [ -n "`echo ${TABLEEXCLUDE} \| grep \"${1}.${2}\"`" ] ; then OPT=`echo ${OPT} \| ${SED} -e 's@ --opt @ --skip-opt @'` fi -${MYSQLDUMP} --user=${USERNAME} --password=${PASSWORD} --host=${DBHOST} ${OPT} ${1} ${2} > ${3} +${MYSQLDUMP} --user=${USERNAME} --password=${PASSWORD} --host=${DBHOST} --port=${DBPORT} ${OPT} ${1} ${2} > ${3} return $? } @@ -572,12 +575,12 @@ echo echo Backup Information for "$3.gz" SUFFIX=".gz" - ${MYSQLDUMP} --user=${USERNAME} --password=${PASSWORD} --host=${DBHOST} ${OPT} ${1} ${2} \| ${GZIP} > ${3}${SUFFIX} + ${MYSQLDUMP} --user=${USERNAME} --password=${PASSWORD} --host=${DBHOST} --port=${DBPORT} ${OPT} ${1} ${2} \| ${GZIP} > ${3}${SUFFIX} ${GZIP} -l "${3}.gz" elif [ "${COMP}" = "bzip2" ]; then echo Compression information for "${3}.bz2" SUFFIX=".bz2" - ${MYSQLDUMP} --user=${USERNAME} --password=${PASSWORD} --host=${DBHOST} ${OPT} ${1} ${2} \| ${BZIP2} -v 2>&1 > ${3}${SUFFIX} + ${MYSQLDUMP} --user=${USERNAME} --password=${PASSWORD} --host=${DBHOST} --port=${DBPORT} ${OPT} ${1} ${2} \| ${BZIP2} -v 2>&1 > ${3}${SUFFIX} else echo "No compression option set, check advanced settings" fi
[-] [+]	Changed	multimysqlbackup.conf ^
@@ -5,5 +5,5 @@ # host;user;password;databases_separated_by_spaces;exclude_databases;exclude_tables # samples: # localhost;root;;all; -# localhost;root;password;mysql my_first_database my_second_database;exclude1_db exclude2_db;exclude3_db.exclude_table1 exclude4_db.exclude_table2 +# localhost:port;root;password;mysql my_first_database my_second_database;exclude1_db exclude2_db;exclude3_db.exclude_table1 exclude4_db.exclude_table2
[-] [+]	Changed	multimysqlbackup.sh ^
@@ -31,7 +31,8 @@ # format: host;user;password;databases_separated_by_spaces;databases_to_exclude_separated_by_spaces;tables_to_exclude - export DBHOST=`echo ${LINE} \| awk -F\; '{print $1}'` + export DBHOST=`echo ${LINE} \| awk -F\; '{print $1}' \| awk -F: '{print $1}'` + export DBPORT=`echo ${LINE} \| awk -F\; '{print $1}' \| awk -F: '{print $2}'` export USERNAME=`echo ${LINE} \| awk -F\; '{print $2}'` export PASSWORD=`echo ${LINE} \| awk -F\; '{print $3}'` export DBNAMES=`echo ${LINE} \| awk -F\; '{print $4}'\|sed -e s@"%20%"@" "@g` @@ -62,6 +63,7 @@ if [ -s /usr/local/psa/version ] && [ -s /etc/psa/.psa.shadow ] ; then export DBHOST="localhost" + export DBPORT="3306" export USERNAME="admin" export PASSWORD=`cat /etc/psa/.psa.shadow` export DBNAMES="all"