At 17:05 -0700 8/30/02, Jeremy Zawodny wrote: >On Fri, Aug 30, 2002 at 12:36:28PM -0500, Jeremy Tinley wrote: >> Howdy, >> >> Before I run off and try it, can anyone offer up any problems with >> doing a LOCK TABLES, FLUSH TABLES and then use tar to backup my 16GB >> of DB tables from a slave to a tape? > >That should work. I assume you're going to use "FLUSH TABLES WITH >READ LOCK" to do it?
But note that this will have no effect on InnoDB tables, because the InnoDB handler isn't affected by that statement. > >Just make sure the session doesn't timeout--MySQL will release the >lock when it disconnects. > >Jeremy >-- >Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! ><[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > >MySQL 3.23.51: up 24 days, processed 512,136,338 queries (240/sec. avg) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php