Lonnie Olson wrote:
Script the creation of the new database and tables, but use an INSERT ... SELECT statement to copy the data. This reduces the number of queries mysql has to run, and keeps the data from having to pass all the way out to a unix pipe. http://dev.mysql.com/doc/refman/5.0/en/insert-select.html
Can you do this across databases? I don't think you can. --Dave /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
