Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
5 registered (Harold, Mark S, packlite, Ruben Rocha, Sirdude), 27 Guests and 22 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 01/04/09
Posts: 1
Top Posters (30 Days)
Ruben Rocha 95
Rick 85
Mark S 74
Gizmo 49
Thelockman 49
driv 35
Sirdude 32
ntdoc 28
AllenAyres 26
packlite 26
Latest Photos
bear test
Beach Barbie-Q
Sunset
Accept the challenge!
Trees
Page 1 of 2 1 2 >
Topic Options
Rate This Topic
#218530 - 10/29/08 02:29 PM Add a test board using the same MYSql Database
Ruben Rocha Online   content
addict
***

Registered: 12/20/03
Posts: 454
Loc: Lutz,FL
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.
_________________________
I am not an expert.
I just use the stuff!!
At the very least post your forum URL in your profile.
If you receive help here at least post back to let us know what the outcome is.
In case you did not know we are just users!

Top
#218531 - 10/29/08 02:57 PM Re: Add a test board using the same MYSql Database [Re: Ruben Rocha]
Island Piper Offline
member

Registered: 04/04/07
Posts: 164
Loc: Friday Harbor, WA
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.
_________________________
Dunsire Bagpipe Forums

Top
#218532 - 10/29/08 03:05 PM Re: Add a test board using the same MYSql Database [Re: Island Piper]
Ruben Rocha Online   content
addict
***

Registered: 12/20/03
Posts: 454
Loc: Lutz,FL
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.
_________________________
I am not an expert.
I just use the stuff!!
At the very least post your forum URL in your profile.
If you receive help here at least post back to let us know what the outcome is.
In case you did not know we are just users!

Top
#218547 - 10/30/08 06:57 AM Re: Add a test board using the same MYSql Database [Re: Ruben Rocha]
Island Piper Offline
member

Registered: 04/04/07
Posts: 164
Loc: Friday Harbor, WA
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.
_________________________
Dunsire Bagpipe Forums

Top
#218563 - 10/30/08 12:33 PM Re: Add a test board using the same MYSql Database [Re: Island Piper]
blaaskaak Online   content

****

Registered: 08/30/06
Posts: 1316
Loc: Breda, NL
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.
_________________________

Top
#218564 - 10/30/08 01:06 PM Re: Add a test board using the same MYSql Database [Re: blaaskaak]
Ruben Rocha Online   content
addict
***

Registered: 12/20/03
Posts: 454
Loc: Lutz,FL
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.
_________________________
I am not an expert.
I just use the stuff!!
At the very least post your forum URL in your profile.
If you receive help here at least post back to let us know what the outcome is.
In case you did not know we are just users!

Top
#218569 - 10/30/08 01:43 PM Re: Add a test board using the same MYSql Database [Re: Ruben Rocha]
blaaskaak Online   content

****

Registered: 08/30/06
Posts: 1316
Loc: Breda, NL
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.


Edited by blaaskaak (10/30/08 01:44 PM)
_________________________

Top
#218570 - 10/30/08 02:03 PM Re: Add a test board using the same MYSql Database [Re: blaaskaak]
Ruben Rocha Online   content
addict
***

Registered: 12/20/03
Posts: 454
Loc: Lutz,FL
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.
_________________________
I am not an expert.
I just use the stuff!!
At the very least post your forum URL in your profile.
If you receive help here at least post back to let us know what the outcome is.
In case you did not know we are just users!

Top
#218581 - 10/30/08 04:45 PM Re: Add a test board using the same MYSql Database [Re: Ruben Rocha]
Gizmo Moderator Offline

***

Registered: 06/04/06
Posts: 12089
Loc: Portland, OR; USA
put "test" in both
_________________________
UGN Security, Elite Web Gamers & VNC Web Design Owner
Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic

Top
#218584 - 10/30/08 05:02 PM Re: Add a test board using the same MYSql Database [Re: Gizmo]
Ruben Rocha Online   content
addict
***

Registered: 12/20/03
Posts: 454
Loc: Lutz,FL
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.
_________________________
I am not an expert.
I just use the stuff!!
At the very least post your forum URL in your profile.
If you receive help here at least post back to let us know what the outcome is.
In case you did not know we are just users!

Top
Page 1 of 2 1 2 >


Shout Box

Today's Birthdays
theregit
Recent Topics
7.4.1 show/hide category bug
by Seattlebrian
Today at 11:56 AM
7.4.2 Discussion
by Rick
Today at 10:21 AM
UBBCentral now running 7.4.2
by Rick
Today at 10:21 AM
New members don't get access and are not displayed in the config panel
by Yomar
Yesterday at 03:32 AM
How to Change Link Color / Underline in styles?
by ECNet
01/07/09 10:00 PM
Forum Stats
4298 Members
33 Forums
30692 Topics
156038 Posts

Max Online: 978 @ 06/24/07 08:19 PM