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/
