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