#!/bin/bash

REMOTE_USER=''
REMOTE_HOST=''
REMOTE_PORT=''

MYSQL_REMOTE_USER=''
MYSQL_REMOTE_PASS=''
MYSQL_REMOTE_DB=''


MYSQL_LOCAL_USER=''
MYSQL_LOCAL_PASS=''
MYSQL_LOCAL_DB=''

mysql -u${MYSQL_LOCAL_USER} -p${MYSQL_LOCAL_PASS} << EOF
    DROP DATABASE IF EXISTS ${MYSQL_LOCAL_DB};
    CREATE DATABASE IF NOT EXISTS ${MYSQL_LOCAL_DB} CHARACTER SET utf8 COLLATE utf8_general_ci;
EOF

BACKUP_FILE="/tmp/${MYSQL_REMOTE_DB}.sql.gz"

if [ ! -f ${BACKUP_FILE} ]; then
    echo -e "Connecting to remote host[${REMOTE_HOST}:${REMOTE_PORT}] and dump the '${MYSQL_REMOTE_DB}' database"
    ssh -p${REMOTE_PORT} ${REMOTE_USER}@${REMOTE_HOST}  "mysqldump -u${MYSQL_REMOTE_USER} -p${MYSQL_REMOTE_PASS} ${MYSQL_REMOTE_DB} --lock-tables=false | gzip -4 --stdout" > ${BACKUP_FILE}
    echo -e "Done!"
fi

echo -e "Start importing data from ${BACKUP_FILE} into '${MYSQL_LOCAL_DB}'"
gunzip < ${BACKUP_FILE} | mysql -u${MYSQL_LOCAL_USER} -p${MYSQL_LOCAL_PASS} ${MYSQL_LOCAL_DB}
echo -e "Done!"

echo -e "All Done!"