MySQL – WordPress Multisite Settings

Currently this is not an ideal process but will provide needed information.

First get a list of all of the site’s option tables. Typically the main/root site will be wp_options and sub-sequential sites will be wp_2_options, wp_3_options, etc.

# Show all options tables in database
show tables like '%options%';

The results should look similar to this:

wp_2_options
wp_4_options
wp_5_options
wp_6_options
wp_options

Once we have the tables we can create a query like below to get the active plugins and theme modifications, again not ideal

# Show all tables active plugins
SELECT
	(SELECT option_value FROM wp_2_options WHERE option_name='active_plugins') AS wp_2_options,
	(SELECT option_value FROM wp_4_options WHERE option_name='active_plugins') AS wp_4_options,
	(SELECT option_value FROM wp_5_options WHERE option_name='active_plugins') AS wp_5_options,
	(SELECT option_value FROM wp_6_options WHERE option_name='active_plugins') AS wp_6_options,
	(SELECT option_value FROM wp_options WHERE option_name='active_plugins') AS wp_options;

# Show all tables with Make theme modification    
SELECT
	(SELECT option_value FROM wp_2_options WHERE option_name='theme_mods_Make') AS wp_2_options,
	(SELECT option_value FROM wp_4_options WHERE option_name='theme_mods_Make') AS wp_4_options,
	(SELECT option_value FROM wp_5_options WHERE option_name='theme_mods_Make') AS wp_5_options,
	(SELECT option_value FROM wp_6_options WHERE option_name='theme_mods_Make') AS wp_6_options,
	(SELECT option_value FROM wp_options WHERE option_name='theme_mods_Make') AS wp_options;

The results should look similar to this:

a:16:{i:1;s:37:"disable-comments/disable-comments.php";i:2;s:45:"limit-login-attempts/limit-login-attempts.php";i:3;s:23:"make-plus/make-plus.php";i:4;s:41:"ninja-forms-conditionals/conditionals.php";i:5;s:49:"ninja-forms-front-end-editor/front-end-editor.php";i:6;s:37:"ninja-forms-multi-part/multi-part.php";i:7;s:43:"ninja-forms-save-progress/save-progress.php";i:8;s:39:"ninja-forms-style/ninja-forms-style.php";i:9;s:36:"ninja-forms-uploads/file-uploads.php";i:10;s:27:"ninja-forms/ninja-forms.php";i:11;s:48:"open-in-new-window-plugin/open_in_new_window.php";i:12;s:37:"password-protect-wordpress/plugin.php";i:13;s:43:"shortcodes-ultimate/shortcodes-ultimate.php";i:14;s:41:"wordpress-importer/wordpress-importer.php";i:15;s:24:"wordpress-seo/wp-seo.php";i:16;s:29:"wp-mail-smtp/wp_mail_smtp.php";}

a: 22: {
    s: 11: "header-text";
    s: 1: " ";
    s: 18: "header-show-search";
    i: 0;
    s: 12: "logo-regular";
    s: 78: "http://<logo URL>";
    s: 11: "footer-text";
    s: 102: "Copyright © 2015 All Rights Reserved.";
    s: 18: "footer-show-social";
    i: 0;
    s: 18: "nav_menu_locations";
    a: 1: {
        s: 7: "primary";
        i: 2;
    }
    s: 18: "footer-hide-credit";
    i: 1;
    s: 15: "hide-site-title";
    i: 1;
    s: 12: "hide-tagline";
    i: 1;
    s: 15: "font-site-title";
    s: 9: "Open Sans";
    s: 11: "font-header";
    s: 9: "Open Sans";
    s: 16: "font-header-size";
    i: 34;
    s: 16: "font-widget-size";
    i: 13;
    s: 14: "font-body-size";
    i: 14;
    s: 13: "color-primary";
    s: 7: "#666666";
    s: 23: "header-bar-border-color";
    s: 7: "#45a346";
    s: 27: "header-bar-background-color";
    s: 7: "#45a346";
    s: 13: "footer-layout";
    s: 1: "2";
    s: 17: "footer-text-color";
    s: 7: "#ffffff";
    s: 19: "footer-border-color";
    s: 7: "#45a346";
    s: 23: "footer-background-color";
    s: 7: "#45a346";
    s: 19: "footer-widget-areas";
    s: 1: "0";
}