Merging two databases.

[Jerlene]

I have two databases. See screenshot below for better explanation.

I want database one to be merged into database two and have database two be the main database with all information in it so I can get rid of database one.

How do I go about doing this?

 

[monaco]

export one of them and exclude any autogenerated/incremented identity fields. Then just import it into the other one. They both appear to be phpbb tables, so the schema should be identical, if not very similar.

 

[Peter]

if they are both phpbb tables it is not going to be that easy. The auto increment fields that you mention are used to distinguish who posted what for example and who pm's are who's.

If you simply merge them ignoring the auto increment then the members on the original database will suddenly be credited for more posts than they posted and will have m's not intended for them.

Another potential problem is if 1 database has extra fields etc (maybe for mods or for some other reason).