08-12-2010, 12:51 PM
My guess is that a simple upgrade is not hard. However, I was thinking about merging, and I realized given the fact that most web software (phpBB included) uses MySQL without referential integrity because it's "easier" (I don't even know if MySQL enforces integrity at all) it makes merging a real pain.
It can be done through some diligent and orderly process, but basically you have to renumber the id's of all posts, users, and forums so you don't get collisions before you merge. In any decently designed DB environment, it would be easier because you could cascade all the changes.
I guess if we just pick some appropriately big number that will ensure no collision like 10000, and add it to all the ids it would work fine.
Then of course you'd have two users for anyone who has a login on both sites.
I looked at the site where the other forum is hosted. They charge the most to export the site--I guess they really don't want to lose that business.
Anyway, I know you're just doing this to get out of having a black colored site!
It can be done through some diligent and orderly process, but basically you have to renumber the id's of all posts, users, and forums so you don't get collisions before you merge. In any decently designed DB environment, it would be easier because you could cascade all the changes.
I guess if we just pick some appropriately big number that will ensure no collision like 10000, and add it to all the ids it would work fine.
Then of course you'd have two users for anyone who has a login on both sites.
I looked at the site where the other forum is hosted. They charge the most to export the site--I guess they really don't want to lose that business.
Anyway, I know you're just doing this to get out of having a black colored site!