The MU forums have moved to WordPress.org

Database Spring Cleaning (10 posts)

  1. amnesiak
    Member
    Posted 16 years ago #

    Hey there guys.
    Now that I've got over 5,500 tables and probably half of them were created due to spammers which I've deleted, is there any easy way of cleaning up the database?

    Or is there any easy way of determining which tables are unused in order to tick and delete?

  2. amnesiak
    Member
    Posted 15 years ago #

    anybody?

  3. Ovidiu
    Member
    Posted 15 years ago #

    google for wpmu power tools, I think its available from wpmu.org and check out the cleaning options.
    It might not do the whole job, but it might help.

  4. Ovidiu
    Member
    Posted 15 years ago #

    also you might use wp tuner plugin to analyze your site and find out what is the most ressource intensive part of your site?

  5. amnesiak
    Member
    Posted 15 years ago #

    thanks alot ovidiu I'm sure it'll benefit others too :)

  6. thierryyyyyyy
    Member
    Posted 15 years ago #

    seems that the official page for this very good plugin is :
    http://plugins.paidtoblog.com/wpmu-power-tools/

    i just modify the limit for "old blogs" to be 300 days, and not 30 ...
    one thing missing : the user which created this unused blog is not deleted once the blog is deleted

  7. andrea_r
    Moderator
    Posted 15 years ago #

    becasue a user may have more than one blog: a neglected one and one they use a lot. :)

  8. tdjcbe
    Member
    Posted 15 years ago #

    Which is why I don;t like the idea of deleting any blog for nonusage.

    I also seem to remember a certain host doing that and turning it over to one of their employees only to have the original creator come back wondering where their blog went.

  9. Konstan
    Member
    Posted 15 years ago #

    I cant get wp tuner to work, I have the multi-db plugin, maybe this is the cause?

    I get a fatal error on plugin activation, and this seems like a nice tool.

  10. cafespain
    Member
    Posted 15 years ago #

    What's the fatal error, do you get any message in your error logs

About this Topic

  • Started 16 years ago by amnesiak
  • Latest reply from cafespain