If you want to move the database atomically, a RENAME TABLE statement may have multiple clauses.
RENAME TABLE olddb.foo to newdb.foo, olddb.bar to newdb.bar; Here, I hot-swap a new lookup table 'active.geo' into a live system confident that, at any given point, some version of this table always exists: RENAME TABLE active.geo to archive.geo, standby.geo to active geo; - michael dykman On Fri, Dec 11, 2009 at 8:58 AM, Johan De Meersman <vegiv...@tuxera.be> wrote: > On Fri, Dec 11, 2009 at 1:56 PM, Ken D'Ambrosio <k...@jots.org> wrote: > >> > rename table oldschema.table to newschema.table; >> >> Just to be 100% clear -- I assume you have to first create the destination >> database, and then do this for all the tables in the source database? >> > > Yep. Easily scriptable, though :-) > -- - michael dykman - mdyk...@gmail.com "May you live every day of your life." Jonathan Swift Larry's First Law of Language Redesign: Everyone wants the colon. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org