#!/bin/bash

sudo rm project-backups/mariadb/*.* project-backups/*.*

BACKUP_DIR="project-backups"
DATE=$(date +%Y-%m-%d_%H-%M)
BACKUP_FILE="$BACKUP_DIR/apache2_full_$DATE.tar.gz"

mkdir -p $BACKUP_DIR

echo "Stoppe Apache2 für konsistentes Backup..."
sudo systemctl stop apache2

echo "Erstelle Backup..."
tar -czpf $BACKUP_FILE \
  /etc/apache2/ \
  /etc/php/ \
  /etc/letsencrypt/ 2>/dev/null \
  /etc/ssl/private/ 2>/dev/null

echo "Starte Apache2 wieder..."
sudo systemctl start apache2


echo "backup public..."
BACKUP_FILE="$BACKUP_DIR/public_full_$DATE.tar.gz"
tar -czpf $BACKUP_FILE /var/www/html/www.kunstmaler.online/public 
echo "Fertig: $BACKUP_FILE"

echo "backup public-dev..."
BACKUP_FILE="$BACKUP_DIR/public_dev_full_$DATE.tar.gz"
tar -czpf $BACKUP_FILE /var/www/html/www.kunstmaler.online/public-dev
echo "Fertig: $BACKUP_FILE"

echo "backup public-test..."
BACKUP_FILE="$BACKUP_DIR/public_test_full_$DATE.tar.gz"
tar -czpf $BACKUP_FILE /var/www/html/www.kunstmaler.online/public-test
echo "Fertig: $BACKUP_FILE"

echo "backup public-play..."
BACKUP_FILE="$BACKUP_DIR/public_play_full_$DATE.tar.gz"
tar -czpf $BACKUP_FILE /var/www/html/www.kunstmaler.online/public-play
echo "Fertig: $BACKUP_FILE"

echo "backup classes..."
BACKUP_FILE="$BACKUP_DIR/classes_full_$DATE.tar.gz"  
tar -czpf $BACKUP_FILE /var/www/html/www.kunstmaler.online/classes
echo "Fertig: $BACKUP_FILE"


echo "Erstelle Datenbank Backup..."
DB_USER="root"
DB_PASS="C16552199z"

BACKUP_DIR="/var/www/html/www.kunstmaler.online/project-backups/mariadb"
mkdir -p $BACKUP_DIR
#mariadb-dump -u "$DB_USER" -p"$DB_PASS" --all-databases | gzip > $BACKUP_DIR/backup_${DATE}.sql.gz
mariadb-dump -u "$DB_USER" -p"$DB_PASS" --all-databases > $BACKUP_DIR/backup_all_db_${DATE}.sql
mariadb-dump -u "$DB_USER" -p"$DB_PASS" kleinanzeigen > $BACKUP_DIR/backup_kleinanzeigen_${DATE}.sql

echo "Backup fertig: $BACKUP_DIR/backup_all_db_${DATE}.sql"
echo "Backup fertig: $BACKUP_DIR/backup_kleinanzeigen_${DATE}.sql"

mariadb-dump -u "$DB_USER" -p"$DB_PASS" kleinanzeigen translations > $BACKUP_DIR/translations_${DATE}.sql
mariadb-dump -u "$DB_USER" -p"$DB_PASS" kleinanzeigen translation_keys > $BACKUP_DIR/translation_keys_${DATE}.sql

echo "Backup fertig: $BACKUP_DIR/translations_${DATE}.sql"
echo "Backup fertig: $BACKUP_DIR/translation_keys_${DATE}.sql"

BACKUP_DIR="project-backups"
echo "Erstelle Inkrement Backup /var/www/html/www.kunstmaler.online/public*/ ..."
#sudo tar --create --gzip --file=backup-full.tar.gz --listed-incremental=/var/backups/backup.snar /var/www/html/www.kunstmaler.online/public*/
sudo tar --create --gzip --file=$BACKUP_DIR/backup-inc-$DATE.tar.gz --listed-incremental=/var/backups/backup.snar /var/www/html/www.kunstmaler.online/public*/

echo "Erstelle Inkrement Backup /var/www/html/www.kunstmaler.online/uploads/ ..."
#tar --create --gzip --file=backup_uploads-full.tar.gz --listed-incremental=/var/backups/backup_uploads.snar /var/www/html/www.kunstmaler.online/uploads/
sudo tar --create --gzip --file=$BACKUP_DIR/backup_uploads-inc-$DATE.tar.gz --listed-incremental=/var/backups/backup_uploads.snar /var/www/html/www.kunstmaler.online/uploads/

sudo cp project-backups/mariadb/*.* /mnt/fritzbox/WD-Elements1042-01/km
sudo cp project-backups/*.* /mnt/fritzbox/WD-Elements1042-01/km