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]
