#!/bin/sh

# this file promotes stage to prod

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 ${DS}/ ${DP}/ --delete

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

sed -i -e "s/${MS}/${MP}/" ${DP}/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