I did get soimething working mysql command setup to lock tables with read lock command.. works very well.
Steve Sills Platnum Computers, President http://www.platnum.com [EMAIL PROTECTED] ----- Original Message ----- From: "Carsten R. Dreesbach" <[EMAIL PROTECTED]> To: <RCorbet> Cc: "Steve Sills" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, April 11, 2004 11:30 PM Subject: Re[2]: backup > Hi Matt, > > if Steve can accept the limitations, mysqlhotcopy might work for him: > > http://dev.mysql.com/doc/mysql/en/mysqlhotcopy.html > > If not, mysqldump with --add-locks could do it fairly easily, I should > think... > > http://dev.mysql.com/doc/mysql/en/mysqldump.html > > Saturday, April 10, 2004, 5:08:43 AM, you wrote: > > MW> Hi Steve, > > MW> You might want to look at FLUSH TABLES WITH READ LOCK. That's a query > MW> to run from mysql, but I'm sure you can get it to work in your shell > MW> script (you need to maintain the MySQL connection while doing the > MW> backup). I don't know much about that, though. I think you just run > MW> UNLOCK TABLES when you're finished. > > > MW> Matt > > > MW> ----- Original Message ----- > MW> From: "Steve Sills" > MW> Sent: Tuesday, April 06, 2004 8:17 PM > MW> Subject: backup > > > MW> I want to use rsync to backup my db server, how do i lock all the tables > MW> for all the db's to read only so i cando my backup, then unlock them > MW> again. It needs to be done from the command line, not the mysql > MW> program. Anyone have any ideas? I have looked and couldn't find the > MW> answer i was looking before. Its running from a shell script, from my > MW> backup machine. Its currently setup to shut down the server, however i > MW> don't want to have to do this. Thanks in advance. > > MW> Steve Sills > MW> Platnum Computers, President > MW> http://www.platnum.com > MW> [EMAIL PROTECTED] > > -- > Best regards, > > Carsten R. Dreesbach mailto:[EMAIL PROTECTED] > Senior Consultant > Systar, Inc. > 8000 Westpark Dr > Suite 450 > McLean, VA 22102 > USA > Tel: (703) 556-8436 > Fax: (703) 556-8430 > Cel: (571) 213-7904 > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
