Automate Full Website Backups (Files & DB)

#!/bin/bash

# Configuration Variables
BACKUP_DIR="/path/to/your/backups"
WEB_ROOT="/var/www/your_website"
DB_USER="your_db_user"
DB_PASS="your_db_password"
DB_NAME="your_database_name"
DB_TYPE="mysql" # or "postgresql"
RETENTION_DAYS=7 # Number of days to keep backups

# Create backup directory if it doesn't exist
mkdir -p "$BACKUP_DIR"

# Generate timestamp for backup files
TIMESTAMP=$(date +%Y%m%d%H%M%S)
BACKUP_PATH="$BACKUP_DIR/$TIMESTAMP"
mkdir -p "$BACKUP_PATH"

echo "Starting backup at $TIMESTAMP..."

# 1. Backup Website Files
echo "Backing up website files from $WEB_ROOT..."
tar -czf "$BACKUP_PATH/website_files.tar.gz" -C "$WEB_ROOT" .
if [ $? -eq 0 ]; then
    echo "Website files backup complete."
else
    echo "ERROR: Website files backup failed!"
fi

# 2. Backup Database
echo "Backing up database '$DB_NAME' ($DB_TYPE)..."
if [ "$DB_TYPE" == "mysql" ]; then
    mysqldump -u "$DB_USER" -p"$DB_PASS" "$DB_NAME" | gzip > "$BACKUP_PATH/database.sql.gz"
elif [ "$DB_TYPE" == "postgresql" ]; then
    PGPASSWORD="$DB_PASS" pg_dump -U "$DB_USER" "$DB_NAME" | gzip > "$BACKUP_PATH/database.sql.gz"
else
    echo "ERROR: Unsupported database type: $DB_TYPE"
fi

if [ $? -eq 0 ]; then
    echo "Database backup complete."
else
    echo "ERROR: Database backup failed!"
fi

echo "Backup stored in: $BACKUP_PATH"

# 3. Clean up old backups
echo "Cleaning up backups older than $RETENTION_DAYS days..."
find "$BACKUP_DIR" -maxdepth 1 -type d -mtime +$RETENTION_DAYS -exec rm -rf {} \;

echo "Backup process finished."