Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 01-28-2010, 06:23 AM
MixMakers MixMakers is offline
 
Join Date: Apr 2005
Posts: 110
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default How can I use one database for 2 vbulletins.

I want to create a test forum (same domain just different directory) that uses the same database as my real forum so I can play around with plugins and whatnot. I was just wondering how I could do this?
Reply With Quote
  #2  
Old 01-28-2010, 09:46 AM
salvador21 salvador21 is offline
 
Join Date: Mar 2009
Posts: 54
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You would need to create different database, or it would just affect your real forum.

Make a note of what you do on the test database. so that it's easy when you come to do it on the real one.
Reply With Quote
  #3  
Old 01-28-2010, 09:47 AM
ChopSuey ChopSuey is offline
 
Join Date: Jun 2009
Location: Alaska
Posts: 2,140
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

If you have them sharing same db and your test forum gets a db error that means your main site will get the error too
Reply With Quote
  #4  
Old 01-28-2010, 09:52 AM
jdj jdj is offline
 
Join Date: Sep 2009
Location: Hertfordshire, UK
Posts: 37
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'm not a developer so you'll probably get more detail from someone else.

I think if you're running your site on a windows server you can run another site at the same IP address using a different port other than the default port which if I remember is port 80. The details escape me but they are probably at IIS.net. In MySQL you just choose a different schema (database) as part of the same "instance" (single configuration of MySQL) using a different user name, different password and different table prefix in your config.php to avoid security risks and confusion.

Probably also possible to do this using a subdomain from the same IP address pointing at a different directory.

Personally I just run my test server at a different IP address clearly marked "test installation" with a reference to the main domain for my site so that if anybody checks there's no confusion about what it is. I see this as less risky; less chance that I'll make a mistake and mess up my live installation by mistake.
Reply With Quote
  #5  
Old 01-28-2010, 03:05 PM
MrMister MrMister is offline
 
Join Date: Jun 2005
Posts: 25
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Use this: I am working on a setup running a ton of forums off of it: https://vborg.vbsupport.ru/showthrea...hlight=facades

It has been working almost flawlessly. I have had to make a ton of modifications to have it perform the way I want, but nothing overly complicated.

This is for multiple live sites. If you are using it for a test site, you will cause your self problems. Any change that you make on the test site will be live on the main site as it is one shared DB. You should just look into doing backup and restore to a new database for testing.
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 03:53 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03578 seconds
  • Memory Usage 2,193KB
  • 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
  • (5)post_thanks_box
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (5)post_thanks_postbit_info
  • (5)postbit
  • (5)postbit_onlinestatus
  • (5)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