4 messages in com.mysql.lists.javaCopying a database?
FromSent OnAttachments
Eric Raymond14 Aug 2003 10:02 
Eric Raymond14 Aug 2003 10:28 
Paul DuBois14 Aug 2003 11:04 
Eric Raymond14 Aug 2003 11:53 
Subject:Copying a database?
From:Eric Raymond (eray@inzap.com)
Date:08/14/2003 10:02:58 AM
List:com.mysql.lists.java

Is there a way to copy a database *without* going outside of sql?

We currently do the equivalent of "mysqldump olddb | mysql newdb", but that seems ineffcicent (especially since we implment the "pipe" with via java process i/o calls).

It would be great if there was a way to do this purely inside of SQL (something like "create database newdb like olddb copydata").

Any ideas?