On Fri, 30 Aug 2002, Jeremy Tinley wrote: > Date: Fri, 30 Aug 2002 14:02:51 -0500 > From: Jeremy Tinley <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: RE: Tape backups from live slave > > Good question, > > a) The slave does not have the free space to make a duplicate of my > data. Well you can pipe it through a compressor (eg bzip) before it hits the disk. This will slow the process down some but its still gots to be faster than waiting for the tape drive.
> > b) I have 200 tables. I don't want to have to recreate indexes for > every table if I have to restore. I'd rather spend an hour restoring > from tape and let replication catch me up. > > -J > > -----Original Message----- > From: William R. Mussatto [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 30, 2002 1:57 PM > To: Jeremy Tinley > Cc: [EMAIL PROTECTED] > Subject: Re: Tape backups from live slave > > 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 > > 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