#!/bin/bash
echo "SELECT customers.username, db_name FROM mysql_databases INNER JOIN customers ON mysql_databases.cust_id=customers.cust_id;" | mysql -uUSERNAME --pPASSWORD@\$\$ -D StartableHosting -N | while read -r username db_name;
do
mysqldump -uUSERNAME -pPASSWORD $db_name > /etc/scripts/$db_name.sql
ssh username@domain2.com "cat /etc/scripts/$db_name.sql > ~/backups/$db_name.sql"
done