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

[Karen Palen]

The database is critical enough that I do both - NOW!

I use MySQL Administrator which includes a simple database backup. It also drives some database checking and repair tools that are worthwhile.

I don't have a lot of experience with MySQL, but I have had enough experience with databases in the past to know that they get to be the "family jewels" of your entire project!

Karen

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

> From: Kevin Buckley <kevin at buckley70.freeserve.co.uk>
> Subject: [Opensim-users] MySQL backups (was RE: linking regions and hypergrid)
> To: opensim-users at lists.berlios.de
> Date: Monday, November 9, 2009, 2:05 AM
> 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
> 
> 
> 
> 
> 
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users
>