MYSQL database pull from remote server (heroku like)

db-pull

#!/bin/bash

FILE="/var/www/${1}.sql"

echo "Delete remote dump [${FILE}]"
ssh [email protected] "rm -rf ${FILE}"

echo "Remote database dump"
ssh [email protected] "mysqldump --user=root --password=XYZ ${1} > ${FILE}"

# echo "Deleting local backup"
# rm -rf "${1}.sql"

echo "Backup download"
scp "[email protected]:${FILE}" .

echo "Backup import"
mysql --user=root $1 < "${1}.sql"

echo "Finito!"