#!/bin/bash

# Konfiguration
MYSQL_USER="root"
MYSQL_PASSWORD="maggan79"
BACKUP_ROOT="/webbserver/sqlbackup"

# Datum- och tidsstämplar
DATE_DIR=$(date +"%F")             # Ex: 2025-05-08
TIME_DIR=$(date +"%H.%M")           # Ex: 08.00

# Fullständig sökväg till backupkatalog
BACKUP_DIR="$BACKUP_ROOT/$DATE_DIR/$TIME_DIR"

# Skapa backupkatalog
mkdir -p "$BACKUP_DIR"

# Dumpa databaser (förutom systemdatabaser)
databases=$(mysql -u$MYSQL_USER -p$MYSQL_PASSWORD -e "SHOW DATABASES;" | grep -Ev "(Database|information_schema|performance_schema|phpmyadmin|mysql)")
for db in $databases; do
    mysqldump -u$MYSQL_USER -p$MYSQL_PASSWORD --databases "$db" > "$BACKUP_DIR/$db.sql"
done

# Kontrollera om backupen lyckades
if [ $? -eq 0 ]; then
    curl -d "SQL-backup lyckades: $DATE_DIR $TIME_DIR" https://ntfy.engfeldt.nu/sqlbackup
else
    curl -d "SQL-backup misslyckades: $DATE_DIR $TIME_DIR" https://ntfy.engfeldt.nu/sqlbackup
fi

# Ta bort äldre än 30 dagar (rensa dagsmappar)
find "$BACKUP_ROOT" -mindepth 1 -maxdepth 1 -type d -mtime +30 -exec rm -rf {} \;