vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   How can I use one database for 2 vbulletins. (https://vborg.vbsupport.ru/showthread.php?t=234367)

MixMakers 01-28-2010 06:23 AM

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?

salvador21 01-28-2010 09:46 AM

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.

ChopSuey 01-28-2010 09:47 AM

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 :)

jdj 01-28-2010 09:52 AM

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.

MrMister 01-28-2010 03:05 PM

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.


All times are GMT. The time now is 06:59 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.00961 seconds
  • Memory Usage 1,718KB
  • 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
  • (5)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