The Arcive of vBulletin Modifications Site.

Databases · **Released**: 10-29-2007

How exactly do you merge two databases? I uploaded one and uploaded the other and the first one gets overwritten it seems, but the tables are still there. But the forum has not changed.

Eikinskjaldi · #2 10-29-2007, 10:47 PM

Quote:

Originally Posted by ChU v2

How exactly do you merge two databases? I uploaded one and uploaded the other and the first one gets overwritten it seems, but the tables are still there. But the forum has not changed.

You are going to have to give us a bit more information about what you want to do, and how you have been going about it. what does "uploaded" mean? import from mysqldump? import from mysqlhotcopy? a custom merge script?

ChU v2 · #3 10-29-2007, 11:35 PM

imported into phpmyadmin using the sql databases after the 2 have been gzipped.

Marco van Herwaarden · #4 10-30-2007, 05:49 AM

If you restore a second backup into the same database, then yes it will overwrite the first one.

If you want to merge them, you will need to restore them into 2 seperate databases and use ImpEx to merge them.

ChU v2 · #5 10-30-2007, 08:34 PM

How would I go about doing that exactly?

Thanks for the help.

Marco van Herwaarden · #6 10-31-2007, 08:18 AM

Appendix 5: ImpEx Import System

ChU v2 · #7 11-01-2007, 03:21 AM

Thank you Marco.