#!/bin/bash

###############################################################################
# Step 3: Backup Ninanolte WordPress
# Run this on: OLD server
###############################################################################

set -e

echo "=========================================="
echo "Step 3: Backing up Ninanolte WordPress"
echo "=========================================="
echo ""

# Check if running as root
if [ "$EUID" -ne 0 ]; then 
    echo "ERROR: Please run as root (use sudo)"
    exit 1
fi

# Create date stamp
DATE=$(date +%Y%m%d)
WORDPRESS_DIR="/var/www/html/ninanolte/wordpress"
DATABASE_NAME="nina"
BACKUP_DIR="/backup/applications"

echo "WordPress Directory: $WORDPRESS_DIR"
echo "Database: $DATABASE_NAME"
echo "Backup Date: $DATE"
echo ""

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

# Backup WordPress files
echo "Backing up WordPress files..."
tar -czf "$BACKUP_DIR/ninanolte-${DATE}.tar.gz" -C /var/www/html ninanolte/
if [ $? -eq 0 ]; then
    echo "✓ Files backed up to: $BACKUP_DIR/ninanolte-${DATE}.tar.gz"
    ls -lh "$BACKUP_DIR/ninanolte-${DATE}.tar.gz"
else
    echo "✗ ERROR: File backup failed"
    exit 1
fi

echo ""

# Backup database
echo "Backing up database..."
mysqldump -u root -p "$DATABASE_NAME" > /backup/databases/nina-${DATE}.sql
if [ $? -eq 0 ]; then
    echo "✓ Database backed up to: /backup/databases/nina-${DATE}.sql"
    ls -lh "/backup/databases/nina-${DATE}.sql"
else
    echo "✗ ERROR: Database backup failed"
    exit 1
fi

echo ""
echo "=========================================="
echo "Step 3 Complete!"
echo "=========================================="
echo ""
echo "Backups created:"
echo "  Files:    $BACKUP_DIR/ninanolte-${DATE}.tar.gz"
echo "  Database: /backup/databases/nina-${DATE}.sql"
echo ""
echo "Next: Step 4 - Copy files to NEW server"
echo "      Run: rsync -avz $BACKUP_DIR/ninanolte-${DATE}.tar.gz root@vps2.scala4.com:/backup/applications/"
echo "      Run: rsync -avz /backup/databases/nina-${DATE}.sql root@vps2.scala4.com:/backup/databases/"