#!/bin/sh

# this file demotes prod 2 stage

DS=/home/gresbqxm/stage.smgearbots.org
DP=/home/gresbqxm/smgearbots.org
WS=http://stage.smgearbots.org
WP=http://www.smgearbots.org
MS=gresbqxm_stage_smgearbots
MP=gresbqxm_smgearbots
MYSQL_USER=gresbqxm_wordpress
MYSQL_PASS=press2010word

rsync -avx ${DP}/ ${DS}/ --delete

mysqldump -u$MYSQL_USER -p"${MYSQL_PASS}" $MP | \
   sed -e "s#${DP}#${DS}#g" | \
   sed -e "s#${WP}#${WS}#g" | \
   mysql -u$MYSQL_USER -p"${MYSQL_PASS}" $MS

sed -i -e "s/${MP}/${MS}/" ${DS}/wp-config.php

#cat << EOM1 | mysql -pB@ttleB0ts wp_s_dsmaine
#UPDATE wp_options SET option_value = REPLACE(option_value, 'www.greslick.com', 'www.stage.greslick.com');
#UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, 'www.greslick.com', 'www.stage.greslick.com');
#UPDATE wp_posts SET guid = REPLACE(guid, 'www.greslick.com', 'www.stage.greslick.com');
#UPDATE wp_posts SET post_content = REPLACE(post_content, 'www.greslick.com', 'www.stage.greslick.com');
#EOM1