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 <[email protected]> wrote: > From: Kevin Buckley <[email protected]> > Subject: [Opensim-users] MySQL backups (was RE: linking regions and hypergrid) > To: [email protected] > 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: [email protected] > [mailto:[email protected]] > On Behalf Of Karen Palen > Sent: 09 November 2009 08:45 > To: [email protected] > 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 <[email protected]> > 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 > [email protected] > https://lists.berlios.de/mailman/listinfo/opensim-users > > > > > > _______________________________________________ > Opensim-users mailing list > [email protected] > https://lists.berlios.de/mailman/listinfo/opensim-users > _______________________________________________ Opensim-users mailing list [email protected] https://lists.berlios.de/mailman/listinfo/opensim-users
