Simple MySQL problem
 

I want to copy the entire contents of a database on the same server, using the same host, user etc to a new database with a different name. Is there an easier way to do it rather than backing it up and restoring it with a new name?

do you have root to the box? because you should just be able to just copy the db files into the directory of mysql under the new DB name! That should be it.

jDoG

c:\winnt\system32\msql\ copy those.. duno about linux :thumbsup

Now that's almost too obvious :) I'll give it a try and if it works thanks.

Hi Tipsy :)

Assuming your using unux or similiar try this:

mysqldump -u DBUSER DBNAME -p > dbdump.sql


then run your db client and type >

create database NEWDBNAME;

exit the client then do this

mysql -u DBUSER NEWDBNAME -p < dbdump.sql

(of course replacing the italics with your db details)

Hope that helps

Thanks blazin - only way I know how to do it. Just wodering if there was a quicker/easier way.

Pretty quick and easy.. :)

No problem.

I always use this method myself....
I think there is a simpler way but without my manual I'm clueless :)

Pure genius Vending Machine :)

I'm taking notes..........