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 <[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! >> -- Sean Hennessee UC Irvine ... . .- -. / .... . -. -. . ... ... . . _______________________________________________ Opensim-users mailing list [email protected] https://lists.berlios.de/mailman/listinfo/opensim-users
