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.

[Khashyar]

This sounds like a great hack, Julian...

(I am wanting to merge two VB 2.3.4 databases, one of them being about one week older than the other).

I wonder if anyone has had luck in trying the merge LOCALLY first, before uploading it on their server?

Also, does the merge overwrite any information in the host database? For example, if you changed the name of a forum in a newer version of the database, will the merge overwrite the newer name?

Another question... If there are two threads that are the same in the two different databases (i.e., one newer version and one older version of the thread), and there were posts that were deleted in the newer version, will the merge reinsert the deleted posts in the thread?

It sounds like a wonderful hack.

Thanks for answering my questions if you can.

Khashyar

[Khashyar]

Hi again,

Is there a way to merge the posts and threads of ONE user (from an older database) into a newer database where those posts and threads have been deleted, but just not merge other forum data?

Thanks,

Khashyar

[lewekleonek]

Merging failed big time! I am going to restore from the back-up. The forum is a mess - missing posts, threads etc.
Step 5: Merging threads and posts failed and gave the following error:
(of course I've truncated the filedata field for it was a big one - would not fit in the post).

Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: INSERT INTO attachment (attachmentid,userid,dateline,filename,filedata,vi sible) VALUES (

'',
'541',
'1070546658',
'dildostatic.jpg',
'GIF89a',
'1'
)
mysql error:

mysql error number: 0

Date: Monday 26th of July 2004 04:20:42 AM
Script: http://www.steroidology.com/forum/fo...import_vb2.php
Referer: http://www.steroidology.com/forum/im...import_vb2.php

[kingady]

so basically this is , 2 forums on different servers, which are the same ? (same users/posts/threads?) am i correct?

[Gio~Logist]

so this wont work inporting from one siote to another?

[Sia Bani]

Any update on this for vb3.?

Thanks!

[Cebby]

Will there be a version of this for 3.6.x at some time soon?

[MadK]

Originally Posted by Cebby

Will there be a version of this for 3.6.x at some time soon?

I would like to know, please.

[WebConnection]

Originally Posted by MadK

I would like to know, please.

Yeah! me too.

[MadK]

Well?

Last Activity: 07 Feb 2008 22:19