#!/bin/bash

DUMP="/usr/bin/mysqldump"
TAR="/bin/tar"

BK_DIR="/data/backup/" #local backup dir

NOW=`date +%d%m%Y`
TODAY=`date +%Y-%m-%d`

BK_DIR=$BK_DIR/$TODAY

SQL_HOST="x.x.x.x"  #ip of ftp server

# Define mysql sock, user, pass
USER="root"
PASS="password"

db_list="
db1
db2
db3
db4
db5
"

if  [ ! -d $BK_DIR ]; then
        mkdir -p $BK_DIR
fi

funcbackup()
{
#BACKUP-------------------------
DBNAME=$1
FILE=$DBNAME"_"$NOW.sql

#Dump the DB
$DUMP -h $SQL_HOST -u $USER -p$PASS $DBNAME  > $BK_DIR/$FILE

# tar backup
tar -zcvf $BK_DIR/$FILE.tar.gz $BK_DIR/$FILE

# remove .sql
rm -f $BK_DIR/$FILE

}

# make backup
for db in $db_list; do
   funcbackup $db
done

## sycn to backup server