#!/bin/sh
# Cpanel to Cpanel DB copy

USAGE="Usage: sync_db.sh <remote_host> <remote_pass> <remote_db>"

if [ -z "$1" ] || [ -z "$2" ] || [ -z "$3" ]
  then
    echo $USAGE
    exit
fi

REMOTE_HOST="$1"
REMOTE_DB=$3
REMOTE_USER="root"
REMOTE_PASS="$2"

LOCAL_DB=$3

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 --database $LOCAL_DB"

echo "Running: $CMD"
echo
eval $CMD