[Opensim-users] MySQL backups (was RE: linking regions and hypergrid)

[Karen Palen]

About the only thing I can think of to improve would be to remove the old files more than XXX days old!

Even a 300Mb database on modern 1Tb HDDs can get pretty hefty after a month of nightly backups!

Karen

--- On Mon, 11/9/09, Michael <mikeeab at gmail.com> wrote:

> From: Michael <mikeeab at gmail.com>
> Subject: Re: [Opensim-users] MySQL backups (was RE: linking regions and hypergrid)
> To: opensim-users at lists.berlios.de
> Date: Monday, November 9, 2009, 1:40 PM
> 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/shTIMESTAMP=`date
> +%m%d%Y-%H%M%S`mysqldump -u username -password
> databasename | gzip >
> /path/to/backupdir/dbname_$TIMESTAMP.sql.gz
> 
> 
> Marcus Llewellyn
> 
> -----Inline Attachment Follows-----
> 
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users
>