vb.org Archive - Database Migration FROM 3.x to 3.5x

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Database Migration FROM 3.x to 3.5x (https://vborg.vbsupport.ru/showthread.php?t=117468)

[email protected] vbmenu_register("postmenu_996584", true);

06-02-2006 07:58 PM

Database Migration FROM 3.x to 3.5x

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	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.

[email protected] vbmenu_register("postmenu_996614", true);

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	06-02-2006 08:08 PM

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

Paul M

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

[email protected] vbmenu_register("postmenu_996634", true);

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

All times are GMT. The time now is 11:02 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01309 seconds Memory Usage 1,720KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: