script.sh

#!/bin/bash

# Load environment variables from .env file
echo "============================================================="
if [ "$NODE" == "production" ]; then
  export $(cat /app/.env | grep -v '^#' | xargs)
else
  export $(cat .env | grep -v '^#' | xargs)
fi

if [ "$NODE" == "production" ]; then
  DIR_BACKUP="/app/backups_db"
else
  DIR_BACKUP="/backups_db"
fi

# Step 0: Remove backups older
echo "Removing backups older..."
find $DIR_BACKUP -type f -name "*.sql" -exec rm -f {} \;

# Step 1: Backup MySQL database in Docker container
echo "Starting MySQL backup..."
DATE=$(date +"%Y%m%d%H%M%S")
mariadb-dump --ssl=false -h $DB_HOST -u $DB_USER -p$DB_PASS $DB_NAME > "$DIR_BACKUP/backup_${DB_NAME}_$DATE.sql"
echo "Backup $DIR_BACKUP/backup_${DB_NAME}_$DATE.sql local successfully."

# Step 2: Upload to Firebase
echo "Uploading backup to Firebase Storage..."
if [ "$NODE" == "production" ]; then
  node /app/upload.js
else
  node upload.js
fi

# Confirm upload
if [ $? -eq 0 ]; then
  echo "Backup uploaded successfully to Firebase."
  if [ -n "$SLACK_WEB_HOOK" ]; then
    node /app/notify.js
  else
    node notify.js
  fi
else
  echo "Failed to upload the backup."
fi
echo "============================================================="