#!/bin/bash

FILE="${1}.sql"

rm -rf $FILE

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

echo "Deleting remote database"
ssh root@178.79.163.176 "rm -rf /var/www/${FILE}"

echo "Database backup upload"
scp $FILE root@178.79.163.176:/var/www

echo "Remote backup import"
ssh root@178.79.163.176 "mysql --user=root --password=XYZ ${1} < /var/www/${FILE}"

echo "Restart NGINX engine"
ssh root@178.79.163.176 "/root/batch/restartx"