#!/bin/bash
# Source: https://www.webmenedzser.hu/blog/weboldalak-biztonsagi-mentese-hogyan-csinald-jol-szabaduszokent-vagy-ugynoksegkent

# Variables definitions
PROJECT_NAME=$1
DATABASE=$2
NOW=$(date +"%Y-%m-%d_%H-%M-%S")
BACKUP_PATH=/var/tmp
DB_FILENAME=$DATABASE-$NOW
HOST_BUCKET=visionsoft

# Back up the database
echo "Exporting \"$DATABASE\" database ..."
mysqldump --max_allowed_packet=1024M "$DATABASE" | gzip -9 > $BACKUP_PATH/$DB_FILENAME.sql.gz

# Upload it to bucket
echo "Uploading to Spaces in progress..."
s3cmd put $BACKUP_PATH/$DB_FILENAME.sql.gz s3://$HOST_BUCKET/$PROJECT_NAME/database/
echo "Local copy removed..."
rm $BACKUP_PATH/$DB_FILENAME.sql.gz