vBulletin + vBulletin = vBulletin

[Wayne2k1.com]

(sorry for the crappy subject, I've never been very good at this :ninja: )

I'll explain my problem:

I'm the admin of a board (600+ users), and I received an offer to admin a bigger and more "visible" board (4000+ users).

So, Wayne, where's the problem?

The problem is that the bigger board is really EMPTY, in terms of contents (there are a HUGE number of private forum, and almost no public) and I'd like to merge the new board with the old one.

This means I have to merge: users, threads&posts and everything related to them.

Someone did it?

No...there's a question BEFORE that:

Is it possibile?

It it is, someone did it? How?

Thank you

[Wayne2k1.com]

Originally posted by Wayne2k1.com
(sorry for the crappy subject, I've never been very good at this :ninja: )

Not only...

I just noticed that someone chose almost the same title...

:speechless:

[Erwin]

I asked about the same thing a while back, but was told that there was no automatic script that did this - importing users or threads from one VB to another.

The main problem is that there is overlap of userids and threadids on both forums - you can manually try to merge the 2 dbs by adding a number into the userid field so that when you copy information across you don't delete current information.

I would be interested to know how anyone did this. The merger I had with another board was done by getting all members to sign up again at my board - needless to say we lost a few members, but surprisingly most people did sign up.

[MadMikey]

I have just spent the week, writing a script to merge two vBulletin databases into one.

It was written specifically for my situation, but someone with knowledge of mySQL and PHP (specifically with vBulletin) could easily get it working.

It will merge all users, first checking for matching email addresses, then exact matches on usernames. If either matches, it is assumed to be the same user. In my situation, we had several users in both forums, so this was appropriate.

It will copy over all users, userfield info (provided all of the fields in the source db exist in the destination db), custom avatars, polls, threads, post, attachments and private messages.

Threads from the original db can be put into any forum in the destination db. Existing forums, new forums....you can even merge 2 or more forums into one.

If anyone is seriously interested in this script, knowing that it will take some work, I can clean it up and get it posted with some instructions. After that, feel free to do whatever you wish with it.

Again. This was written for my two databases (2.2.6). I won't go so far to say it will even work for you, but you're welcome to try.

[Mystic Gohan]

I would LOVE to see somthin like that if you really have it you could be a popular person but if not eh who cares.

But yea there is no way to merge two databases(unless MadMikey's hack works) The things will cololide and mess up believe me I tryed running the querys I got most of it to work with members and stuff just took a LOT of editing. but as for threads and posts there is no way I could manage that.

and the way I tryied I kept messin up on Templates so never fully worked

[Brad]

i hear a offical import script is in the works.

[zachb]

awesome, i have no one to merge with, but if ever the opportunity came, this would be nice to have.

[Scott MacVicar]

Its sitting in cvs, i dont know if James has tested it though.

[Marshalus]

Any news on this?

[Link14716]

I'd say, alter the user table to take off the auto_increment from userid on the one you are moving it from, the run something like:

UPDATE user SET userid=userid+x

x being the highest number userid on the other board.

Of course, you'd have to do this with other tables, too, such as userfield, which is a requirement