#!/bin/sh

#
# Oussama Elgoumri
# ktsnepyg9igfz1@gmail.com
#

# this file is located in: /path/to/wordpress/bin

# === Get SQL Database: -------------------------------------------------------
cd ../backup

if [ -f db.sql ]; then rm db.sql; fi

USER=
HOST=

ssh $USER@$HOST <<'END'
    SITE=
    cd /home/oussama/sites/$SITE

    if [ -f db.sql ]; then rm db.sql; fi
    NAME=$(cat wp-config.php | grep db_name -i | cut -d"'" -f4)
    USER=$(cat wp-config.php | grep db_user -i | cut -d"'" -f4)
    PASS=$(cat wp-config.php | grep db_pass -i | cut -d"'" -f4)
    mysqldump -u$USER -p$PASS $NAME > db.sql
    if [ -f wp-content/uploads.zip ]; then rm wp-content/uploads.zip; fi
    if [ -f uploads.zip ]; then rm uploads.zip; fi
    cd wp-content
    zip -rqu uploads.zip uploads
    cd ..
    mv wp-content/uploads.zip .
    exit
END

# === Get the Data: -----------------------------------------------------------
SITE_URL=
wget $SITE_URL/db.sql

cd ../wp-content
if [ -f uploads.zip ]; then rm  uploads.zip; fi
wget $SITE_URL/uploads.zip
unzip uploads.zip
cd ..

# === Use the Remote DB: ------------------------------------------------------
DB=
mysql -uroot -e "DROP DATABASE $DB"
mysql -uroot -e "CREATE DATABASE $DB"
mysql -uroot $DB < backup/db.sql

DOMAIN=
LOCAL_DOMAIN=
wp search-replace $DOMAIN $LOCAL_DOMAIN --skip-columns=guid