The Arcive of Official vBulletin Modifications Site.

#1 06-02-2006, 07:58 PM

We are currently running our vB forum at version 3.07 i believe.
Now, we are on the process to migrate that into a new server with a fresh install (and modified/customized) version that is 3.54

As i know that the DB structures are not the same, i would like to ask what is the best way to import the old forum users/posts and data.

Current, i have heard of two practices, one would be using ImpEx software, which i had run on a few tests and seems to work fine alltrough it changes all the ID's and other is (that was my idea) to update the current 3.07 version to 3.54 with the upgrade patches and then once both versions are the same just dump / import the database from behind the vB eyes (using mysqldump).

I would like to ask what is the best practices for acomplish that task, and if there is any other best way that I dont know.

Thanks for your comments.

Dan · #2 06-02-2006, 08:01 PM

First off it is vB and not vBB, next you are probably running 3.0.7.

Next the best way to do an upgrade is a straight upgrade to 3.5.4, no need to impex anything and you won't lose any data this way. But it's always a good idea to backup the database and perform a test upgrade on a backup copy of the database first to make sure there are no issues, if there are issues you may want to look into correcting them or using the impex method.

#3 06-02-2006, 08:07 PM

Thanks for your quick question Dan.
If we do it that way we will preserve the original posts/forums/users ID... would it be a way to "refresh" them? as our current forum has many gaps due some older imports/synchs we did, there are things like userid jumps from 1...1000, 3000 and such without be consecutive.

Dan · #4 06-02-2006, 08:08 PM

Not really the only way to repair that would be with an impex.

Paul M · #5 06-02-2006, 08:10 PM

Consecutive or otherwise id numbers do not affect the running of the forum in anyway so no need to worry about it.

I would copy the 3.0.7 datbase over, and then upgrade to 3.5.4

#6 06-02-2006, 08:16 PM

Yeah, well, it might sound st*pid but i was just worried about to maintain it "clean" and "sorted" , having such hops on the userid is something i dont really like, hehe

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03844 seconds Memory Usage 2,196KB Queries Executed 13 (?)
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 (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (6)post_thanks_box (6)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (6)post_thanks_postbit_info (6)postbit (3)postbit_onlinestatus (6)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_postinfo_query fetch_postinfo 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 bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start postbit_imicons tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!