#!/bin/sh
# Live database copier

REMOTE_HOST="72.3.165.44"
REMOTE_DB="410093_F62BDEA676"
REMOTE_USER="410093_E6453D73D5"
REMOTE_PASS="D7BB95F4AD"

LOCAL_HOST="127.0.0.1"
LOCAL_DB="maryanne_joomla"
LOCAL_USER="maryanne_joomla"
LOCAL_PASS="D7BB95F4AD"

MYSQL="$(which mysql)"
MYSQLDUMP="$(which mysqldump)"


CMD="$MYSQLDUMP --lock-tables --add-drop-table -h'$REMOTE_HOST' -u'$REMOTE_USER' -p'$REMOTE_PASS' $REMOTE_DB | $MYSQL -h'$LOCAL_HOST' -u'$LOCAL_USER' -p'$LOCAL_PASS' --database $LOCAL_DB"
echo "Running: $CMD"
echo
eval $CMD