Re: database backup

On Sun, 2002-07-07 at 12:39, Josh Jore wrote:
> Oh heck yeah. So here's a script for you (I wrote it mostly in the mail
> client so you have to do your own testing). Now schedule that in cron via
> a line like:
Thanks Josh.

Inspiring myself from that I split the task into three cron jobs and am
using mutt rather than perl.

#!/bin/sh

SENDTO=tony@animaproductions.com
SUBJECT="Base de données - sauvegarde"
ATTFILE=f3c.out.bz2
TXTFILE="daily backup of your database"

# bzip it and mail it
cd /my/directory/path
bzip2 -9 f3c.out
mutt -a $ATTFILE -s "$SUBJECT" $SENDTO < $TXTFILE

I dump the database to f3c.out every day just after the end of the
working day, I mail it later and then I delete the dump the next day
before dumping again. This way I can get the dump file myself if I need
to by scp (I really don't need a copy myself).

The versioning of the database backup and getting it on a CD from time
to time is left to the client.

http://www3.primushost.com/~kylet/unix-att.html

Has all sorts of scripts for attaching stuff to e-mail

Thanks again

Cheers

Tony
--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html