How To Copy A Mysql Db?

[Nessuno]

Hi all.

I need to copy one mysql db to another (myname_db1 must be filly copied to myname_db2).

I tried to export the db1 to a .sql file, but it is too large (7mb).

When i go to the SQL section of the db2, and i try to upload that file, i got error.

I tried also to split that file in many tables, but i've got a big table of 5mb.

Is there any method to copy a database to another (not renaming the 1st, but COPYING!)?

Thank's in advance

Stefano

[TCH-Andy]

Hi,

 

I would normally say you can copy it a table at a time, but as you say you have tried this and a 5mb table is likely to give problems.

 

If you take a backup of your database, and save it in your root directory, then open a support ticket, telling us exactly where the file is, and which database name you want it copying it into. We will do it for you.