From: Scott Wiersdorf
Date: November 21 2000 7:06pm
Subject: Re: clobbering live tables
List-Archive: http://lists.mysql.com/internals/138
Message-Id: <20001121120623.A62651@motorcities.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

On Tue, Nov 21, 2000 at 01:53:22PM -0500, Thimble Smith wrote:
> On Tue, Nov 21, 2000 at 11:43:04AM -0700, Scott Wiersdorf wrote:
> > 
> > What would be the best way to accomplish this? I was thinking of
> > creating a remote directory, putting the updated tables in that,
> > renaming the directory to clobber the old one and flushing the tables
> > via mysqladmin.
> > 
> 
> This should work.  Also, you might consider using the new RENAME
> TABLE syntax to atomically swap tables.
> 
> Tim
> 
> P.S.  This list hasn't gotten much traffic, so its subject matter
> is still kind of vague.  But I think this message falls outside of
> it, and probably belongs on mysql@stripped.

I'm actually thinking about making this part of the functionality of
mysqlhotcopy (if it's not too complex or messy), so I think it's
relevant. Sorry for the confusion.

Scott

-- 
Scott Wiersdorf
scott@stripped
http://www.ipartner.net/