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

[Karen Palen]

Ok I am using 9.10, but I don't think this changed between versions.

The MySQL Baianries are in /usr/bin, but the database info itself is in /var/lib/mysql by default!

That is exactly what bit me! The binaries can be replaced with a simple download/reinstall, but the database ... 

Three months later and I am STILL finding stuff that is missing.

I would be even worse off if I hadn't saved most of the stuff with Meerkat backups as I built it!

Karen

--- On Mon, 11/9/09, William Magee <billmagee at gmail.com> wrote:

> From: William Magee <billmagee 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, 2:55 AM
> Hi Karen,
> 
> I think Ubuntu uses /usr/bin for mysql. At least it does in
> my
> installation of 9.04.
> 
> Cheers,
> Bill
> 
> > -----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
> >
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users
>