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.

[JulianD]

TravisH: This problem has been reported, so I guess it could be a (very big) bug. hehehe Sorry for all the problems guys, I just don't have the time to test this script. I will however, find some time in the next few days and make some testing and improvements

WoodiE: No, there shouldn't be any problem. I think you can use the database schema from 2.2.0 to the newest version available. But remember that the vbulletin version where the script will be executed, should be 2.2.7 or newer, that's the only requirement.

[TravisH]

Thank you for the reply.
I just used the script from your first post in this thread and found that it pretty much suites my needs other than it did not import calendar events, and has a few issues with polls.
This is a GREAT tool and I would like to congratulate you on your efforts and I wish you continued success with future development.

Thank You,

Travis

[marcel-ea]

hello julian Thx for the hack
I have this problem its a problem with the "-"

Database error in vBulletin Merge Tool 2.2.8:

Invalid SQL: SELECT COUNT(*) AS count FROM date-basename_com.user
mysql error: You have an error in your SQL syntax near '-basename_com.user' at line 1

mysql error number: 1064

Maybe you can fix it

[JulianD]

Ummm let me see what can I do

[marcel-ea]

not the problem. i renamed the database.
all what i mean, is thats a litte bug

Ohhh i merge since 30min 2 forums with 180.000 User
and 400.000 Posts.

[JulianD]

Nice to hear that

Anyway, I think I know why it's happening, I was too lazy to remove some obsolete code from the script... Thanks for reporting it though.

[marcel-ea]

oh nooo

By merge Threads???!? now he give me the same thread
again and again... im now by 500000 ?!?!?

Any Ideas?

Edit:

By 6Mio. all the same thread i stop the script.....

[Locust99]

Um... i am trying to download it... but i keep getting a corrupted zip

[zajako]

04-10-03 at 12:32 AM marcel-ea said this in Post #127
oh nooo

By merge Threads???!? now he give me the same thread
again and again... im now by 500000 ?!?!?

Any Ideas?

Edit:

By 6Mio. all the same thread i stop the script.....

i noticed this too. I have set it to auto refresh and am leaving it going. Its been going for almost an hour and i have around 21000 posts copying.

When it was not set to auto copy the same thread repeating thing, all of them linked to edit pages that did not exist.

I think there is a large error of sort makes it not work, cause it seemed to be stuck in a loop of sort.

[gmtalk]

I ran into the same issues with the one thread repeating and repeating....What I did was restored both DB's back to normal and then turned magic quotes off. Once that was done I restarted the process of the merge. I successfully merged 3 sites together. Site 1:7k Users and 290k posts; Site 2: 11k Users and 410k posts; Site 3: 8300 Users and 330k posts.

All went well on the test DB's and I will be doing this on the live forums later this weekend. The only thing I wish it would do is the avatars. Try telling close to 20k users that they need to redo their avatars. I am dreading that.

Other than that it is a great Script. Thanks Julian for the help a week ago.