WordPress.org

Ready to get started?Download WordPress

Forums

SQL Database Too Big - Any Way to Shrink? (6 posts)

  1. trs-80
    Member
    Posted 4 years ago #

    Greetings,

    I am on 1and1 running the current version of WordPress. My wordpress site seems to have grown to 120MB, which is 20MB higher than what 1and1 allows. Is there a way to 'garbage collect' or otherwise reduce the size of the database?

    Thanks!

  2. t31os
    Member
    Posted 4 years ago #

    Remove tables from the database?

    What i'd do (and i'm not sure exactly how) is create a mysql query to look for entries in the posts table that have post_status=revision before a certain date, and drop those tables...

    And go from there...

  3. trs-80
    Member
    Posted 4 years ago #

    I am "not strong" in SQL to say the least; is there anyone that can offer step by step (or point me to an add on or something)? Thanks!

  4. t31os
    Member
    Posted 4 years ago #

    Google and search the plugins directory (like i'd do if i were searching).

    If you need professional or assisted supported.
    http://jobs.wordpress.net/

  5. stvwlf
    Member
    Posted 4 years ago #

    1) have you optimized all your tables in phpMyAdmin?
    http://www.webkeydesign.com/26/optimize-your-mysql-databases/

    2) Consider changing to a host that doesn't have arbitrary restrictions like that on what you can do. Its a bit absurd. That said, 120 megs is pretty big.

  6. Hans.Kuepper
    Member
    Posted 4 years ago #

    Hi TRS-80,

    I am just running into the same issue with 1und1. Tried to find a solution to see what is going wrong in the database but so far found none. Did you get the issue solved?

    Thanks

    Hans

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.