You can't quite copy a database consisting of multiple tables with a single query, but you can do it with a single shell command. Look here, under the heading "Using mysqldump to copy databases", toward the bottom of the page.
This post was edited on 05-02-2006 at 06:38 PM by Adeptus.
