From cd110f2944e9fb37cd1f21bb869d24949f6941f0 Mon Sep 17 00:00:00 2001
From: Alexander Sulfrian <alexander@sulfrian.net>
Date: Fri, 11 Dec 2009 00:18:29 +0100
Subject: new version, mysql binlog reset

---
 mysql/mysql_backup.sh | 87 ++++++++++++---------------------------------------
 1 file changed, 20 insertions(+), 67 deletions(-)

(limited to 'mysql')

diff --git a/mysql/mysql_backup.sh b/mysql/mysql_backup.sh
index 70a93dd..632c010 100755
--- a/mysql/mysql_backup.sh
+++ b/mysql/mysql_backup.sh
@@ -7,10 +7,6 @@ MYSQL_SERVER="localhost"
 MYSQL_USER="backup"
 MYSQL_PASSWORD="password"
 
-# databases to exclude, seperated by space
-# TODO
-#MYSQL_EXCLUDE_DB=""
-
 # ftp server data
 FTP_SERVER="backup"
 FTP_USER="ftp"
@@ -31,78 +27,35 @@ LOGGING="0"
 
 ## end of configuration
 
-# only output something if logging is enabled
-log() {
-    if [ $LOGGING -eq 0 ]; then
-	if [ -n "$1" ]; then
-	    echo "$@"
-	else
-	    cat
-	fi
-    fi 
-}
-
-# selfupdate magic
-_self_update() {
-    pushd $(dirname $0) &>/dev/null
-
-    git fetch origin 2>/dev/null
-    if [[ -n "$(git whatchanged HEAD..origin/master)" ]]; then
-	echo "Selfupdating backupscript..." | log
-	git merge origin/master | log
-	echo "Selfupdating done." | log
-	echo | log
-
-	popd &>/dev/null
-	exec $0
-    fi
-
-    popd &>/dev/null
-}
+# load common stuff
+BACKUP_ROOT=".."
+source ${BACKUP_ROOT}/common/init.sh
 
 # check for tools
-for prog in git mysqlshow mysqldump ncftpput
-do 
-    if ! hash $prog 2>/dev/null ; then
-	echo "Error: This script needs '$prog'. Exiting..." >&2
-	exit 1
-    fi
-done
-
-_self_update
+_check_tools mysqlshow mysqldump ncftpput
 
-echo "Started backup of mysql databases ($(date +%c)):" | log
-echo | log
+echo "Started backup of mysql databases ($(date +%c)):" | _log
+echo | _log
 
 # create temporary dir
 mkdir -p ${TMP_DIRECTORY}
 TMP_DIR=$(mktemp -d --tmpdir=${TMP_DIRECTORY})
 pushd ${TMP_DIR} >/dev/null 2>&1
 
-# enumerate all mysql databases
-MYSQL_DATABASES=$(mysqlshow -h${MYSQL_SERVER} -u${MYSQL_USER} \
-    -p${MYSQL_PASSWORD} | awk '{ print $2 }' | grep -v "^$" | sed \
-    '1d')
-
-# backup all databases to file
-for db in ${MYSQL_DATABASES}
-do
-    mysqldump -h${MYSQL_SERVER} -u${MYSQL_USER} -p${MYSQL_PASSWORD} \
-	${db} | bzip2 -zc > "${BACKUP_PREFIX}_${db}.sql.bz2"
-done
-
-# echo created log
-du -sch * | log
-echo | log
-
-# move backups to ftp server
-for file in *
-do
-    ncftpput -u${FTP_USER} -p${FTP_PASSWORD} -V -DD ${FTP_SERVER} \
-	${FTP_TARGET} ${file} >/dev/null
-done
-
-echo "Finished backup of mysql databases ($(date +%c))" | log
+# backup all databases to file and reset binlog
+mysqldump -h${MYSQL_SERVER} -u${MYSQL_USER} -p${MYSQL_PASSWORD} \
+    --flush-logs --master-data=2 --all-databases --delete-master-logs \
+    --lock-all-tables | bzip2 -zc > "${BACKUP_PREFIX}.sql.bz2"
+
+# echo created log of file sizes
+du -sch "${BACKUP_PREFIX}.sql.bz2" | _log
+echo | _log
+
+# move backup to ftp server
+ncftpput -u"${FTP_USER}" -p"${FTP_PASSWORD}" -V -DD "${FTP_SERVER}" \
+    "${FTP_TARGET}" "${BACKUP_PREFIX}.sql.bz2" >/dev/null
+
+echo "Finished backup of mysql databases ($(date +%c))" | _log
 
 # restore old cwd
 popd >/dev/null 2>&1
-- 
cgit v1.2.3