Code :

## INFOS MYSQL ##
LOGIN=root # Login for mysql
PASS=toto # Pass for mysql

## SSH SERVER FOR TRANSFERT & REINJECTION ##
MYSQLSRV2="192.168.0.1"

## Email ##
ADMINMAIL=user@fqdn.com # This is the mail were the transferts failures will be notified

## Vars ##
TMPDIR=/tmp/baksql # Temp directory

## DO NOT MODIFY NOW ##
mkdir $TMPDIR
# Backuping databases
for databases in "bugzilla" "cacti" "mysql" "networkdb" "wiki" ; do
mysqldump -u$LOGIN -p$PASS $databases > $TMPDIR/$databases-'date +%y%m%d'.sql && baksql=$baksql'echo "Sauvegarde de la base $databases - OK ; "' || baksql=$baksql'echo "Sauvegarde de la base $databases - FAILED ; "'
done

# Transfering databases to the other SQL server (need ssh key)
tar -czf $TMPDIR/mysql_backup.tgz $TMPDIR/*.sql
scp $TMPDIR/mysql_backup.tgz $MYSQLSRV2:~/
ssh $MYSQLSRV2 tar -xzvf ~/mysql_backup.tgz
for databases in "bugzilla" "cacti" "mysql" "networkdb" "wiki" ; do
ssh $MYSQLSRV2 "mysql -u$LOGIN -p$PASS $databases < ~/tmp/baksql/$databases-'date +%y%m%d'.sql" && baksql=$baksql'echo "Reinjection de la base $databases - OK ; "' || baksql=$baksql'echo "Reinjection de la base $databases - FAILED ; "'
done

# Delete temps
ssh $MYSQLSRV2 rm -Rf /root/tmp/baksql ~/mysql_backup.tgz ~/tmp
rm -Rf $TMPDIR

# Send mail
echo $baksql | mail -s "Mysql transferts" $ADMINMAIL