Database migration question.

[discore]

I need to take all users, posts, and forums from one board to another. Both are running 2.2.8 so this shouldn't be too painful. I'm just going to post my plan.. I guess I'm asking if anyone sees any obvious flaws with this :)

1: Dump these tables: forum, poll, pollvote, post, privatemessage, user, and userfield to a MySQL schema file from the original database. (via mysqldump)

2: Edit the schema do it doesn't CREATE any tables, only INSERTs information. The columns in, for example, the user table aren't going to be the same since there are hack differences between the two. This is my biggest concern.

3: Load the schema into the new database.

Is this going to work as planned? I'm trying to leave behind a totally broken database that I hacked to hell and now is a mess and move onto a fresh one, without losing accounts or posts.

[Logician]

In other words you are trying to merge 2 vb.

If so I would say your method wouldnt work.

Check here:
https://vborg.vbsupport.ru/showthread.php?s=&threadid=37451

There is a very recently released merge script there..

[discore]

Excellent. Thanks for the info. Hopefully this works out okay.

[concept]

yeah i would say just save your
sql file and open it in wordpad and copy and past the members and posts into your query section
that should work

[Logician]

Originally posted by concept
yeah i would say just save your
sql file and open it in wordpad and copy and past the members and posts into your query section
that should work
nope not so simple..

If you are merging 2 vb.s, all info will clash.. (userids, threadids, post ids, attachment ids etc.). By running the query of 1 db will just replace the entire db with that one, not merge..

[Erwin]

Logician is right - in both vB databases would be members with the same userid - one would override the other. You cannot do a simple import.

[discore]

What if the receiving database had no forums, posts, or users? That was my plan originally.

[Logician]

then it's not a merge, just a dublication. Just restore a backup of first db in the second server and you'll be fine unless you applied hacks which modify (add columns etc.) the db..

[JulianD]

Hi guys... I just made a Merge tool for vBulletin 2.2.x for a friend... I haven't merged the two board yet, but I will in a few days.... I've been testing it on my localhost forums and it works quite well. It's not perfect, but it works :)

Basically the script can do the following:

Merge: users, forums, threads, posts, polls, private messages and attachments.

You can associate users, to prevent duplication...

The script is not perfect, and you will have to reconfigure all the forum permissions, moderators, etc... But you will have all your users and information merged...

Just let me know if somebody is still interested about this, so we can test it and release it here.