#define database source: res_mysql="[declare as mysql] [where to store] [dbase_name] [dbuser] [dbpasswd] [(if_db_in_VZ)VZID]"
# the name of the array has to start with "res"

res_customer1database="mysql www_myapp_net /var/backup/local/ bkupuser securepasswd 144" 

source $configfile
date1=`date +%Y.%m.%d`
errlog="/var/log/wherever/"
vzctl="/usr/sbin/vzctl"

#### mysqldump function
_dump() {
	# check for backup dir
	if [ ! -d $2/$5/ ] ; then mkdir -p $2/$5 ; fi
        # check if to use inside a VPS
	case $# in 
	# dump locally
                4 ) cd $2 && mysqldump -u $3 -p$4 $1 > $1.$date1.sql && \
tar Pczf $1.$date1.sql.tar.gz $1.$date1.sql && rm -rf $1.$date1.sql 2>> $errlog ;;
	# dump inside VPS
		5 ) $vzctl exec $5 "if [ ! -d $2 ] ; then mkdir -p $2 ; fi && cd $2 && \ 
mysqldump -u $3 -p$4 $1 > $1.$date1.sql && \ 
tar Pczf $1.$date1.sql.tar.gz $2/$1.$date1.sql && rm -rf $2/$1.$date1.sql" 2>> $errlog 
	# now for example move from VPS to backup device
                mv /vz/root/$5/$2/$1.$date1.sql.tar.gz $2/$5
	 ;;

        esac

#### call functions
k=${!res@}
for b in $k ; do
	a=(${!b})
        case ${a[0]} in
		mysql ) _dump "${a[1]}" "${a[2]}" "${a[3]}" "${a[4]}" "${a[5]}" ;;
		* ) _mailto "Don't know how to backup ${a[1]}" "ERROR" ;;
	esac

done

find $2/$5/ -mtime +7 -execdir rm -f '{}' \;