Go Back   vb.org Archive > Community Discussions > Forum and Server Management
  #1  
Old 11-10-2008, 02:51 PM
ElecMoHwk ElecMoHwk is offline
 
Join Date: Jul 2002
Location: Riverside, CA
Posts: 8
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Loading 2nd database as read-only

I've done some searching on the forums but haven't found anything really hitting this topic.
If I've missed something, please point me to a link if you have one. Thanks.

This issue is that the owner of the forum I'm helping out on, wants to load the vbulletin database of another site which he's acquired, as a read-only sub forum on his site. This would make the other sites old content searchable to his users, but not modifiable by them.

As far as I see it I have 2 options to get this done:

1) Load the 2nd database content into the exisiting database as a sub-forum. This seems pretty iffy and like it would require alot of db manipulation to avoid overwriting the current site's content and such.

2) Leave the 2 databases seperate, and use a sub-forum link on the current site to link into the other site's content, and leave the whole thing marked read-only, but accessible by non-logged in users, as non of the usersnames will match up with the other site's db (or, overwrite their user list with ours?)

Has anyone out there done anything like this?
What was your situation, and experience doing it?
Best practices for something like this?

Is there any method that is supported by the vBulletin team, or maybe just recommended as easiest/safest?

As always, thanks for all of the input in advance.
Reply With Quote
  #2  
Old 11-10-2008, 05:27 PM
SEOvB's Avatar
SEOvB SEOvB is offline
 
Join Date: May 2007
Location: Indianapolis
Posts: 2,451
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

1. Use the impex tool available at vBulletin.com to merge the two databases together. It won't over write anything.

Create a subforum on your site, and then either move or place the imported forums underneath that.

Job finished.
Reply With Quote
  #3  
Old 11-10-2008, 05:48 PM
ElecMoHwk ElecMoHwk is offline
 
Join Date: Jul 2002
Location: Riverside, CA
Posts: 8
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I don't want to merge the databases.

I want to keep the old site that was acquired as a totally seperate structure... and just put it under a subforum of the current site. My understanding with merging them, would make them both mixed together, forums from the old site along side forums of the same hirearchy of the new site.

Am I wrong in this understanding?
Reply With Quote
  #4  
Old 11-10-2008, 07:50 PM
ImmortalForums ImmortalForums is offline
 
Join Date: Feb 2007
Posts: 70
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Then just leave the old forum as it is, set each forum to closed, which is under edit forum.

Then just create a link to the old forum.
Reply With Quote
  #5  
Old 11-10-2008, 09:11 PM
ElecMoHwk ElecMoHwk is offline
 
Join Date: Jul 2002
Location: Riverside, CA
Posts: 8
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The old forum site is long gone. All we have is the vbulletin database. We would like to get it online without having to purchase another entire vbulletin license to resurrect a read-only archive of historical posts.
Reply With Quote
  #6  
Old 11-10-2008, 09:40 PM
SEOvB's Avatar
SEOvB SEOvB is offline
 
Join Date: May 2007
Location: Indianapolis
Posts: 2,451
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Nope, if you run another DB i do believe you'll have to purchase another license for a forum to be read only.

You can easily and safely merge the database.

On the active site, create a subforum called "Old Site Archive", then place all the "archive" posts and threads and forums underneath of that and make it so everyone can read it but not post.
Reply With Quote
  #7  
Old 11-10-2008, 09:59 PM
ElecMoHwk ElecMoHwk is offline
 
Join Date: Jul 2002
Location: Riverside, CA
Posts: 8
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I have never used or tried the Impex tool. Will it let me bring in the "old site" database, into an exisiting sub-forum from the get-go? Or do I have to merge them, then move them all one by one?
Reply With Quote
  #8  
Old 11-11-2008, 10:49 AM
Angel-Wings's Avatar
Angel-Wings Angel-Wings is offline
 
Join Date: Sep 2007
Posts: 206
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well - read the Impex Manual

It can import the old forum / posts / threads into your existing VB. Then or before create a subforum moving the imported forums there, making the created sub-forum read-only that nobody can post there or open new threads.

http://www.vbulletin.com/docs/html/impex is the location
Reply With Quote
  #9  
Old 11-11-2008, 01:18 PM
ElecMoHwk ElecMoHwk is offline
 
Join Date: Jul 2002
Location: Riverside, CA
Posts: 8
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks all for the input. Will be doing some Impex reading today and will post the results here after we give it a shot.
Reply With Quote
Reply

Thread Tools
Display Modes

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 04:25 PM.


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.05598 seconds
  • Memory Usage 2,233KB
  • 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
  • (9)post_thanks_box
  • (9)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (9)post_thanks_postbit_info
  • (9)postbit
  • (9)postbit_onlinestatus
  • (9)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
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete