Pull the remote database to the MySQL Docker container.

pull-remote-db.sh

#!/bin/bash

# Production credentials
DB_PROD_HOST=""
DB_PROD_NAME=""
DB_PROD_USER=""
DB_PROD_PASS=""

# Local credentials
DB_LOCAL_HOST=""
DB_LOCAL_NAME=""
DB_LOCAL_USER=""
DB_LOCAL_PASS=""
CHARACTER="utf8"
COLLATE="utf8_general_ci"

# Inner variables
CHANGE_MYSQL_DIR="cd /var/lib/mysql"
RM_DUMP="rm $DB_PROD_NAME.sql || true"
CREATE_DUMP="mysqldump -h$DB_PROD_HOST -u$DB_PROD_USER -p$DB_PROD_PASS $DB_PROD_NAME > $DB_PROD_NAME.sql"
RM_LOCAL_DB="mysql -h$DB_LOCAL_HOST -u$DB_LOCAL_USER -p$DB_LOCAL_PASS -e 'drop database $DB_LOCAL_NAME' || true"
CREATE_LOCAL_DB="mysql -h$DB_LOCAL_HOST -u$DB_LOCAL_USER -p$DB_LOCAL_PASS -e 'create database $DB_LOCAL_NAME character set $CHARACTER collate $COLLATE'"
IMPORT_DUMP="mysql -h$DB_LOCAL_HOST -u$DB_LOCAL_USER -p$DB_LOCAL_PASS $DB_LOCAL_NAME < $DB_PROD_NAME.sql"
COMMAND="$CHANGE_MYSQL_DIR && $RM_DUMP && $CREATE_DUMP && $RM_LOCAL_DB && $CREATE_LOCAL_DB && $IMPORT_DUMP"

read -p "Pull db from live? (Y/N): " pull_db
if [[ ${pull_db} == [yY] || ${pull_db} == [yY][eE][sS] ]]; then
    docker exec -it -u 1000 db bash -c "$COMMAND"
fi