PDA

View Full Version : Databases

ChU v2
10-29-2007, 10:15 PM
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
10-29-2007, 10:47 PM
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
10-29-2007, 11:35 PM
imported into phpmyadmin using the sql databases after the 2 have been gzipped.
Marco van Herwaarden
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
10-30-2007, 08:34 PM
How would I go about doing that exactly?

Thanks for the help.
Marco van Herwaarden
10-31-2007, 08:18 AM
Appendix 5: ImpEx Import System (http://www.vbulletin.com/docs/html/impex)
ChU v2
11-01-2007, 03:21 AM
Thank you Marco.