#!/bin/bash

DBUSER='admin' # the database username
LMCTC_DBUSER='nlclm_lmctcSQL'
NLC_DBUSER='nlclm_nlcUSER'

DBPASS='27CNYwest' # the database password
LMCTC_DBPASS='23MoveItLets2012'
NLC_DB_PASS='enELsee12nyc'


DBNAME='lmctc_org' # the name of the database

LMCTC_DBNAME='nlclm_lmctc_org'
NLC_DB_NAME='nlclm_nlc_site'

PRODUCTION='216.70.91.123' # live host

NEW_HOST='localhost' # dev host

OPTS_LMCTC="-q --single-transaction --add-locks --create-options -F --databases ${DBNAME}"
OPTS_LMCTC="${OPTS_LMCTC} --add-drop-database"

OPTS_NLC="-q --single-transaction --add-locks --create-options -F --databases nlc_site"
OPTS_NLC="${OPTS_NLC} --add-drop-database"

# FOR MASTER/SLAVE #  
# OPTS="${OPTS} --master-data=2"

# EXCLUDED TABLES #
#OPTS="${OPTS} --ignore-table=${DBNAME}.venue_geo"


#echo $OPTS_LMCTC
#echo $OPTS_NLC
#exit

mysqldump -h $PRODUCTION -u $DBUSER -p$DBPASS $OPTS_LMCTC | \
 tee tmp.out | \
  mysql -h $NEW_HOST -u $LMCTC_DBUSER -p$LMCTC_DBPASS  $LMCTC_DBNAME

mysqldump -h $PRODUCTION -u nlcUSER -penELsee12nyc $OPTS_NLC | \
 tee tmp.out | \
  mysql -h $NEW_HOST -u $NLC_DBUSER -p$NLC_DBPASS  $NLC_DBNAME