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

[William Magee]

Thanks Karen, you are right about /var/lib/mysql. This could have been
a crucial error on my part!

I use a bash script for backup:

bkupname=databasename_bkup_$(date +"%a_%b_%d_%Y_%H_%M_%S").mysql_bkup
mysqldump -u username -p databasename > $bkupname

On Tue, Nov 10, 2009 at 1:43 AM, Karen Palen <karen_palen at yahoo.com> 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!
>>
>>
>>
>>
>> _______________________________________________
>> 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
>



-- 
William Magee, Ph.D.
XVIth Congress of the IABS, Planning Committee Chair
Dharma Drum Buddhist College
Jinshan, Taiwan