Forums on sub domains - single databse

[Blocker]

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]

You can install several forums at the same database. Only make sure that each forum has a different db prefix.

[Blocker]

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]

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]

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]

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]

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?