Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
3 registered (Jake, id242, SD), 30 Guests and 14 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 01/24/07
Posts: 171
Top Posters (30 Days)
Ruben 51
Gizmo 24
DennyP 24
Dunny 15
SteveS 14
AllenAyres 12
SD 10
dbremer 10
drkknght00 9
driv 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Page 1 of 2 1 2 >
Topic Options
#218530 - 10/29/08 05:29 PM Add a test board using the same MYSql Database
Ruben Offline

Registered: 12/20/03
Posts: 4424
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.
_________________________
Blue Man Group
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#218531 - 10/29/08 05:57 PM Re: Add a test board using the same MYSql Database [Re: Ruben]
Island Piper Offline
member
Registered: 04/05/07
Posts: 166
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 06:05 PM Re: Add a test board using the same MYSql Database [Re: Island Piper]
Ruben Offline

Registered: 12/20/03
Posts: 4424
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.
_________________________
Blue Man Group
Top
#218547 - 10/30/08 09:57 AM Re: Add a test board using the same MYSql Database [Re: Ruben]
Island Piper Offline
member
Registered: 04/05/07
Posts: 166
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 03:33 PM Re: Add a test board using the same MYSql Database [Re: Island Piper]
Yarp™ Offline
Registered: 08/30/06
Posts: 1513
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 04:06 PM Re: Add a test board using the same MYSql Database [Re: Yarp™]
Ruben Offline

Registered: 12/20/03
Posts: 4424
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.
_________________________
Blue Man Group
Top
#218569 - 10/30/08 04:43 PM Re: Add a test board using the same MYSql Database [Re: Ruben]
Yarp™ Offline
Registered: 08/30/06
Posts: 1513
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 04:44 PM)
_________________________
Top
#218570 - 10/30/08 05:03 PM Re: Add a test board using the same MYSql Database [Re: Yarp™]
Ruben Offline

Registered: 12/20/03
Posts: 4424
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.
_________________________
Blue Man Group
Top
#218581 - 10/30/08 07:45 PM Re: Add a test board using the same MYSql Database [Re: Ruben]
Gizmo Offline

Registered: 06/05/06
Posts: 14995
Loc: Portland, OR; USA
put "test" in both
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#218584 - 10/30/08 08:02 PM Re: Add a test board using the same MYSql Database [Re: Gizmo]
Ruben Offline

Registered: 12/20/03
Posts: 4424
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.
_________________________
Blue Man Group
Top
Page 1 of 2 1 2 >



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Temporary Password email not being received
by
05/24/12 10:02 PM
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Forum Stats
10492 Members
36 Forums
33842 Topics
181709 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image