Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 2.x > vBulletin 2.x Beta Releases
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
vBulletin Merge Tool for v2.2.x Details »»
vBulletin Merge Tool for v2.2.x
Version: 1.00, by JulianD JulianD is offline
Developer Last Online: Sep 2018 Show Printable Version Email this Page

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.

Comments
  #112  
Old 03-30-2003, 02:51 PM
tucklis tucklis is offline
 
Join Date: Feb 2003
Posts: 21
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Today at 05:17 AM hockyfan said this in Post #109
I just have to comment, the support and assistance I got with this hack was truely unprecedented. I received excellent support, especially considering this was on his own time and without payment etc. This hack did work very well, and I highly recommend it to anyone!

Excellent work julian, and thank you!!


h
I have to say I second this - great work Julian, thanks!
Reply With Quote
  #113  
Old 03-30-2003, 08:25 PM
gmtalk gmtalk is offline
 
Join Date: Oct 2001
Location: Phillip Island
Posts: 47
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
12-01-02 at 09:15 PM JulianD said this in Post #69


Ohhh sorry.... Now I understand you...

Unfortunately at this time it's not possible to merge two database without the same user and password. I'll try to release a new version with this ability for you guys.

Would like to ask the progress on this.

Thanks
Reply With Quote
  #114  
Old 03-31-2003, 12:33 AM
JulianD's Avatar
JulianD JulianD is offline
 
Join Date: Jan 2002
Posts: 455
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hi gmtalk.

Download the lastest version from here:

https://vborg.vbsupport.ru/attachmen...&postid=359490


And see if it works for you.... It *should* work using two different databases with different host/user/password...
Reply With Quote
  #115  
Old 03-31-2003, 04:41 PM
gmtalk gmtalk is offline
 
Join Date: Oct 2001
Location: Phillip Island
Posts: 47
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Julian,

Silly question. I DLed the one that you linked and it was the same as the one that i had there. I have been trying this out on my test databases. I am importing over 10k users and 300k messages and when it was all said and done it just duplicated my forum that I was importing into.

So now I have 2 general discussion areas with the same posts etc. Thinking that I messed it up. I restored my database back to normal backups that I had. Both the database to merge into and the db that was to be merged.

I then redid the merge as before, but this time swapped my merger and mergee< is that a word > and it did the same but to the other database this time.

Now maybe I am missing something I am not sure. Shouldnt there be two entry areas one for the to db and one for the from db? On all versions that i have DLed from here it only has the one DB entry.

My server is as follows.

DB1: User: rooter Pass: pass DBName: test1
DB2: User: rooter Pass: pass DBName: test2

of course the User and Pass are the same, just not listing them here.

John
Reply With Quote
  #116  
Old 03-31-2003, 04:46 PM
gmtalk gmtalk is offline
 
Join Date: Oct 2001
Location: Phillip Island
Posts: 47
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

PS: yes i made sure that i had the right program. I am doing this from my laptop and not the desktop where i originally tried this.

So no need to clear my cache until i get home and try from the desktop.

john
Reply With Quote
  #117  
Old 03-31-2003, 04:59 PM
JulianD's Avatar
JulianD JulianD is offline
 
Join Date: Jan 2002
Posts: 455
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Uhmmmm First, make sure you have the lastest version... No wait... I'm going to attach the lastest version here in this post, just to make sure..

Ok.. Here's how it works... The database to merge into is the one you're using to run your currently vbulletin installation. You don't need to type the user / password for it, because the script have access to the database, as long as vbulletin is running fine.

Ok now, what's the host/user and password that you should fill at the start of the merge? It's the information for the SECOND database, the one you want to merge with your current vbulletin installation.

If this database is in the same server, you should fill similar values like the ones you have on your config.php. But you have the possibility to merge a database located on another server, by filling the correct host/user/pass and db name, and it should work.

Just send me a PM if you still have problems with the merger.


Here's the lastest version!

Link removed.
Reply With Quote
  #118  
Old 04-05-2003, 08:46 PM
Zero Complex Zero Complex is offline
 
Join Date: Dec 2002
Posts: 8
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

What tables does it exactly merge?

I have a 40mb db, and phpmyadmin keeps giving me the error when i try uploading the vbulletin.sql file that there was No SQL Query! So gonna try cleaning out some of the stuff and see what happens after.
Reply With Quote
  #119  
Old 04-05-2003, 09:47 PM
JulianD's Avatar
JulianD JulianD is offline
 
Join Date: Jan 2002
Posts: 455
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Not sure if it's going to be helpful for you, but the script only reads the following tables:

attachment
forum
poll
post
privatemessage
thread
user
userfield

I'm not sure if it's the complete list of tables the script needs to read...
Reply With Quote
  #120  
Old 04-07-2003, 02:09 AM
TravisH TravisH is offline
 
Join Date: Mar 2003
Posts: 3
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
03-31-03 at 07:41 PM gmtalk said this in Post #114
Julian,

Silly question. I DLed the one that you linked and it was the same as the one that i had there. I have been trying this out on my test databases. I am importing over 10k users and 300k messages and when it was all said and done it just duplicated my forum that I was importing into.

So now I have 2 general discussion areas with the same posts etc. Thinking that I messed it up. I restored my database back to normal backups that I had. Both the database to merge into and the db that was to be merged.

I then redid the merge as before, but this time swapped my merger and mergee< is that a word > and it did the same but to the other database this time.

Now maybe I am missing something I am not sure. Shouldnt there be two entry areas one for the to db and one for the from db? On all versions that i have DLed from here it only has the one DB entry.

My server is as follows.

DB1: User: rooter Pass: pass DBName: test1
DB2: User: rooter Pass: pass DBName: test2

of course the User and Pass are the same, just not listing them here.


John
I am running in to EXACTLY the same problem...
It is just duplicating ALL the entries in the database.
Reply With Quote
  #121  
Old 04-07-2003, 03:16 AM
WoodiE WoodiE is offline
 
Join Date: May 2002
Posts: 317
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I have vb 2.2.8 that I would like to import to a vb 2.3.0 forum, will this work since the database for 2.2.8 is different from a 2.3.0 forum database?

-WoodiE
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 05:32 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.08819 seconds
  • Memory Usage 2,317KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete