How to merge 2 MySQL dbs

[ProxySites.ca]

Hey Guys,

I am trying to figure out how to merge 2 different MySQL databases from 2 different topsites to one.

Is there a way this can be done?

TIA
Proxy Sites

[RedPhoenix]

If you mean 'insert all rows from a table in database A into an
indetical table in database B', then yes.

If both databases are in the same server, just do a direct 'insert A..table_X select * from
B..table_X'.

If they're in different servers, you must create a prroxy table first, and then you basically do the same.

You can generate the required SQL statements by querying sysobjects directly.