List:Internals« Previous MessageNext Message »
From:Scott Wiersdorf Date:November 21 2000 7:06pm
Subject:Re: clobbering live tables
View as plain text  
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/
Thread
clobbering live tablesScott Wiersdorf21 Nov
  • Re: clobbering live tablesThimble Smith21 Nov
    • Re: clobbering live tablesScott Wiersdorf21 Nov