#!/bin/bash
# TinyBox VPS Manual Backup Script
# Save as: /usr/local/bin/backup-system.sh

BACKUP_DIR="/home/backups"
DATE=$(date +%Y%m%d_%H%M%S)
HOSTNAME=$(hostname)

# Create backup directory
mkdir -p $BACKUP_DIR

echo "🔄 Starting TinyBox VPS backup..."

# System configuration backup
echo "📋 Backing up system configuration..."
tar -czf $BACKUP_DIR/system_config_$DATE.tar.gz \
    /etc \
    /root/.ssh \
    /usr/local/bin \
    --exclude=/etc/ssl/private 2>/dev/null

# Web files backup
if [ -d "/var/www" ]; then
    echo "🌐 Backing up web files..."
    tar -czf $BACKUP_DIR/www_files_$DATE.tar.gz /var/www 2>/dev/null
fi

# Database backup (MySQL)
if systemctl is-active --quiet mysql; then
    echo "🗄️ Backing up MySQL databases..."
    mysqldump --all-databases --routines --triggers > $BACKUP_DIR/mysql_all_$DATE.sql
    gzip $BACKUP_DIR/mysql_all_$DATE.sql
fi

# Database backup (PostgreSQL)
if systemctl is-active --quiet postgresql; then
    echo "🐘 Backing up PostgreSQL databases..."
    sudo -u postgres pg_dumpall > $BACKUP_DIR/postgresql_all_$DATE.sql
    gzip $BACKUP_DIR/postgresql_all_$DATE.sql
fi

# User home directories
echo "🏠 Backing up home directories..."
tar -czf $BACKUP_DIR/home_dirs_$DATE.tar.gz /home --exclude=/home/backups 2>/dev/null

# Create manifest file
echo "📄 Creating backup manifest..."
cat > $BACKUP_DIR/backup_manifest_$DATE.txt << EOF
TinyBox VPS Backup Manifest
===========================
Hostname: $HOSTNAME
Date: $(date)
Backup Location: $BACKUP_DIR

Files in this backup:
$(ls -la $BACKUP_DIR/*$DATE*)

System Info:
$(uname -a)
$(df -h)
$(free -h)
EOF

# Cleanup old backups (keep last 5)
echo "🧹 Cleaning up old backups..."
cd $BACKUP_DIR
ls -t backup_manifest_*.txt | tail -n +6 | while read file; do
    DATE_OLD=$(echo $file | sed 's/backup_manifest_//;s/.txt//')
    rm -f *$DATE_OLD*
done

echo "✅ Backup completed: $BACKUP_DIR"
echo "📊 Backup size: $(du -sh $BACKUP_DIR | cut -f1)"

# Make executable: chmod +x /usr/local/bin/backup-system.sh

#!/bin/bash
# Database backup script
BACKUP_DIR="/home/db_backups"
DATE=$(date +%Y%m%d_%H%M%S)
mkdir -p $BACKUP_DIR

# MySQL backup
if systemctl is-active --quiet mysql; then
    echo "Backing up MySQL..."
    mysqldump --all-databases --single-transaction --routines --triggers > $BACKUP_DIR/mysql_$DATE.sql
    gzip $BACKUP_DIR/mysql_$DATE.sql
fi

# PostgreSQL backup  
if systemctl is-active --quiet postgresql; then
    echo "Backing up PostgreSQL..."
    sudo -u postgres pg_dumpall > $BACKUP_DIR/postgresql_$DATE.sql
    gzip $BACKUP_DIR/postgresql_$DATE.sql
fi

echo "Database backup completed: $BACKUP_DIR"