SQL Database Too Big – Any Way to Shrink?

  • trs-80

    (@trs-80)


    14 years, 12 months 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!

Viewing 5 replies - 1 through 5 (of 5 total)
  • t31os

    (@t31os)

    14 years, 12 months 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…

    Thread Starter trs-80

    (@trs-80)

    14 years, 12 months 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!

    t31os

    (@t31os)

    14 years, 12 months 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/

    stvwlf

    (@stvwlf)

    14 years, 12 months 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.

    hanskuepper

    (@hanskuepper)

    14 years, 5 months 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

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘SQL Database Too Big – Any Way to Shrink?’ is closed to new replies.