Table Remnants after deleting ing

  • Hi:

    I decided to go through and take a look at the tables in my Multisite install of WP and saw that many of the sites that I had deleted still had tables associted with them For example I deleted site ids 5, 6, 7 8 9 and 10. However, there are tables with the names wp_5_xxx and wp_6_xxx etc still in the database. Does anyone have any idea how this can occur? Is it possible that some plugins might try creating tables for a site that was already deleted?

    Finally, is there a tool that can get rid of all of these automatically or should I just manually delete them?

    Thanks very much!

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

  • Hello elindydotcom,

    When you delete a site in WordPress it removes it from the site menu, but doesn’t actually remove it from the database. In order to delete the tables of removed sites or even plugins you generally have to remove the menus manually.

    You can try and see if there are any plugins that remove the tables for you, but I would make sure you have everything backed up before trying every plugin.

    Hope this helps,
    -Kevin

    Thread Starter elindydotcom

    (@elindydotcom)

    Ah, ok. Thanks for the clarification. I guess I can just delete those tables manually then instead of relying on a plugin. If the site data isn’t deleted when the site reference is deleted, I wonder if any other network level table has data related to those sites that are now orphaned and will never be accessed nor deleted.

    Thanks again for the insights.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Table Remnants after deleting ing’ is closed to new replies.