List:Internals« Previous MessageNext Message »
From:Thimble Smith Date:November 21 2000 6:53pm
Subject:Re: clobbering live tables
View as plain text  
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.

-- 
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Tim Smith <tim@stripped>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Development Team
/_/  /_/\_, /___/\___\_\___/   Boone, NC  USA
       <___/   www.mysql.com
Thread
clobbering live tablesScott Wiersdorf21 Nov
  • Re: clobbering live tablesThimble Smith21 Nov
    • Re: clobbering live tablesScott Wiersdorf21 Nov