Copying a MySQL database FAST
dave at thesmithfam.org
Wed Aug 6 09:57:57 MDT 2008
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.
Can you do this across databases? I don't think you can.
More information about the PLUG