Re: Incremental backup of the barkley db

On Thursday 27 January 2005 12.35, Mugabonake Olivier wrote:
> since a few days
> and i have two large projects of 50 GB volume. I want to do incremental
> backups every day and full backups once a mounth. Is up there some
> scripts to do this without backing up all the db?
> thanks

I have the follwing bash script running every day as a cron job:
------------------
OLDREV=`cat /mnt/backup/svnrev`
NEWREV=`svn log -r head file:///var/svn/harv | egrep "r[0-9]+" | cut -d "r" -f
2 | cut -d " " -f 1`

if [ $OLDREV != $NEWREV ]
        then
                OLDREV=$(($OLDREV+1))
                svnadmin dump -r $OLDREV:$NEWREV --incremental /var/svn/harv/
> /mnt/backup/daily/svn-harv-$OLDREV-$NEWREV
                echo -n $NEWREV > /mnt/backup/svnrev
fi
---------------------

This dumps all revisions since last day.

And then I have the following as a weekly job:
-------------------------------------
NEWREV=`svn log -r head file:///var/svn/harv | egrep "r[0-9]+" | cut -d "r" -f
2 | cut -d " " -f 1`

svnadmin dump -r 0:$NEWREV /var/svn/harv/ > /mnt/backup/weekly/svn-harv-`date
+%V`-$NEWREV

echo -n $NEWREV > /mnt/backup/svnrev
----------------------------

Hope it helps.

/Michael Andreen