Linux – Daily Weekly and Monthly DB backup with logrotate

You can schedule one or more scripts like the one below with cron.

#!/bin/bash

BULOG=/srv/backup/savelog
BULST="/etc /srv/www /var/lib/named"
EMAIL=me@example.com

today=`date +%d%m%y`
deldate=`date +%d%m%y --date '7 day ago'`
echo "Backup started: "`date`> $BULOG
echo "Backup "`date`         >>/srv/backup/ErrorLog

cd /srv/backup
rm -f backup$deldate.tar.gz

tar czf /srv/backup/backup$today.tar.gz $BULST 2>>/srv/backup/ErrorLog
if [ $? -eq 0 ];then
        echo "Backup $BULST success" >> $BULOG
else
        echo "Backup $BULST NOT processed" >> $BULOG
fi

echo "-------" >>/srv/backup/ErrorLog

echo "Backup finished: " `date` >> $BULOG

cat $BULOG | mail -s MyBacukp_$today $EMAIL

This needs just a little bit of tweaking to server your requests.

There's two reasons to do backups:

1. Disaster recovery (major hardware failure, natural disaster, etc.)
2. Oh, @!#%, I need that file back the way it was yesterday.

By definition, regular commits to SVN takes care of reason 2. If you delete or overwrite a critical file, just pull an older version back out of the repository.

That leaves reason 1. As long as you have good verified offsite copies of your repository, you should be set. Make full copies of it on a daily basis, periodically test checking out of the copied repository, and you're set.

If it were me, I'd make sure my repository used the FSFS backend (apparently it's the default since 1.2, but it wasn't when I started). That will store your repository in regular files on the filesystem, and you can back them up with rsync, svnadmin hotcopy (sample script here), or whatever other tool you want.