New to the community? Start here

Multi DB – plugin clarification, please.

Hi all.

I have just successfully converted a vanilla install of WPMU to the 16 database option with multi DB as a test run for the site I’m actually working on. The actual site (though still running on my local test server) uses various plugins, and I’m reasonably confident I know how to edit db-config to add-global-table(‘tablename’:wink:; for these. What I wanted to check was if plugins added after the conversion will automatically add their global tables in the correct location?

Does it make more sense to install WPMU on the live server and do the conversion right away before installing themes and plugins, or to do the conversion on the testing server (including global tables required for plugins installed already) and then export the databases to the live server? (Can I even do that?) The usernames and passwords will be different on the testing and live servers, as will the IP addresses. I’ve never done this before, as it’s my first WPMU install and I’m more used to single WordPress installs where I can get the whole site ready on the local server and then edit the database connection details before uploading.

All advice appreciated.

Thanks

Janie

Thu, 20 Aug 2009 17:08:14
  • Andrew
    • Champion of Loops

    Hiya,

    What I wanted to check was if plugins added after the conversion will automatically add their global tables in the correct location?

    If you configure the tables in db-config.php *before* adding the plugins in then they should add their tables to the correct db.

    Does it make more sense to install WPMU on the live server and do the conversion right away before installing themes and plugins, or to do the conversion on the testing server (including global tables required for plugins installed already) and then export the databases to the live server?

    Personally I’d just make a backup and do it on the live server. Especially if the site doesn’t get a ton of traffic.

    Thanks,

    Andrew

  • stcwebdesigns
    • Flash Drive

    It won’t have any traffic initially. It’s a brand new project, and there is no live site yet. Does your advice still apply?

    If, at some stage down the road, I come across a new plugin that I need to install and which requires a global table, will I need to add it to db-config.php before installing it? Sorry if you feel you’ve answered that already, but I don’t think I expressed myself very clearly with my question as I had one thought that led to another and they weren’t necessarily part of the same question.

    Thanks

    Janie

  • Andrew
    • Champion of Loops

    It won’t have any traffic initially. It’s a brand new project, and there is no live site yet. Does your advice still apply?

    If it’s a brand new site with no traffic then there’s no reason not to do everything on the live site.

    If, at some stage down the road, I come across a new plugin that I need to install and which requires a global table, will I need to add it to db-config.php before installing it?

    Yes.

    Thanks,

    Andrew