Skip to content

Instantly share code, notes, and snippets.

@thecancerus
Last active April 25, 2019 06:51
Show Gist options
  • Save thecancerus/f1889455bb8d85097d7661e7ab281eb2 to your computer and use it in GitHub Desktop.
Save thecancerus/f1889455bb8d85097d7661e7ab281eb2 to your computer and use it in GitHub Desktop.
taking incremental backups
#!/usr/bin/env bash
# Back up Script to take Incremental Backups
# Source:
# Author: Amit
DAY=$(date +"%Y%m%d")
T=$(date +"%H%M")
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/incbackup/$YEAR/$MONTH/$DAY/$T"
YDEST="/var/www/backups/db/incbackup/$YYEAR/$YMONTH/$YDAY"
#doomsday=`date -d "2012-12-21" +%s`
today=$(date +"%Y-%m-%d")
today=$(date -d "$today 04:00" +%s)
now=$(date +"%Y-%m-%d %H:%M")
now=$(date -d "$now" +%s)
if [ $now -gt $today ]; then
BASEDIR="/var/www/backups/db/fullbackup/$YEAR/$MONTH/$DAY"
else
BASEDIR="/var/www/backups/db/fullbackup/$YYEAR/$YMONTH/$YDAY"
fi
mkdir -p $DEST
#echo $BASEDIR
#mariabackup --backup --target-dir=$DEST
mariabackup --backup --no-lock --target-dir=$DEST/ --incremental-basedir=$BASEDIR/
mkdir -p /var/www/backups/s3sync/db/inc/$DAY
tar -czf /var/www/backups/s3sync/db/inc/$DAY/$T.tar.gz -C /var/www/backups/db/incbackup/$YEAR/$MONTH/$DAY $T
#mariabackup --backup --stream=xbstream | gzip > /var/www/database_backup/$DATE.gz
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment