On Fri, 30 Aug 2002, Jeremy Tinley wrote: > Date: Fri, 30 Aug 2002 12:36:28 -0500 > From: Jeremy Tinley <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Tape backups from live slave > > 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? > > Currently, I redirect the traffic to another slave, and then shut down > this slave to backup the tables and keep replication from happening. An > hour later, it's complete.
Why not: use mysqldump to a file and then backup the file. The total time you bypass the slave should be much shorter. > > Any thoughts on my query? > (Sorry, had to throw the filter word in there somewhere...) > > > -J > > > > --------------------------------------------------------------------- > 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 > Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 --------------------------------------------------------------------- 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