echo "restore_app_db.sh"

echo $1 # HOST
echo $2 # DB
echo $3 # APP
echo $4 # USER
echo $5 # PASS

MYSQL_HOST=$1
MYSQL_USER=$4
MYSQL_PASS=$5

if [ -z "$MYSQL_PASS" ]; then
  pass_string=''
else
  pass_string="-p${MYSQL_PASS}"
fi

APP_DB=$2
SQL_SOURCE=$3

THISDIR="$( cd "$( dirname "${BASH_SOURCE[0]}" )" && pwd )"

mysql  $pass_string -h $MYSQL_HOST -u $MYSQL_USER -e "DROP DATABASE IF EXISTS \`${APP_DB}\`; CREATE DATABASE \`${APP_DB}\` CHARACTER SET utf8 COLLATE utf8_bin;"
mysql $pass_string ${MYSQL_PASS} -h $MYSQL_HOST -u $MYSQL_USER ${APP_DB} < $THISDIR/sql/$SQL_SOURCE.sql