New to the community? Start here

Installing MU plugins AFTER Multi-DB is installed

I have multi-db installed and working with 16 db’s. Now that it’s in place, I’m noticing many of the mu-plugins I’m installing are getting their db tables placed in wpmu_d rather than in the wpmu_global database.

Is this normal? Does this mean for each new mu-plugin I have to:

(1) manually move all the tables (like wp_blog_activity, wp_comment_activity, or wp_forums) to the global db ??

(2) add a new “add_global_table” entry to db-config.php ?

I thought that once multi-db was installed, new mu-plugins would install their tables to the global db automatically. Am I wrong?

Fri, 5 Dec 2008 19:32:54
  • Klark
    • Site Builder, Child of Zeus

    Made the mistake of installing the Forum plugin without adding the global tables for it.

    So located the 3 tables that the plugin created in exported them to text with SQL CREATE functions included.

    Then I went to the global db and ran that SQL code on it.

    Then I edited db-config.php to include the three tables.

    Dropped the old tables.

    Works fine.

  • bigbk
    • WPMU DEV Initiate

    Hi, I have looked for a solution and this is the closest I have found on the topic. Since things may have changed in 10 months. I need clarification.

    I added several mu plugins on a new mu site after installing multi-db. I did not create global tables in db-config. I just realized this when one of the tables did not load and I needed to do manually.

    I was following the directions in the plugin file and checking to see that the tables were being placed in the db’s. I did not remember how to run the scripts in phpmyadmin and after doing multiple searches here found this thread that reminded me.

    What you’re seeing is normal behavior. You have to configure global tables in db-config.php.

    Do you mean that this is normal behavior and just add global tables in db-config and leave them in the db’s they were placed in by multi db? OR Do you mean, he messed up and should take the steps Clark suggested? Or is there a more efficient way.

    I also have one comment and suggestion and want to know where the proper place to put it is. Thank you.