import_db.sh

#!/usr/bin/env bash

REMOTE_DATABASE_NAME=""
REMOTE_SQL_USER=""
REMOTE_SQL_PASS=""

LOCAL_SQL_USER=""
LOCAL_SQL_PASS=""
LOCAL_DATABASE_NAME=""

REMOTE_SSH_USER=""
REMOTE_SSH_HOST=""

echo "Le prochain mot de passe demandé est le mot de passe ssh pour ${REMOTE_SSH_USER}@${REMOTE_SSH_HOST}"; \
ssh -C ${REMOTE_SSH_USER}@${REMOTE_SSH_HOST} "mysqldump --add-drop-table --extended-insert --force -u ${REMOTE_SQL_USER} -p'${REMOTE_SQL_PASS}' ${REMOTE_DATABASE_NAME}" | mysql -u${LOCAL_SQL_USER} $(if test -n "${LOCAL_SQL_PASS}"; then echo -p"${LOCAL_SQL_PASS}"; fi) ${LOCAL_DATABASE_NAME}


LOCAL_URL=""
echo "UPDATE \`core_config_data\` SET \`value\` = '${LOCAL_URL}' WHERE \`path\` = 'web/unsecure/base_url' OR \`path\` = 'web/secure/base_url'" | mysql -u${LOCAL_SQL_USER} $(if test -n "${LOCAL_SQL_PASS}"; then echo -p"${LOCAL_SQL_PASS}"; fi) ${LOCAL_DATABASE_NAME}