I've had to do this before, since mysql stores it's databases in directories:
(This is on a fedora or debian box) # /etc/init.d/mysql stop # cd /var/lib/mysql (or wherever your mysql data files are located) # cp -a database_x database_y # /etc/init.d/mysql start And voila, you have an exact copy of your database and it's pretty fast. -- -- -- Matthew Frederico /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
