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

[William Magee]

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
>