#!/bin/bash
MyUSER="user"
MyPASS="pass"
MyHOST="localhost"
MYSQL="mysql"
MYSQLDUMP="mysqldump"
CHOWN="chown"
CHMOD="chmod"
GZIP="gzip"
DEST="/var/share/backupdb/"
MBD="$DEST/mysql"
HOST="$(hostname)"
NOW="$(date +"%d-%m-%Y")"
FILE=""
DBS=""
IGGY="test"
[ ! -d $MBD ] && mkdir -p $MBD || :
$CHOWN 0.0 -R $DEST
$CHMOD 0755 $DEST
DBS="$($MYSQL -u $MyUSER -h $MyHOST -p$MyPASS -Bse 'show databases')"
for db in $DBS
do
    skipdb=-1
    if [ "$IGGY" != "" ];
    then
    for i in $IGGY
    do
        [ "$db" == "$i" ] && skipdb=1 || :
    done
    fi
    if [ "$skipdb" == "-1" ] ; then
    FILE="$MBD/$db.$HOST.$NOW.gz"
        $MYSQLDUMP -u $MyUSER -h $MyHOST -p$MyPASS $db | $GZIP -9 > $FILE
    fi

done