I also use a shell script under linux, scheduled as a cron job. You can just
copy the DB files, of course, but you are also copying all the cruft that
way too. If one needs to restore data, may as well also wind up with a
squeaky clean DB as well. :) Here's the simple version of the script I use,
which also gzips the SQL file. Edit it to suit.

#!/bin/sh
TIMESTAMP=`date +%m%d%Y-%H%M%S`
mysqldump -u username -password databasename | gzip >
/path/to/backupdir/dbname_$TIMESTAMP.sql.gz


Marcus Llewellyn
_______________________________________________
Opensim-users mailing list
[email protected]
https://lists.berlios.de/mailman/listinfo/opensim-users

Reply via email to