Version: 1.00, by JulianD
Developer Last Online: Sep 2018
Version: 2.3.x
Rating:
Released: 11-17-2002
Last Update: Never
Installs: 69
Is in Beta Stage
No support by the author.
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.
Show Your Support
This modification may not be copied, reproduced or published elsewhere without author's permission.
I have a quick question. Hopefully someone can answer it.
I have two forums. They are both on different hosts and servers. Is it possible to merge the forums, without moving them onto the same host and server?
I believe so, just go to the forum you want to merge everything into and run the import script and from there put in the ip or host of the other server along with user/pass info and ya should be good.
ich mu? jetzt hier mal in deutsch posten, dazu ist mir das Thema zu heikel, ich bekomme genau diesen Fehler hier wie andere auch.
hi julian,
sorry for my bad english, but i will try my best. the problem is that i get the same errors like the others before
PHP Code:
Database error in vBulletin Merge Tool 2.3.4:
Invalid SQL: SELECT COUNT(*) AS count FROM paradise-of-emotions_net.user
mysql error: You have an error in your SQL syntax near '-of-emotions_net.user' at line 1
mysql error number: 1064
Date: Thursday 05th of February 2004 11:54:28 AM
Script: [url]http://www.starlight-board.net/board/board/importers/bbimport_vb2.php[/url]
Referer: [url]http://starlight-board.net/board/importers/bbimport_vb2.php[/url]
der reale Datanbank Name ist aber paradise-of-emotions_net auf localhost
die 2 Datenbanken liegen auf meinen Server, was also mach ich den falsch.
the real database name is paradis ... on local host (hust lool)
the 2 databases are on my server, so what do i wrong?
If you import the members where to their posts go cause the forums dont have the same like forum names so where do theirt posts go. Do you just import the members and they start with no posts again. If so that is fine as i dont mind just curious!