Shell Programming and Scripting

# Main directory where backup will be stored
BAK="$DEST/mysql"

# dont backup this database
DONT="xxx"
 
[ ! -d $BAK] && mkdir -p $BAK || :
 
 
# Get all database list first
DBL="$($MYSQL -u $MyUSER  -p$MyPASS -Bse 'show databases')"
 
for db in $DBL
do
    skipdb=-1
    if [ "$DONT" != "" ];
    then
	for i in $DONT
	do
	    [ "$db" == "$i" ] && skipdb=1 || :
	done
    fi
 
    if [ "$skipdb" == "-1" ] ; then
	FILE="$BAK/$db.$NOW.sql"
	
        $MYSQLDUMP -u $MyUSER -p$MyPASS $db > $FILE
    fi
done

DBL="database1 database2 database3"

$MYSQLDUMP -u $MyUSER -p$MyPASS $db > $FILE