23 lines
585 B
Bash
Executable File
23 lines
585 B
Bash
Executable File
#!/usr/bin/env bash
|
|
# Restore database from a backup
|
|
cd "$(dirname "$0")/.."
|
|
BACKUP_DIR="backups"
|
|
|
|
echo "Available backups:"
|
|
ls -1 "$BACKUP_DIR"
|
|
|
|
read -p "Enter filename to restore: " filename
|
|
|
|
if [ -f "$BACKUP_DIR/$filename" ]; then
|
|
echo "Restoring $filename..."
|
|
[ -f .env ] && source .env
|
|
DB_USER=${MARIADB_USER:-cms}
|
|
DB_PASS=${MARIADB_PASSWORD:-cms}
|
|
DB_NAME=${MARIADB_DATABASE:-habbo}
|
|
|
|
docker compose exec -T mariadb-turbo mariadb -u"$DB_USER" -p"$DB_PASS" "$DB_NAME" < "$BACKUP_DIR/$filename"
|
|
echo "Restore complete."
|
|
else
|
|
echo "File not found."
|
|
fi
|