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.

[TDeath]

i have two vbb 2.2.8 databases on the same server. when i try to start the merge script in the control panel, i get the following error msg:

XXXXXXXXXXXXXXXXXXXXX

Warning: Access denied for user: 'p34067380@localhost' (Using password: NO) in /homepages/11/d70604821/htdocs/vbb/admin/db_mysql.php on line 34

Warning: MySQL Connection Failed: Access denied for user: 'p34067380@localhost' (Using password: NO) in /homepages/11/d70604821/htdocs/vbb/admin/db_mysql.php on line 34

Database error in vBulletin Merge Tool 2.2.8:

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

mysql error number: 0

XXXXXXXXXXXXXXXXXXXXXX

do i have to edit something in the db_mysql.php? i tried a lot of different stuff, however nothing worked.

[JulianD]

Are you sure you're typing the right values for the database you want to merge?

[hockyfan]

I have my forum on my server, and a database dump of the forum I would like to merge into my forum. Is this the correct way of doing it? And where should I upload this database dump to?

Also, do both mine and his databases have to be the same version of vB? Or can his be older than mine (mine is 2.3.2)?

h

[JulianD]

You should load your dump file to a real mysql database... before starting with the merge you should have two real database... The one you're running at the moment, and the one you want to merge.

I think it shouldn't be a problem if the version of both databases isn't the same.

Just remember, back up your data before proceed and you should be safe

[hockyfan]

Originally Posted by JulianD

You should load your dump file to a real mysql database... before starting with the merge you should have two real database... The one you're running at the moment, and the one you want to merge.

How do I do that?



h

[JulianD]

mysql -uROOT -p tempdatabase < myotherdump.sql

And the new database with your dump file loaded, is called 'tempdatabase'.

[hockyfan]

Where do I enter that information?

h

[Quest4DSS]

I am willing to pay someone if they can get this to work on a site for me.
I installed it and the merge user A to user B works but I cannot get the database to merge.
Like I said I am willing to pay (within reason) if someone can help with this.
Thanks in advance.

[JulianD]

hockyfan: You should enter that information using SSH. Search the forums if you don't know how to do it.

Quest3DDS: I am sorry the script didn't work for you. I tested it on my local forums and it worked fine. It's a little bit tricky to start using it, but it works for me. What's the exact problem you're having?

[Quest4DSS]

I loaded it and the merge user A and B work fine but when I do the Database merge it just sits there ans then anter about 5 minutes I get Page not found like as if I was being directed somewhere else.