MYSQL database push to remote server

db-push

#!/bin/bash

FILE="${1}.sql"

rm -rf $FILE

echo "Database dump to [${FILE}]"
mysqldump -u root $1 > $FILE

echo "Deleting remote database"
ssh [email protected] "rm -rf /var/www/${FILE}"

echo "Database backup upload"
scp $FILE [email protected]:/var/www

echo "Remote backup import"
ssh [email protected] "mysql --user=root --password=XYZ ${1} < /var/www/${FILE}"

echo "Restart NGINX engine"
ssh [email protected] "/root/batch/restartx"