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
