Clean Up Multisite Database?

  • I’m trying to clean up a multisite database, and I’m wondering if there’s a quick/easy way to tell what tables a plugin creates, OR when looking at the database, what plugin created a table or tables?

    I’m fairly certain that old plugins and/or plugins from sites that were imported via BackupBuddy, have brought in a lot of tables and garbage that aren’t needed any longer. However, I’m blanking out on any good way to figure out which are tied to which plugin, etc. Any ideas/help appreciated.

Viewing 4 replies - 1 through 4 (of 4 total)

  • Maybe posting the tables you have in your database and your plugins, somebody ( i.e. me ?? ) could be able to help you since looks like a very specific trouble.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    There isn’t a good way :/ I usually google them.

    I’m in the process of looking at this. I removed 6 sites and the tables are still in Mysql.
    Below are the tables. Tables for sites 7,10,11,12,13,18 are no longer needed.

    I also have the folders created under blogs.dir for the sites deleted.

    Can I just delete the Mysql tables for the sites and the directories in blogs.dir.

    I also have my own server so if I mess up I can restore the WHM backup made last nite (and that backup restre has been tested) My wordpress multisite is built on https://www.vashonguide.com
    Mysql tables below

    premiumpress_emails
    wp_2_commentmeta
    wp_2_comments
    wp_2_links
    wp_2_options
    wp_2_orderdata
    wp_2_postmeta
    wp_2_posts
    wp_2_statcomm
    wp_2_terms
    wp_2_term_relationships
    wp_2_term_taxonomy
    wp_3_commentmeta
    wp_3_comments
    wp_3_links
    wp_3_options
    wp_3_postmeta
    wp_3_posts
    wp_3_statcomm
    wp_3_terms
    wp_3_term_relationships
    wp_3_term_taxonomy
    wp_4_commentmeta
    wp_4_comments
    wp_4_links
    wp_4_options
    wp_4_orderdata
    wp_4_postmeta
    wp_4_posts
    wp_4_statcomm
    wp_4_terms
    wp_4_term_relationships
    wp_4_term_taxonomy
    wp_5_commentmeta
    wp_5_comments
    wp_5_links
    wp_5_options
    wp_5_postmeta
    wp_5_posts
    wp_5_statcomm
    wp_5_terms
    wp_5_term_relationships
    wp_5_term_taxonomy
    wp_6_commentmeta
    wp_6_comments
    wp_6_links
    wp_6_options
    wp_6_postmeta
    wp_6_posts
    wp_6_statcomm
    wp_6_terms
    wp_6_term_relationships
    wp_6_term_taxonomy
    wp_8_commentmeta
    wp_8_comments
    wp_8_links
    wp_8_options
    wp_8_postmeta
    wp_8_posts
    wp_8_statcomm
    wp_8_terms
    wp_8_term_relationships
    wp_8_term_taxonomy
    wp_9_commentmeta
    wp_9_comments
    wp_9_links
    wp_9_options
    wp_9_postmeta
    wp_9_posts
    wp_9_statcomm
    wp_9_terms
    wp_9_term_relationships
    wp_9_term_taxonomy
    wp_10_statcomm
    wp_11_statcomm
    wp_12_statcomm
    wp_13_statcomm
    wp_14_commentmeta
    wp_14_comments
    wp_14_links
    wp_14_options
    wp_14_postmeta
    wp_14_posts
    wp_14_statcomm
    wp_14_terms
    wp_14_term_relationships
    wp_14_term_taxonomy
    wp_15_commentmeta
    wp_15_comments
    wp_15_links
    wp_15_options
    wp_15_postmeta
    wp_15_posts
    wp_15_statcomm
    wp_15_terms
    wp_15_term_relationships
    wp_15_term_taxonomy
    wp_15_visual_form_builder_entries
    wp_15_visual_form_builder_fields
    wp_15_visual_form_builder_forms
    wp_16_commentmeta
    wp_16_comments
    wp_16_links
    wp_16_options
    wp_16_postmeta
    wp_16_posts
    wp_16_statcomm
    wp_16_terms
    wp_16_term_relationships
    wp_16_term_taxonomy
    wp_16_visual_form_builder_entries
    wp_16_visual_form_builder_fields
    wp_16_visual_form_builder_forms
    wp_17_commentmeta
    wp_17_comments
    wp_17_links
    wp_17_options
    wp_17_postmeta
    wp_17_posts
    wp_17_statcomm
    wp_17_terms
    wp_17_term_relationships
    wp_17_term_taxonomy
    wp_17_visual_form_builder_entries
    wp_17_visual_form_builder_fields
    wp_17_visual_form_builder_forms
    wp_18_statcomm
    wp_blogs
    wp_blog_versions
    wp_commentmeta
    wp_comments
    wp_domain_mapping
    wp_domain_mapping_logins
    wp_links
    wp_options
    wp_postmeta
    wp_posts
    wp_registration_log
    wp_signups
    wp_site
    wp_sitemeta
    wp_statcomm
    wp_terms
    wp_term_relationships
    wp_term_taxonomy
    wp_usermeta
    wp_users

    Actually it is deletin’ the accounts but the stats plugin account info is still there.

    So I deleted them, things running great. And I read Mika’s wordpress 101 and 110, very good reading.

    The wordpress install for https://www.vashonguide.com is a closed registration group of sites more for the marketing of my local community Vashon Island. I have 5 multi site installs 1 folders and the other 4 sub domain. All work great.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Clean Up Multisite Database?’ is closed to new replies.