Vanilla 1 is no longer supported or maintained. If you need a copy, you can get it here.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.
Options

Multiple Discussion Boards on a Single SQL Database?

edited November 2006 in Vanilla 1.0 Help
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?

Comments

  • Options
    Yes, No.
  • Options
    MarkMark Vanilla Staff
    The next revision will allow you to specify the database prefix as a configuration option, so that method will work quite well.
  • Options
    Excellent, thanks Mark. I've only been using Vanilla for a week but I'm extremely impressed with it.
  • Options
    I could've sworn 092 had that option too.
  • Options
    MarkMark Vanilla Staff
    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
  • Options
    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?
  • Options
    I think you have to change it in setup/installer.php line 42 and in setup/mysql.sql
  • Options
    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.
This discussion has been closed.