Multiple Discussion Boards on a Single SQL Database?

houseinprogress

I'm running multiple web domains as add-ons within a single hosting account. Any suggestions on the best way to implement multiple Vanilla installations using just one SQL database? Am I right that this could be done pretty easily just by doing the installations manually and giving each setup a unique prefix for installation's SQL tables (e.g., LUM1_User, LUM2_User, etc.)? Would there be a better way to go about it?

Bergamot

Yes, No.

Mark

The next revision will allow you to specify the database prefix as a configuration option, so that method will work quite well.

houseinprogress

Excellent, thanks Mark. I've only been using Vanilla for a week but I'm extremely impressed with it.

Bergamot

I could've sworn 092 had that option too.

Mark

I honestly don't remember. Maybe it did. I'm just so used to working with the new version now that I've forgotten the minutiae of 0.9.2

shatterglass

Am I right that this could be done pretty easily just by doing the installations manually and giving each setup a unique prefix for installation's SQL tables (e.g., LUM1_User, LUM2_User, etc.)?

Would anyone like to expand on this technique a bit? Where would I need to enter this unique prefix?

Dinoboff

I think you have to change it in setup/installer.php line 42 and in setup/mysql.sql

shatterglass

Ah! Thanks very much. Those two files are definitely involved. It just occurred to me that I could do a bulk search of the root folder for "LUM_." I'll try that at home later.