#!/bin/bash

EPOCHDATE=`/bin/date +%a`
echo $EPOCHDATE
mkdir /big/MySQLBackup/$EPOCHDATE

TMPFILE=`mktemp /tmp/mysql.bkp.XXXXXX` || exit 1
 /usr/local/mysql/bin/mariadb -u root -pAudiA4quattro -N mysql < /big/MySQLBackup/query.sql > $TMPFILE

while read db
do

        if [ $db = "d65707" ]; then
                echo "SKIPING DATABASE d65707 !!!"
                continue;
        fi

       echo "Working on database '$db'... "

        /usr/local/mysql/bin/mariadb-dump -uroot -pAudiA4quattro --quick -Q $db > /big/MySQLBackup/$EPOCHDATE/$db.sql

done < $TMPFILE

rm -f $TMPFILE