#!/bin/bash

# Variables
DATE=$(date +'%Y-%m-%d_%H-%M')
WEB_DIR="/var/www/intranet.kauko.lt"
BACKUP_DIR="/backups"
DB_USER="web21"
DB_PASS="0r0MR/FMt/3i4oBr"
DB_NAME="web21"

# Ensure backup directory exists
mkdir -p $BACKUP_DIR

# Backup website files
tar -czf $BACKUP_DIR/intranet_$DATE.tar.gz $WEB_DIR

# Backup database
mysqldump -u $DB_USER -p$DB_PASS $DB_NAME > $BACKUP_DIR/db_$DATE.sql

# Optional: Compress the DB backup
gzip $BACKUP_DIR/db_$DATE.sql

# Optional: Remove backups older than 7 days
find $BACKUP_DIR -type f -mtime +7 -delete