Copying a MySQL database FAST

[Dave Smith]

Jeff Schroeder wrote:
> Dave asked:
>
>   
>> I need to copy a MySQL database fast.
>>     
>
> If the servers (source and destination) are on the same LAN, you might 
> consider using rsync.

I'm actually copying the contents of one database to another on the 
*same* MySQL server, so rsync is not an option. Doubly so because the 
tables are all InnoDB so the two DB's share data in a common directory.

--Dave