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 <[email protected]> wrote: > From: Michael <[email protected]> > Subject: Re: [Opensim-users] MySQL backups (was RE: linking regions and > hypergrid) > To: [email protected] > 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 > [email protected] > https://lists.berlios.de/mailman/listinfo/opensim-users > _______________________________________________ Opensim-users mailing list [email protected] https://lists.berlios.de/mailman/listinfo/opensim-users
