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 <[email protected]> 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! >> >> >> >> >> _______________________________________________ >> 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 > -- William Magee, Ph.D. XVIth Congress of the IABS, Planning Committee Chair Dharma Drum Buddhist College Jinshan, Taiwan _______________________________________________ Opensim-users mailing list [email protected] https://lists.berlios.de/mailman/listinfo/opensim-users
