vBulletin Merge Tool for v2.2.x

Well, I did this for a friend and I saw some request for this tool before, so here you got.

My code is based on the import scripts that you found on vbulletin.com.

What it does?
- Merge: users, forums, threads, posts, polls, PMs and attachments of two vBulletin databases.
- It allows to associate usernames with current vBulletin users, to prevent duplication

Both databases should be in the same server, and use the same password.

If there's a duplicated name in both databases, the script will postfix the username from the database you're merging with something like: [imported]. So you probably will find users that looks like username[imported] after the merge. To solve this problem of two usernames being one person, there's a tool in the script to merge users individually.

New version
- The database to merge can now have a different host/username/password. *
- Ability to auto merge users with the same username (to avoid 4000 users with the [imported] thing. ) *
- You can now skip the forum merging, and use the tool only to merge users.
- The poll bug seems to be fixed now. Post your feedback.


Installation:

Simply upload the attached file to /forum/importers/ and go to your Admin CP > BB Import Systems and choose vBulletin Merge Tool for v2.2.x.

Note that this script requires vBulletin 2.2.7 (or newer) to work. I have tested it with 2.2.6 but you need to upgrade the file /forum/admin/bbimport.php to the version you found on vBulletin 2.2.7 or newer.



Important Information:
This merger is beta! You should backup everything before starting. Use it under your own risk!


I decided to reopen this thread with a new version of this merger. I hope it fixes all the problems with previous versions.

REMEMBER:

If you're going to merge two database that are located on the same host, you SHOULD use a different hostname for both database.

For example:

If you have 'localhost' configured as your $servername variable on the admin/config.php file, and you want to merge a database stored on the same server, you should use something like '127.0.0.1'. Another example... If you have $servername configured to 'vbulletin.org', and you want to merge a database located on vbulletin.org, use the IP address for that server instead... In this case '205.214.66.221'. Get it?

Sorry, I'm not very good with english and it's very hard to explain this. I hope you've understood this.

[sweetmercifulcr]

Desperately need to be able to merge two boards, but on different servers. Can this be done with this import script?

Excuse me if it's been asked/answered earlier, i dont want to read 10 pages.

[gmarik]

Respect! Great coding done, I use it every week twice!

[gmarik]

This should be a full release hack... :sleep:

[Dan]

no it still has bugs... like it screwed up my board last time I used it

[wolfe]

got a weird problem i used it and imported all posts/threads/forums/privatemessages and now in the forums where the posts have imported it says

for last posts

31st December 1969 19:00 PM
by


and its got the exact same amount or threads as its got posts but also all the posts inside the thread have got

Sparkz
28th July 2002 19:22 PM This person is on your Ignore List. To view this post click [here]

Sparkz
28th July 2002 19:23 PM This person is on your Ignore List. To view this post click [here]

for all posts

[Smellycat]

Just merged a 2000+ user database with a 1000 user database and it worked a treat have to say well done, and thank you very much!

[wolfe]

sorted the problem out on my end i did not run the things as one i did the users then quit then did next so sorted now you da man d00d

[99SIVTEC]

I've got 3 completely separate, but loosely related websites. I'm thinking of starting a large network with them in which there would only be 1 vbulletin forum. Each site would be a top level forum with their individual forums as sub forums under that.

My question is. If I merge the sites will it just place all of the forums in one large group so I can move them around as needed, or is it going to try and merge forums with the same name? Should I rename the forums before mergine so they are something like

site1_lounge
site2_lounge
site3_lounge
site1_performance
site2_perform....

ect ect so the names are all different and easy to recognize

Thanks again for all of your efforts on this hack. It's denfinetly a life saver and top notch quality.

[Mikal]

I really need some help on this one, I'm trying to merge the old database into the new one. but as soon as I try to run the script
in admin cp

I get this error:
---------------------------------------------------------------------------------
Warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /hotel/sushi-inc_dk/WWW/forums/importers/bbimport_vb2.php on line 45
---------------------------------------------------------------------------------
Database error in vBulletin Merge Tool 2.3.0:

Link-ID == false, connect failed
mysql error:

mysql error number: 0

Date: Wednesday 02nd of July 2003 04:48:53 PM
Script: http://www.sushi-inc.dk/forums/forum...p?action=start
Referer:
---------------------------------------------------------------------------------
and I can't figure out what the problem is.

I did try the first script, but it didnt work since my databases don't have the same dbname or password, although they are on the same server.

I really hope someone here can help me

Thanks in advance

[Mikal]

I really need some help on this one, I'm trying to merge the old database into the new one. but as soon as I try to run the script
in admin cp

I get this error:
---------------------------------------------------------------------------------
Warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /hotel/sushi-inc_dk/WWW/forums/importers/bbimport_vb2.php on line 45
---------------------------------------------------------------------------------
Database error in vBulletin Merge Tool 2.3.0:

Link-ID == false, connect failed
mysql error:

mysql error number: 0

Date: Wednesday 02nd of July 2003 04:48:53 PM
Script: http://www.sushi-inc.dk/forums/forum...p?action=start
Referer:
---------------------------------------------------------------------------------
and I can't figure out what the problem is.

I did try the first script, but it didnt work since my databases don't have the same dbname or password, although they are on the same server.

I really hope someone here can help me

Thanks in advance