#!/bin/bash
#ssh root@46.105.42.241 'dat=$(date +%d-%m-%Y); mysqldump -u root -pB@k2 -B aurora | gzip > "/dump_aurora_"$dat".sql.gz";'
#dat=$(date '+%d-%m-%Y')
#scp -p root@46.105.42.241:"/dump_aurora_"$dat".sql.gz" "/dump_aurora_"$dat".sql.gz"
#ssh root@46.105.42.241 'dat=$(date +%d-%m-%Y); rm "/dump_aurora_"$dat".sql.gz";'
#mysql -h localhost -u root -pB@k2 -e "DROP DATABASE aurora"
#mysql -h localhost -u root -pB@k2 -e "CREATE DATABASE aurora"
#gzip -d "/dump_aurora_"$dat".sql.gz"
#mysql -u root -pB@k2 aurora < "/dump_aurora_"$dat".sql"
#rm "/dump_aurora_"$dat".sql"


ssh root@87.98.251.54 'dat=$(date +%d-%m-%Y); mysqldump -u test -pP@ssw0rdTEST -B aurora_reporting | gzip > "/dump_aurora_"$dat".sql.gz";'
dat=$(date '+%d-%m-%Y')
scp -p root@87.98.251.54:"/dump_aurora_"$dat".sql.gz" "/dump_aurora_"$dat".sql.gz"
ssh root@87.98.251.54 'dat=$(date +%d-%m-%Y); rm "/dump_aurora_"$dat".sql.gz";'
mysql -h localhost -u test -pP@ssw0rdTEST -e "DROP DATABASE aurora_reporting"
mysql -h localhost -u test -pP@ssw0rdTEST -e "CREATE DATABASE aurora_reporting"
gzip -d "/dump_aurora_"$dat".sql.gz"
mysql -u test -pP@ssw0rdTEST aurora_reporting < "/dump_aurora_"$dat".sql"
rm "/dump_aurora_"$dat".sql"