mysqldump.sh

#!/usr/bin/env bash

HOST=127.0.0.1
USER=root
PASSWD=root
OUTPATH=./
# backup de base dados
DATABASES="
database1
database2
database3"

# total databases
echo $DATABASES | wc -w > /tmp/count.txt
total=`cat /tmp/count.txt`
index=1

for DATABASE in $DATABASES; do
    echo "[$index/$total] Realizando backup de ${DATABASE} ...";
    /usr/bin/mysqldump $DATABASE --user=$USER -p$PASSWD  --host=$HOST --result-file="$OUTPATH/${DATABASE}.sql"

    index=$(($index+1))
done

echo
echo "Terminado!"