News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

converting 2 boards to rc1 and merging them...

Started by ChaosEnergy, December 06, 2005, 03:12:47 AM

Previous topic - Next topic

ChaosEnergy

hi

i need to convert to smf boards (1.0 and 1.05) to 1.1rc1 AND migrate them together

every old modification from modules must not been converted, imported

so the best way would be to have a clean 1.1 and then migrate users, messages and pm...from both boards...

but how to migrate this...

Chaos

€ btw the inplace upgrade to 1.1rc1 killed my utf8 settings and all german umlauts...
€€ ok..switched back all tables to utf8 and fixed in forum the html tags to set encoding back to utf8
Chaos Empire ®

Elmacik

To merge two forums, just upgrade both them to a same version.
Then, backup the spesific tables like;
members
messages
topics
boards

etc...
Then restore these backups in one forum.
Home of Elmacik

ChaosEnergy

hmm

but both forums have same message id, user id and so on..but different content
userid10 maybe joe in one forum and black in the other one..
i assume this will break everything...
Chaos Empire ®

Elmacik

Hmm... Yes, you are right, I didnt think about it.
Then maybe you can wait the team to prepare a merging script as they have been working on it since a while :)
Home of Elmacik

ChaosEnergy

hopefully they already have a beta ...

so..i just search more in rc1..missing my avatar settings..
Chaos Empire ®

Fizzy

I don't think just restoring would work as the tables would defnitely clash ID's.
As a thought, it might be possible to renumber certain elements, like thread ID's, message ID's etc, -  perhaps prefix the ID's with a set figure that would take them outof the other forums ID range ?
"Reality is merely an illusion, albeit a very persistent one." - A.E.


ChaosEnergy

This could be funny with~150k entires and 6k members...
Chaos Empire ®

Fizzy

Theoretically it should be possible to run a MySQL query to do the work for you where the logic would run something along the lines of

On Forum B
Update the Member_ID with Member_ID + 6000
Update Message_ID with Message_ID + 150k
Update Topic_ID with Topic_ID + how ever many threads there are on A
and so on.

Does that make any sense?
Not a quick task, but it could work.

To test it I would take a backup of the smaller forum database, copy it over to a test forum and database, then try running the updates and see of the end product would match what you need. Then take a backup of the tables from the larger forum and try importing them in to the test database and see what errors you get.

When I get home from work I'll have an experiment on my test forums and see what results I get and I'll let you know (unless someone can come up with a better solution in the meantime) :)
"Reality is merely an illusion, albeit a very persistent one." - A.E.


ChaosEnergy

i tried something, but didnt get this work
also what will happen, if low value increases and ??overwrites upper entries?
Chaos Empire ®

Fizzy

Hi Chaos,

The table builds incrementally so the when the forum reaches the numbers already used the worst that would happen is that a new post wouldn't appear - in which case run "fix and repair" and SMF would resolve the issue in a flash.

Having tested this, it won't overwrite :)
"Reality is merely an illusion, albeit a very persistent one." - A.E.


ChaosEnergy

thanks

i will retry this at the weekend...

and hopefuly find my issue...
Chaos Empire ®

Advertisement: