Backup Database, with Rotation

database-backup-with-rotation.sh

#!/bin/bash

if [[ -z "$1" ]]; then exit 1; fi
if [[ -z "$2" ]]; then exit 1; fi

TASK=$1

# Backup folders
BK_BASE=/path/to/backup/folder
BK_DAILY=$BK_BASE/daily
BK_WEEKLY=$BK_BASE/weekly
BK_MONTHLY=$BK_BASE/monthly
# How many backups to keep
KEEP_DAILY=7
KEEP_WEEKLY=4

DBH=<database host>
DBU=<database user>
DBP=<database password>
DBN=$2

# Backup database
if [[ $TASK == "do-daily" ]]; then
    mysqldump -h $DBH -u $DBU -p$DBP $DBN | gzip -> $BK_DAILY/$DBN-`date +'%Y%m%d%H%M%S'`.sql.gz
    exit 0
fi

# Copy the newest daily backup to weekly, and delete all but latest KEEP_DAILY daily backups
if [[ $TASK == "do-weekly" ]]; then
    cp `ls -1td $BK_DAILY/$DBN* | head -n 1` $BK_WEEKLY
    ls -1trd $BK_DAILY/$DBN* | head -n -$KEEP_DAILY | xargs -d '\n' rm -f
    exit 0
fi

# Copy the newest daily backup to monthly, and delete all but latest KEEP_WEEKLY weekly backups
if [[ $TASK == "do-monthly" ]]; then
    cp `ls -1td $BK_DAILY/$DBN* | head -n 1` $BK_MONTHLY
    ls -1trd $BK_WEEKLY/$DBN* | head -n -$KEEP_WEEKLY | xargs -d '\n' rm -f
    exit 0
fi