Previous Thread
Next Thread
Print Thread
Hop To
Add a test board using the same MYSql Database #218530 10/29/2008 4:29 PM
Joined: Dec 2003
Posts: 5,998
Ruben Offline OP
OP Offline
Joined: Dec 2003
Posts: 5,998
Ar first glance this seems simple but I am by no means a sql expert so I am asking this question in advance.

During the install script it prompts you for

  • Database Server Name
  • Database Name
  • Database User and Database Password
  • Tablename Prefix


So if I wish to set up a test board what do I do.
Install ubb in a separate folder then use the same same settings as my active board except for Tablename Prefix which by default is ubbt_ ? If this is true what naming convention do I use for the test board ubbt2_? Not sure what the underscore is needed for. I don'T care about using existing data in my live board I just want a test board for new releases.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: Add a test board using the same MYSql Database [Re: Ruben] #218531 10/29/2008 4:57 PM
Joined: Apr 2007
Posts: 120
Island Piper Offline
member
Offline
member
Joined: Apr 2007
Posts: 120
It's actually a lot simpiler than that:

1) Create a new DB in mysql (ubbtest) for example

2) Create a new UBB directory on your server (ubbtest) for example

3) Install UBBT.7 per install instructions using the above info.

Optional steps:

4) Once installed change the cookie prefix to "ubbtest"
5) Title the test board TEST TEST TEST
6) Change the default theme to something other than your live board.

Bingo, test board.

The cookie thing may not be necessary but I did it because I think I had trouble being logged into both my test and live boards at the same time using the same browser.


Re: Add a test board using the same MYSql Database [Re: Island Piper] #218532 10/29/2008 5:05 PM
Joined: Dec 2003
Posts: 5,998
Ruben Offline OP
OP Offline
Joined: Dec 2003
Posts: 5,998
The reason I asked this question is due to cost, from my host provider. It is cheaper to add tables than to add another database. Way cheaper.
And I did notice that there is a prompt for multiple forums using the same database during the install.
Or was I dreaming?
I did not think about the cookie issue though.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: Add a test board using the same MYSql Database [Re: Ruben] #218547 10/30/2008 8:57 AM
Joined: Apr 2007
Posts: 120
Island Piper Offline
member
Offline
member
Joined: Apr 2007
Posts: 120
Ah, interesting hosting arrangement. I wouldn't have expected a host to charge for additional DB's let alone the number of tables within a db.



Re: Add a test board using the same MYSql Database [Re: Island Piper] #218563 10/30/2008 2:33 PM
Joined: Aug 2006
Posts: 1,356
Yarp™ Offline
veteran
Offline
veteran
Joined: Aug 2006
Posts: 1,356
The database prefix is there to be able to do multiple installs within one database. Same with the cookie prefix, it's there for multiple installs on one domain.


[Linked Image from siemons.org]
Re: Add a test board using the same MYSql Database [Re: Yarp™] #218564 10/30/2008 3:06 PM
Joined: Dec 2003
Posts: 5,998
Ruben Offline OP
OP Offline
Joined: Dec 2003
Posts: 5,998
Thanks blaaskaak that what I am looking for.
What is the format I should enter for the Database prefix and cookie prefix?
Any concerns I should have with using the two forums(one test,one live) with one database?
I understand that I should end up with double the tables but with a different prefix for each forum.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: Add a test board using the same MYSql Database [Re: Ruben] #218569 10/30/2008 3:43 PM
Joined: Aug 2006
Posts: 1,356
Yarp™ Offline
veteran
Offline
veteran
Joined: Aug 2006
Posts: 1,356
No issues whatsoever, just use a table prefix that differs from the liveboard, and a different cookieprefix.

I have a ton of installs, on unique db's, sharing db's, sharing domains, the works. No issues with it.

Last edited by blaaskaak; 10/30/2008 3:44 PM.

[Linked Image from siemons.org]
Re: Add a test board using the same MYSql Database [Re: Yarp™] #218570 10/30/2008 4:03 PM
Joined: Dec 2003
Posts: 5,998
Ruben Offline OP
OP Offline
Joined: Dec 2003
Posts: 5,998
Okay but I have searchd this board for the final answer but no answer.
What do I use in the cookie and table prefix for the second board. I can't seem to find a example on what to use.
Not sure what I enter in the two fields.
Cookie prefix
Tablename prefix.
What is the format I use to type in the fields.

Can I enter just "test" on the cookie prefix field?
Can I enter Just "testubb" for Tablename prefix?
Not sure what I enter in the two fields.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: Add a test board using the same MYSql Database [Re: Ruben] #218581 10/30/2008 6:45 PM
Joined: Jun 2006
Posts: 15,852
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,852
put "test" in both


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Add a test board using the same MYSql Database [Re: Gizmo] #218584 10/30/2008 7:02 PM
Joined: Dec 2003
Posts: 5,998
Ruben Offline OP
OP Offline
Joined: Dec 2003
Posts: 5,998
Thanks Gizmo.
I don't know why this bothers me so much. I was just trying to find out if there was a specific format convention to enter.
So I guess I can enter blabla in both if I wanted.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: Add a test board using the same MYSql Database [Re: Ruben] #218586 10/30/2008 8:28 PM
Joined: Jun 2006
Posts: 15,852
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,852
Originally Posted by Ruben Rocha
So I guess I can enter blabla in both if I wanted.
yes


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Add a test board using the same MYSql Database [Re: Ruben] #218660 11/01/2008 1:57 PM
Joined: Oct 2006
Posts: 98
phoebe Offline
member
Offline
member
Joined: Oct 2006
Posts: 98
Say, on this subject i did the same thing, two installs with different prefix and cookie etc. in one mysl5 database and did have an issue with the old board skipping over to use the new boards tables even thought the prefixes were quite different. It was crazy weird...but not too consequental as I was done migrating my settins over and closing the old board. Just some weirdness. It suddenly said it had the new prefix for it's tables in the cp. The only thing I did before noticing this change was to use the drop down on the old board to change the skin. It still had the old header html I put in but the new cp settings!


Forum Search
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Mobile app?
by Baldeagle - 12/06/2019 9:32 PM
How do you change Text Line spacing?
by jorb - 11/23/2019 12:14 AM
What happened to FAQ or Forum Help
by Ruben - 11/20/2019 11:58 AM
Search feature encountering an Error message
by jorb - 11/20/2019 12:06 AM
Followed List v7.7.2 Question
by Ruben - 11/12/2019 12:22 PM
Who's Online Now
3 registered members (Daryl Fawcett, Jake, Baldeagle), 81 guests, and 436 spiders.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Amusing Terain Scenics
Amusing Terain Scenics
by isaac, August 19
Sky places
Sky places
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Snapshot build 20191023)