Copying database 1

[GONDA2000]

I have dedicated unix server runing my website with MySQL database. I'm new to MySql and need help.
PROBLEM
I need create 2 databases with same content but difrent names. One database already exist. How do I create and copy existing database to the new? Both db's will be on the same server.

Thank you for any help.

 

[zephan]

You can try to dump your database
Mysql dumps databases in SQL query files, you can then search/replace the 1st dbasename by the second one in the queries
Finally, execute the SQL script. Did u get it ? sorry for not giving details