Copying a MySQL database FAST

Dave Smith 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.
> 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



More information about the PLUG mailing list