Previous Thread
Next Thread
Print Thread
Hop To
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
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
Joined: Apr 2007
Posts: 120
member
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.


Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
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
Joined: Apr 2007
Posts: 120
member
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.



Joined: Aug 2006
Posts: 1,358
Y
Veteran
Veteran
Y Offline
Joined: Aug 2006
Posts: 1,358
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]
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
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
Joined: Aug 2006
Posts: 1,358
Y
Veteran
Veteran
Y Offline
Joined: Aug 2006
Posts: 1,358
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 4:44 PM.

[Linked Image from siemons.org]
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
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
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
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.
Do you need Forum Install or Upgrade Services?
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!
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
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
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
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.
Do you need Forum Install or Upgrade Services?
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!
Joined: Oct 2006
Posts: 98
member
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!


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
1 members (Ruben), 476 guests, and 111 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)