View Full Version : Forums on sub domains - single databse
Blocker
02-17-2010, 05:49 PM
Hi.
I have 4 sub domains but only one sql database permitted by my webhost. I require 4 forums (one in each sub domain), is it possible to do this and how?
Does each forum require it's own separate database?
Is there a clever way to maybe have one database but each forum appears separate at different url's?
Hope I can get the right answers.
Thanks.
borbole
02-17-2010, 05:54 PM
You can install several forums at the same database. Only make sure that each forum has a different db prefix.
Blocker
02-17-2010, 07:46 PM
Thanks barbole I will try that tonight.
Currently the sub domains are one.domainname.com, two.domainname.com, three.domainname.com & four.domainname.com
The database I created was called;
domainname_database
What I understand from you is I should do is;
one_database
two_database
etc.
Carnage
02-17-2010, 07:52 PM
no; you need to set the TABLE PREFIX variable in config.php to something different for each forum.
Please note, each installation of vbulletin requires a separate vbulletin liscense even if they are all installed into the same database.
Blocker
02-17-2010, 08:42 PM
Thank you Carnage. Yes I am aware of the unique licence requirements per install, got that covered.
I'll look in the config.php and make the changes/additions, let you know how I screw up.
borbole
02-18-2010, 08:13 AM
When you install forum 1 for ex, you enter the prefix vb1_, whereas for the second use vb2_ for ex and the config.php files of each forum will be configured automatically. No need to configure them manually.
Blocker
02-18-2010, 11:35 PM
Done! Worked like a charm thanks everyone for your help.
One more question - what is the recommended max prefixes in a database that you could recommend before there is considerable load on the performance on the db affecting the forum?
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.