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

[Kevin Buckley]

I'm using a batch file (modified from something I found on the net) in
Windows Scheduler to do my backup at 5am using 'mysqldump':

REM Rock's quick database backup script
REM Place this batch file into Microsoft Scheduler, set to daily
cd "c:\Program Files\MySQL\MySQL Server 5.1\bin"
mysqldump --opt -uroot -p***** opensim2 > z:\MySQLBackup\opensim2.sql
REM Now rename & datestamp the file
z:
cd "z:\MySQLBackup\"
ren opensim2.sql "%date:~6,4%-%date:~3,2%-%date:~0,2%opensim2.sql"

This avoids having to know anything about the MySQL installation.

z: is a remote 1Tb network drive on my system. opensim2 is the name of the
database.  The individual backups are named like '2009-11-09opensim2.sql'.

Using this method do I still need to backup the other stuff separately?

Kevin

-----Original Message-----
From: opensim-users-bounces at lists.berlios.de
[mailto:opensim-users-bounces at lists.berlios.de] On Behalf Of Karen Palen
Sent: 09 November 2009 08:45
To: opensim-users at lists.berlios.de
Subject: Re: [Opensim-users] linking regions and hypergrid


If you are using Linux, be sure you backup include the /var/* directory!

What bit me is that MySQL uses /var/MySql/... for the database by default
and /var/* was NOT being backed up! Unfortunately there are good reasons fo
rnot including /var/* in a backup (it is intended as transient files after
all!), but you do need to be sure that you make an exception for
/var/mysql/* !!!

I use Linux/Ubuntu, but the issue is the same for every OS, only the names
of the guilty parties will change!

You would be amazed at how much work you hav eput into that database WHEN
you have to rebuild it!


Having said that remember that sailors are divided into three groups: those
who have run aground, those who ARE aground and LIARS!

Forewarned is forearmed!

Karen

--- On Sun, 11/8/09, Kevin Buckley <kevin at buckley70.freeserve.co.uk> wrote:


>  And I do an automated back-up of
> EVERYTHING! Every day,

> I do a backupPC backup every night PLUS a complete dump of
> my MySQL database
> every night! I was bitten once with database corruption and
> do NOT intend to
> lose my work again!



      
_______________________________________________
Opensim-users mailing list
Opensim-users at lists.berlios.de
https://lists.berlios.de/mailman/listinfo/opensim-users