FILE_NAME="db-`date +"%Y-%m-%d-%I:%M:%S%p"`.sql.gz"
SAVE_DIR="/root/backup"
S3BUCKET="bucket"
MYSQL_USER="root"
MYSQL_PASSWORD="root"
YEAR_DIR=$(date +%Y)
MONTH_DIR=$(date +%b)
DAY_DIR=$(date +%d)

mysqldump -u ${MYSQL_USER} -p${MYSQL_PASSWORD} wp-coverager-wp-npvK9cGx | gzip > ${SAVE_DIR}/${FILE_NAME}

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

    # Upload to AWS
    aws s3 cp ${SAVE_DIR}/${FILE_NAME} s3://${S3BUCKET}/'database-backups'/${YEAR_DIR}/${MONTH_DIR}/${DAY_DIR}/${FILE_NAME}

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

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

    # Exit with no error
    echo "$(tput setaf 2)Upload to AWS succeeded$(tput sgr0)"
    exit 0
fi

# Exit with error if we reach this point
echo "$(tput setaf 1)Backup file wasn't created$(tput sgr0)"
exit 1