Tweet
merging an old forum db with a new forum db
Hi folks,
Right from the get-go I know this is going to be a tall order so bear with me.
I have an old forum database which I'm upgrading to 3.0.1 in my testvb folder so it matches my current live forums. I want to take everything from the newly upgraded old database and add it to the live database.
Every record from the old database will have higher id numbers (obviously) than the current records but should appear on the forums as normal due to the UNIX timestamps.
The old database has just over 200 members and 6500 posts with only 15 attachments, the live database has just under 100 members and 1500 posts with just over 20 attachments (at last check).
Does anybody know of a good (ie. reasonably quick) way to renumber the records (adding a value to the id number value) then insert them into the new database? I am aware it'll be complex what with linking attachments to posts, posts to threads and users, and threads to forums.
If anybody has attempted this in the past and succeeded and can point me in the right direction that would be great.
Cheers,
Robert
Right from the get-go I know this is going to be a tall order so bear with me.
I have an old forum database which I'm upgrading to 3.0.1 in my testvb folder so it matches my current live forums. I want to take everything from the newly upgraded old database and add it to the live database.
Every record from the old database will have higher id numbers (obviously) than the current records but should appear on the forums as normal due to the UNIX timestamps.
The old database has just over 200 members and 6500 posts with only 15 attachments, the live database has just under 100 members and 1500 posts with just over 20 attachments (at last check).
Does anybody know of a good (ie. reasonably quick) way to renumber the records (adding a value to the id number value) then insert them into the new database? I am aware it'll be complex what with linking attachments to posts, posts to threads and users, and threads to forums.
If anybody has attempted this in the past and succeeded and can point me in the right direction that would be great.
Cheers,
Robert
Comment