how To Merge 2 Databases into 1

[webgroup]

Hi, I want to know how to acomplish this, I have 2 databases, from separates websites.

Both use different table prefixes.

I want to merge both databases into 1

So the new merged DB will end with tables like:

prefix1_forums

prefix2_forums

prefix1_users

prefix2_users

etc,etc,etc

Thanks

[Dismounted]

What is the goal you have in mind by doing this?

[webgroup]

I need to merge the 2 DB's into 1 because I want to implement a feature between the 2 websites that needs the 2 forums to use the same DB but different prefixes.

Whn the 2 DB' are merged into 1, I will share some tables between the 2 websites.

--------------- Added [DATE]1245844396[/DATE] at [TIME]1245844396[/TIME] ---------------

I tried to acomplish my goal first using IMPEX, all was good except that the posts in all threads are showing wrong users.
The posts have incorrect userid assigned.
Attachments and all are correct, just that thing with userid in the posts.

Is there any way I can just copy the threads and posts table from prefix1_table to prefix2_table inside the dame DB??
Because right now I have 1 DB with 2 forums in it, using different prefixes, so any way to just drop the data in prefix2_table and get the data from prefix1_table will help acomplish my goal.

--------------- Added [DATE]1245846395[/DATE] at [TIME]1245846395[/TIME] ---------------

I have an idea, how can I duplicate tables in the DB, and make the duplicate have a different prefix than the original?