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

[Sean Hennessee]

I use an automated tool for backup of my MySQL database on CentOS and 
RHEL Linux. You can get an opensource version of it here:
http://sourceforge.net/projects/automysqlbackup/
It has some nice features, like automating daily, weekly, and monthly 
backups, as well as having a separate "latest" folder that has the most 
recent MySQL backup handy. It runs daily as a cronjob.

Peace,
Sean

Karen Palen wrote:
> 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!
>>

-- 

Sean Hennessee
UC Irvine


... . .- -. /  .... . -. -. . ... ... . .