Files
SS/scripts/db-restore.sh

30 lines
663 B
Bash
Executable File

#!/usr/bin/env sh
set -eu
if [ "${CONFIRM_RESTORE:-}" != "yes" ]; then
printf 'Refusing to restore without CONFIRM_RESTORE=yes\n' >&2
exit 1
fi
if [ "${BACKUP_FILE:-}" = "" ]; then
printf 'BACKUP_FILE is required\n' >&2
exit 1
fi
if [ ! -f "$BACKUP_FILE" ]; then
printf 'Backup file not found: %s\n' "$BACKUP_FILE" >&2
exit 1
fi
CONTAINER="${DB_CONTAINER:-ss-db-1}"
DATABASE="${DB_NAME:-smm}"
USER="${DB_USER:-smm}"
PASSWORD="${DB_PASSWORD:-smm_password}"
docker exec -i "$CONTAINER" mariadb \
--user="$USER" \
--password="$PASSWORD" \
"$DATABASE" < "$BACKUP_FILE"
printf 'Restored %s into %s/%s\n' "$BACKUP_FILE" "$CONTAINER" "$DATABASE"