Copying a MySQL database FAST

Dave Smith dave at
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 mailing list