#!/bin/bash # Configuration DB_USER="obinna" DB_PASS="nasdaq22" DB_NAME="boaz" BACKUP_DIR="/home/obinna/backup/boaz" REMOTE_BACKUP_DIR="fiveninesbackup/boaz" # Create backup filename with timestamp TIMESTAMP=$(date +"%Y%m%d_%H%M%S") BACKUP_FILE="$BACKUP_DIR/$DB_NAME-$TIMESTAMP.sql.gz" # Perform MySQL dump and compress mysqldump -u "$DB_USER" -p"$DB_PASS" "$DB_NAME" | gzip > "$BACKUP_FILE" # Upload to cloud storage (example using AWS CLI for S3) aws s3 cp "$BACKUP_FILE" "s3://$REMOTE_BACKUP_DIR/" # Rotate local backups (keep last 7 days) find "$BACKUP_DIR" -type f -mtime +7 -name "*.sql.gz" -delete # Rotate remote backups (example using AWS CLI for S3) aws s3 ls "s3://$REMOTE_BACKUP_DIR/" | sort | head -n -7 | awk '{print $4}' | xargs -I {} aws s3 rm "s3://$REMOTE_BACKUP_DIR/{}"