Quick Login
A webmaster forum specifically catering for Australian site owners. We discuss site development, marketing and management issues.
Please welcome our newest member, freeza!
Spice up your web site with the ultimate community message board solution!
Fake Id'sGet fake Id's made right now!
vBSEOSearch Engine Optimization for your VBulletin Forum.
AdminFusion
»
MySQL Databases
07-03-2006, 04:06 AM
| #1 |
| | |||||
Title: Forum Junkie
Join Date: Feb 2006 Posts: 3,630 Location: Holmfirth, England    
| MySQL Databases I have heard it is possible to run more than one forum from a MySQL database, but i dont know how to incorporate them together, say if i bought a forum, how could i incorporate it into a current Database? or have i been misinformed? Also, if possible, can it be done without Shell Access?
__________________  | ||||
| |
|
07-03-2006, 04:11 AM
| #2 |
| | |||||
Title: Administrator
Join Date: Sep 2005 Posts: 10,246 Location: Athens, GA | Are you talking about running two separate forums, or...? If you are talking about running two separate forums off of one database, I *believe* this can be done by giving the tables for each forum their own prefix...I'm not positive this would work, but it makes sense to me. The only reason you would really need to do this, though, would be if your host only allowed you to have 1 database...if you can have more than 1, I'd recommend keeping them separate. If you're talking about merging two databases together into one forum, that can be done also, but it depends on the software you're using.
__________________ ...some super-sweet signature | ||||
| |
|
07-03-2006, 04:23 AM
| #3 |
| | |||||
|
Title: Forum Junkie
Join Date: Feb 2006 Posts: 3,630 Location: Holmfirth, England
| Well im hoping to buy a forum, and my host only allows 3 databases, all full (one has my forum, one is a special designed FAQ, and the other is a exclusive gallery so the forum isnt clutterd with pictures). I was hoping if i bought another forum i could merge the two on the same database but of course run them both separtly (the forums) from different URLs) Also, i wouldnt be able to gurantee they would both use the same software (my current is phpBB2)
__________________ | ||||
| |
|
07-03-2006, 04:30 AM
| #4 |
| | |||||
Title: AF Lead Developer
Join Date: Sep 2005 Posts: 1,186 Location: OHIO, US
| Well if they are all phpbb databases then you should be able to give each forum instance it's own table prefix. The only problem with this method is that it is a security nightmare and could be a performance pitfall as you would have just effectively doubled the size of the database. Now importing the data to the database has always been a challenge with out shell access. I personally don't do it with out shell, but other folks around here have had success.
__________________ Do not post your PF private key in public. Did I help you with this post? If so, pls click the rep button or send money.  | ||||
| |
|
07-03-2006, 05:46 AM
| #5 |
| | |||||
 Title: Apprentice
Join Date: Dec 2005 Posts: 155 Location: Philadelphia, PA 
| All engines should have somewhere where you can specify a database table prefix. I run two installations of phpBB, a test phpBB3, and about three homebrew PHP apps all off a single MySQL database. As long as the prefixes are different the tables will all coexist peacefully. | ||||
| |
|
07-03-2006, 06:03 AM
| #6 |
| | |||||
|
Title: Administrator
Join Date: Sep 2005 Posts: 10,246 Location: Athens, GA | Yeesh! I can't even imagine how big of a mess that database must be  I'm like Larry, one program in a single database is enough for me...I couldn't imagine having 300+ tables in a single database
__________________ ...some super-sweet signature | ||||
| |
|
07-03-2006, 01:57 PM
| #7 |
| | |||||
|
Title: Forum Junkie
Join Date: Feb 2006 Posts: 3,630 Location: Holmfirth, England
| So basically, it IS possible, but not relly recommended
__________________ | ||||
| |
|
07-03-2006, 02:20 PM
| #8 |
| | |||||
Title: Back in the Green
Join Date: Feb 2006 Posts: 753 Location: Scotland
| It is very possible and I've had several different forums and scripts running off of a database a few times. As for not recommended, it's just going to have lots of tables in it. This could be a pain if your going to be editing the database often, but otherwise you'll be fine. Other option is to look for a host that allows more, but if your happy where you are...
__________________ Bob's Bit of the Web Into Blogging? Want to talk about it or need help with something? Join us at the Blogging Café. | ||||
| |
|
07-03-2006, 02:24 PM
| #9 |
| | |||||
|
Title: Forum Junkie
Join Date: Feb 2006 Posts: 3,630 Location: Holmfirth, England
| Well im happy with who i use at the moment, but its likely il be upgrading my hosting package soon and then get an extra 7 Databases, brining my total up to 10MySQL Databases. Its just im hopnig to buy a established forum, and would like to host it as quickly as possible once purchased
__________________ | ||||
| |
|
07-03-2006, 02:57 PM
| #10 |
| | ||||||
|
Title: AF Lead Developer
Join Date: Sep 2005 Posts: 1,186 Location: OHIO, US
| Quote:
__________________ Do not post your PF private key in public. Did I help you with this post? If so, pls click the rep button or send money. | |||||
| |
 |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Extremely Angry and Depressed | Rocket 442 | Security and Legal Issues | 12 | 01-09-2008 11:02 PM |
| Need help converting please | AnnCP | SMF | 1 | 09-18-2006 05:02 PM |
| MySQL to Fight Oracle With Fire(bird)? | shellspeare | Graphics and Design | 0 | 03-01-2006 09:12 AM |
| MySQL 5 | gprime | Graphics and Design | 0 | 10-25-2005 02:34 AM |
| PostgreSQl vs MySQL | gprime | Handling Problem Members | 3 | 10-13-2005 07:50 AM |
Linear Mode
