restore_script.sh

#!/bin/sh
# Configuration:
PATH_CONFIG="$HOME/vietcoop"
FILE_ARG="$1"

#check file config
if [ ! -f "$PATH_CONFIG/$FILE_ARG" ]
then
echo -e "Not found file config at '$PATH_CONFIG/$FILE_ARG'"
   exit
fi
#inlcude file config
source $PATH_CONFIG/$FILE_ARG

DRUPAL_ROOT="$SITES_ROOT/$SITE_NAME_RESTORE"
#ROOT_USER_NAME="root"
#ROOT_USER_PASS="root"

# Create site root
rm -rf $DRUPAL_ROOT
mkdir -p $DRUPAL_ROOT
cd $DRUPAL_ROOT

# Clone backup site db
git clone $GIT_REMOTE_DB Backupfile

#mysql -u$ROOT_USER_NAME -p$ROOT_USER_PASS -e "CREATE DATABASE $DB_NAME;"
#wget $DB_BACKUP_FILE --directory-prefix="Backupfile"
#mysql -u$ROOT_USER_NAME -p$ROOT_USER_PASS $DB_NAME < Backupfile/*.sql

# Make site from makefile
wget $DRUSH_MAKE_FILE --directory-prefix="Backupfile"
drush make Backupfile/*.make .

# Create settings.php file
mkdir $DRUPAL_DIR
cd sites/default/
cp default.settings.php settings.php

#Restore db and add db_url to setting file 
chmod 777 settings.php
DBURL='$db_url'
OIFS=$IFS;
IFS=";";
DB_URLS=($DB_URL);
for ((i=0; i<${#DB_URLS[@]}; ++i));
do
    URL="${DB_URLS[$i]}"
    DB_NAME="${URL##*/}"
    drush sql-cli --db-url="$URL" "$DRUPAL_ROOT/Backupfile/db_$DB_NAME.sql"
    if [ "$i" == 0 ]; then	
        echo "$DBURL['default'] = $URL;" >> settings.php
    else
        echo "$DBURL['$DB_NAME'] = $URL;" >> settings.php
    fi
done
IFS=$OIFS;
chmod 644 settings.php

# Remove backup file
rm -rf $DRUPAL_ROOT/Backupfile