#!/bin/sh

TSTAMP=$(date +"%d-%b-%Y-%H-%M-%S")

FILE_NAME="asterisk-$TSTAMP.sql.gz"
SAVE_DIR="/var/www/html"
S3BUCKET="aiyappan-system-backup"

# Get MYSQL_USER and MYSQL_PASSWORD
#source /home/centos/backup/.env

MYSQL_USER="admin"
MYSQL_PASSWORD="Pulse@123"
MYSQL_DB="master"

sudo mysqldump -u ${MYSQL_USER} -p${MYSQL_PASSWORD} master | gzip > ${SAVE_DIR}/${FILE_NAME}

if [ -e ${SAVE_DIR}/${FILE_NAME} ]; then

    # Upload to AWS
   sudo aws s3 cp ${SAVE_DIR}/${FILE_NAME} s3://${S3BUCKET}/${FILE_NAME}

    # Test result of last command run
    if [ "$?" -ne "0" ]; then
        echo "Upload to AWS failed"
        exit 1
    fi

    # If success, remove backup file
    rm ${SAVE_DIR}/${FILE_NAME}

    # Exit with no error
    exit 0
fi

# Exit with error if we reach this point
echo "Backup file not created"
exit 1