full-db-backup.sh

#!/usr/bin/env bash
# Back up Script to Daily Full Backups
# Source: 
# Author: Amit

DAY=$(date +"%Y%m%d")
MONTH=$(date +"%Y%m")
YEAR=$(date +"%Y")

YDAY=$(date -d '-1 day' '+%Y%m%d')
YMONTH=$(date -d '-1 day' '+%Y%m')
YYEAR=$(date -d '-1 day' '+%Y')

DEST="/var/www/backups/db/fullbackup/$YEAR/$MONTH/$DAY"
YDEST="/var/www/backups/db/fullbackup/$YYEAR/$YMONTH/$YDAY"

mkdir -p $DEST

if [ ! -f "/var/www/backups/s3sync/db/full/$YDAY/$YDAY.tar.gz" ]; then
	
	if [ -d "$YDEST" ]; then
		tar -czf /var/www/backups/s3sync/db/full/$YDAY/$YDAY.tar.gz -C /var/www/backups/db/fullbackup/$YYEAR/$YMONTH $YDAY
		rm -rf $YDEST
	fi
else
	if [ -d "$YDEST" ]; then
		rm -rf $YDEST
		#rm -f /var/www/backups/s3sync/db/full/$YDAY/$YDAY.tar.gz
	fi
fi


mariabackup --backup --no-lock --target-dir=$DEST

#move current day as well to the sync folder
mkdir -p /var/www/backups/s3sync/db/full/$DAY

tar -czf /var/www/backups/s3sync/db/full/$DAY/$DAY.tar.gz -C /var/www/backups/db/fullbackup/$YEAR/$MONTH $DAY
#split /var/www/backups/s3sync/db/full/$DAY/$DAY.tar.gz --bytes=500m --suffix-length=4 --numeric-suffix /var/www/backups/s3sync/db/full/$DAY/$DAY.tar.gz.

#mariabackup --backup --stream=xbstream | gzip > /var/www/database_backup/$DATE.gz