transfering data from db to another db

[itaym02]

Greetings.

MySql v4.1

I need to insert data copied from one table into another table.
Each table sits in a diffrent db, but both on the same server.

Is there a possibility to do the copy only with SQL, or do I need to use PHP to store the data from one db, open connection to the new db and insert the data?

Thanks

[edcellgavin]

i believe you can do that with
create table DB2.TableName SELECT * FROM DB1.TableName;
WHERE DB1 is the source database and DB2 is the destination...

[cswales]

Hi
I was looking for the same thing and come across this thread:

http://www.phpbuilder.com/board/showthread.php?threadid=10248303

Hope it helps

[itaym02]

thanks you two

I M