| Server IP : 202.61.199.114 / Your IP : 216.73.217.139 Web Server : nginx/1.22.1 System : Linux de.arni-solutions.de 6.1.0-49-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.174-1 (2026-05-26) x86_64 User : web20 ( 1018) PHP Version : 8.4.23 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /var/www/seaside2.pacim.de/web/scripts/ |
Upload File : |
#!/usr/bin/env bash
# Erstellt einen MySQL-Dump der pacim_saas-Datenbank.
# Optional zusätzlich ein tar.gz von storage/ und public/uploads/.
#
# Usage:
# bash scripts/backup.sh # nur DB
# bash scripts/backup.sh --with-storage # DB + Dateien
set -e
PROJECT_DIR="$(cd "$(dirname "$0")/.." && pwd)"
BACKUP_DIR="$PROJECT_DIR/backups"
TS="$(date +%Y-%m-%d-%H%M)"
DB_FILE="$BACKUP_DIR/pacim-saas-$TS.sql"
mkdir -p "$BACKUP_DIR"
echo "PaCIM Backup -> $DB_FILE"
mysqldump -h localhost -u root -proot --single-transaction --quick --routines --triggers pacim_saas > "$DB_FILE"
echo " Datenbank-Dump fertig ($(du -h "$DB_FILE" | cut -f1))."
if [ "${1:-}" = "--with-storage" ]; then
FILES="$BACKUP_DIR/pacim-saas-$TS-storage.tar.gz"
tar czf "$FILES" -C "$PROJECT_DIR" storage public/uploads 2>/dev/null || true
echo " Dateien-Archiv fertig: $FILES ($(du -h "$FILES" | cut -f1))."
fi
echo "Backup abgeschlossen."