The MU forums have moved to WordPress.org

clearing out the gunk from my database (5 posts)

  1. billdennis5
    Member
    Posted 16 years ago #

    I'm going to be deleting some plugins that I'm not using in hopes of reducing the strain on CPU and my database. What I am HOPING do do is eliminate databases that no longer are needed, especially for deleted blogs and splogs. The guy who is hosting my server is a wiz for this sort of thing, but I don't want to go to the well to often. Are there are plugins that I cna use to automatically delete this gunk

  2. Ovidiu
    Member
    Posted 16 years ago #

  3. billdennis5
    Member
    Posted 16 years ago #

    good plugin. But it doesn't clean out gunk from already-deleted blogs, just those marked as spam. Any other advice?

  4. SteveAtty
    Member
    Posted 16 years ago #

    You might need a script to pick up all the wp_ tables from the information_schema.tables table and then use the wp_users table to exclude the numbers that exist and that can build a drop script.

  5. andrea_r
    Moderator
    Posted 16 years ago #

    If it's leftover plugin tables from deleted blogs, I'd go in and do them manually. Long time, yes. eye-bleeding, yes. Safer - yes. :D

    And yes, I curse plugins that don't uninstall tables.

About this Topic

  • Started 16 years ago by billdennis5
  • Latest reply from andrea_r