#!/bin/bash -x

REMOTE_DB_SERVER=xxxxx
REMOTE_DB=xxxxxx
REMOTE_DB_USER=dotcms
REMOTE_DB_PASSWORD=xxxxx
REMOTE_LINUX_USER=dotcms
REMOTE_ASSET_SERVER=xxxxxx
REMOTE_INSTALL_PATH=xxxxxxx

#SSH_OPTIONS=-i ~/.hidden_key

LOCAL_DB_HOST=xxxxx
LOCAL_DB=dotcms_dev_19
LOCAL_DB_PASSWORD=xxxxx
LOCAL_INSTALL_PATH=/dotcms_local/current


. /etc/profile
$LOCAL_INSTALL_PATH/bin/shutdown.sh -force



## POSTGRES
#dropdb $LOCAL_DB
#createdb $LOCAL_DB
#ssh $SSH_OPTIONS $REMOTE_LINUX_USER=dotcms@$REMOTE_DB_SERVER "export PGPASSWORD=$REMOTE_DB_PASSWORD ; pg_dump -h localhost -T clickstream -i -T clickstream_request -O -U $REMOTE_DB_USER $REMOTE_DB > /tmp/backup1.sql"

## MYSQL
ssh $SSH_OPTIONS $REMOTE_LINUX_USER=dotcms@$REMOTE_DB_SERVER "mysqldump -h localhost --ignore-table=clickstream --ignore-table=clickstream_request -u $REMOTE_DB_USER $REMOTE_DB --password=$REMOTE_DB_PASSWORD > /tmp/backup1.sql"

scp $SSH_OPTIONS $REMOTE_LINUX_USER@$REMOTE_DB_SERVER:/tmp/backup1.sql /tmp/backup1.sql

## POSTGRES
#psql -h $LOCAL_DB_HOST -f /tmp/backup1.sql $LOCAL_DB

##MYSQL
mysql -h $LOCAL_DB_HOST


rsync -avz -e "ssh -i /root/.hidden_key" root@$REMOTE_ASSET_SERVER:$REMOTE_INSTALL_PATH/dotCMS/assets/ /ebs/dotcms/testcluster/assets

rm -rf $LOCAL_INSTALL_PATH/dotCMS/dotsecure/dotlucene


rsync -avz -e "ssh -i /root/.hidden_key" root@$REMOTE_ASSET_SERVER:$REMOTE_INSTALL_PATH/dotCMS/dotsecure/dotlucene/ $LOCAL_INSTALL_PATH/dotCMS/dotsecure/dotlucene


#$LOCAL_INSTALL_PATH/bin/startup.sh