#!/bin/sh

MYSQL_USER="homestead"
MYSQL_PASSWORD="secret"
MYSQL_DATABASE="my-database"
BACKUPS_DIR="/home/vagrant/backups/"

echo '\n'
echo '******************** BEGIN ********************'

DAY_BEFORE=${BACKUPS_DIR}${MYSQL_DATABASE}_backups_`date --date="-2 days" +%Y-%m-%d`

if [ -d "$DAY_BEFORE" ]; then
	echo "Clearing Out Backups From Two Days Ago Except Noon\n"
	cd ${DAY_BEFORE}
	ls | grep -v '12-00' | xargs rm
fi

LONG_PAST=${BACKUPS_DIR}${MYSQL_DATABASE}_backups_`date --date="-14 days" +%Y-%m-%d`

if [ -d "$LONG_PAST" ]; then
	echo "Removing All Backups from 14 days ago\n"
	rm -R ${LONG_PAST}
fi

echo "Begin New Backup for $(date)\n"

DIR=${BACKUPS_DIR}${MYSQL_DATABASE}_backups_`date +%Y-%m-%d`

mkdir -p ${DIR}

FILE=${DIR}/`date +%Y-%m-%d_%H-%M`.sql.gz

mysqldump -u ${MYSQL_USER} -p"${MYSQL_PASSWORD}" ${MYSQL_DATABASE} | gzip > ${FILE}

echo "\nEnd $(date)"
echo '********************* END *********************'