I use snapback.... it does the rolling restoration... works awesome.... it links the files to save space, and had a transfer log, to show how much was transfered....
Steve Sills Platnum Computers, President http://www.platnum.com [EMAIL PROTECTED] ----- Original Message ----- From: "Benjamin Arai" <[EMAIL PROTECTED]> To: <RCorbet> Cc: "Steve Sills" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, April 11, 2004 11:15 PM Subject: Re: backup > Don't use rsync. Try rdiff-backup, its much more reliable and offers > rolling restoration. > > On Sat, 2004-04-10 at 02:08, Matt W wrote: > > > Hi Steve, > > > > You might want to look at FLUSH TABLES WITH READ LOCK. That's a query > > to run from mysql, but I'm sure you can get it to work in your shell > > script (you need to maintain the MySQL connection while doing the > > backup). I don't know much about that, though. I think you just run > > UNLOCK TABLES when you're finished. > > > > > > Matt > > > > > > ----- Original Message ----- > > From: "Steve Sills" > > Sent: Tuesday, April 06, 2004 8:17 PM > > Subject: backup > > > > > > I want to use rsync to backup my db server, how do i lock all the tables > > for all the db's to read only so i cando my backup, then unlock them > > again. It needs to be done from the command line, not the mysql > > program. Anyone have any ideas? I have looked and couldn't find the > > answer i was looking before. Its running from a shell script, from my > > backup machine. Its currently setup to shut down the server, however i > > don't want to have to do this. Thanks in advance. > > > > Steve Sills > > Platnum Computers, President > > http://www.platnum.com > > [EMAIL PROTECTED] > > Benjamin Arai > Araisoft > > Email: [EMAIL PROTECTED] > Website: http://www.araisoft.com > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
