Copying a MySQL database FAST

[Dave Smith]

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