MYSQL database pull from remote server (heroku like)

db-pull

#!/bin/bash

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

echo "Delete remote dump [${FILE}]"
ssh root@178.79.163.176 "rm -rf ${FILE}"

echo "Remote database dump"
ssh root@178.79.163.176 "mysqldump --user=root --password=XYZ ${1} > ${FILE}"

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

echo "Backup download"
scp "root@178.79.163.176:${FILE}" .

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

echo "Finito!"