restore-docker-db.sh

#!/usr/bin/env bash
set -o errexit -o nounset -o pipefail

host_name="$1"
stack_name="$2"
service_name="$3"
db_user="$4"
db_name="$5"
backup_date="$6"
stack_service="${stack_name}_${service_name}"
backup_dir="\${HOME}/${host_name}/${stack_name}/${service_name}"

ssh "${host_name}" "mkdir --parents \${HOME}/bin"

scp "${HOME}/archilab-backup/restore-docker-db-dump.sh" "${host_name}:\${HOME}/bin/"

ssh "${host_name}" "mkdir --parents ${backup_dir}"

scp -3 "archilab-nas:${backup_dir}/${stack_service}_${backup_date}.sql" \
    "${host_name}:${backup_dir}/"

ssh "${host_name}" "\${HOME}/bin/restore-docker-db-dump.sh" "${host_name}" \
    "${stack_name}" "${service_name}" "${db_user}" "${db_name}" "${backup_date}"

ssh "${host_name}" "rm ${backup_dir}/*"