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
