#!/bin/bash
#
# MySQL Backup Script
# 
# von ccc (http://www.unixboard.de/vb3/member.php?u=1436)
# dumps Databases 
# 
# 
# changed by lukewill at mambogtt (.) de
#
#set -o xtrace

####################################################
# please check the parameters below !!!

# logfile is saved here
LOG=/var/log/mysqlbackup.log

echo "------------------------------------------------------------------------">>$LOG
echo "`date`">>$LOG
echo "------------------------------------------------------------------------">>$LOG

# mysql binaries are located here
MYSQLBIN=/usr/bin

# the backup are saved in this directory
DUMPDIR=/home/mysqlbackup 

# the maxium backup per day
MAXARCHIVDIRS=24

# older files where deleted
MAXHOLDDAYS=1

# we look for the compressing programm in this location
ZIPPROC=/usr/bin/gzip

# DATABASES hold the triple DATABASENAME USER PASSWORD
# Example: mysql root secret
#DATABASES="db1 user_db1 pass1 db2 user_db2 pass2 test root 12345"

#
# STOP !  It is done. 
####################################################


#################################
dump () {
	if [ -n  "$3" ] 
	then
		while [ -n "$1" ] 
		do
			DB=$1
			shift;
			[ -n "$1" ] || break
			USER=$1
			shift;
			[ -n "$1" ] || break
			PASS=$1
			echo "Backup Database $DB">>$LOG
  			if $MYSQLBIN/mysqldump -u $USER --password=$PASS --flush-logs --opt $DB 2>>$LOG > $DB
			then
				echo "BACKUP OK!">>$LOG
			else
				#FAIL
				if $MYSQLBIN/mysqldump -u $USER --password=$PASS $DB > $DB
				then
					echo "BACKUP OK!!">>$LOG
				else
					#FAIL
					echo "BACKUP FAIL !">>$LOG
				fi
			fi
			shift;
		done
	fi
}

#################################
clean () {
	cd $DUMPDIR
	echo "delete: `find . -type d -mtime +$MAXHOLDDAYS -print`">>$LOG
	find . -type d -mtime +$MAXHOLDDAYS -print0|xargs -0 rm -rf 
}

#################################
zip () {
	cd $ARCHIVDIR
	if test -x $ZIPPROC
	then
		for n in *
		do
			$ZIPPROC $n
		done
	fi
}

#################################

ARCHIVDIR=`date +%Y%m%d`
cd $DUMPDIR
i=1
if [ -d $ARCHIVDIR ]
then
        b="$ARCHIVDIR#$i"
        while [ -d $b ]
        do
                let i=i+1
                b="$ARCHIVDIR#$i"
                if [ $i -gt $MAXARCHIVDIRS ]
                then
                        echo "MAXARCHIVDIRS limit reached -> exit">>$LOG
                        exit 0
                fi
        done
        echo "ARCHIVDIR: $b">>$LOG
        ARCHIVDIR=$b
fi
mkdir $ARCHIVDIR
cd $ARCHIVDIR

# main

if test -x $MYSQLBIN/mysqldump
then
	dump $DATABASES
	clean
	zip
	echo "THE END">>$LOG
	echo "------------------------------------------------------------------------">>$LOG
else
     	echo "Backup failed: $MYSQLBIN/mysqldump not found or not executable!">>$LOG
	echo "------------------------------------------------------------------------">>$LOG
fi

z.B. SQLBACKUP.BAT

SET MYSQLHOST=Domain oder IP, unter der die DB erreicht werden kann
SET MYSQLUNAME=Dein DB_Username
SET MYSQLPASSWD=Dein Passwort
SET MYSQLDB=Name der Datenbank