backup.sh

#!/bin/bash

# Load environment variables from .env file
if [ -f .env ]; then
  export $(cat .env | xargs)
else
  echo ".env file not found."
  exit 1
fi

# Variables
BACKUP_DIR="/opt"
DATE=$(date +%d%m%Y_%H%M%S)
BACKUP_FILE="${FACILITY_NAME}_DATA_BACKUP_${DATE}.sql"
LOCAL_DIR="$HOME/Data_Backup"

# Check Docker container status
sudo docker ps -a | grep $DB_CONTAINER > /dev/null
if [ $? -ne 0 ]; then
  echo "Docker container $DB_CONTAINER not found."
  exit 1
fi

# Create backup inside Docker container
sudo docker exec -it $DB_CONTAINER bash -c "mysqldump -u $DB_USER -p$DB_PASS $DB_NAME > $BACKUP_DIR/$BACKUP_FILE"
if [ $? -ne 0 ]; then
  echo "Failed to create backup inside Docker container."
  exit 1
fi

# Create local backup directory if it doesn't exist
if [ ! -d "$LOCAL_DIR" ]; then
  mkdir -p "$LOCAL_DIR"
  if [ $? -ne 0 ]; then
    echo "Failed to create local directory $LOCAL_DIR."
    exit 1
  fi
fi

# Identify the latest backup file with the correct naming pattern
LATEST_BACKUP=$(sudo docker exec $DB_CONTAINER ls -t $BACKUP_DIR | grep -E "^${FACILITY_NAME}_DATA_BACKUP_[0-9]{8}_[0-9]{6}\.sql$" | head -n 1)

# Check if the latest backup file was identified correctly
if [ -z "$LATEST_BACKUP" ]; then
  echo "No backup file found matching the pattern."
  exit 1
fi

# Copy the latest backup file to the local directory
sudo docker cp "$DB_CONTAINER:$BACKUP_DIR/$LATEST_BACKUP" "$LOCAL_DIR/"
if [ $? -ne 0 ]; then
  echo "Failed to copy backup file to local directory $LOCAL_DIR."
  exit 1
fi

echo "Backup completed: $LATEST_BACKUP and file copied to $LOCAL_DIR successfully."
exit 0