Database reaching well over 100MB using WP (20 posts)

  1. boflinez
    Posted 5 years ago #

    My blog has reached 100MB well over almost 150MB... I was told to delete somethings from the database. As I looked into it there really isn't much to delete. Below is what my blog has in content (ie. posts, comments, etc.). Typically what can cause this??

    1,461 Posts
    10 Pages
    8 Categories
    702 Tags

    0 Approved
    0 Pending
    0 Spam

  2. You could try cleaning up post revisions.


    Still here? Okay. Login to MySQL command-line interface, phpMyAdmin, SQLyog or other MySQL GUI tools and run this:

    DELETE FROM wp_posts WHERE post_type = "revision";

  3. CSD-Images
    Posted 5 years ago #

    This might be a 'safer' version for some people:


    Especially for those who have no access to SQL.

  4. boflinez
    Posted 5 years ago #

    I backed it up, I'm still having issues with it... I deleted my posts per my hosts. I'm trying to restore it now.

  5. That's really odd. I have a site comparable in size and my DB is only 17 megs.

    Do you have phpMyAdmin? Can you check and see what's so large?

  6. boflinez
    Posted 5 years ago #

    Can i give you the d/l link for my sql file? My host recommended deleting posts which I really prefer not to do...

  7. If you have phpMyAdmin, you can just go in and look at the database. It'll tell you the sizes of each table and the total size of the whole thing.

  8. boflinez
    Posted 5 years ago #

    My host told me to delete the tables and upload the export but they also want me to get it under 100MB... Now I feel like Im losing my site and its entire...

  9. boflinez
    Posted 5 years ago #

    I have a back up thats in .bak.gz will that restore my posts to my site?

  10. If you delete the database tables you WILL lose your posts. The database stores the CONTENT of your posts.

    That DB size for the number of posts you have is abnormal. You need to find out WHAT is causing the size problems. One way is to export your database and review it, but I would think phpMyAdmin to be easier as it lists sizes of tables on the main view of your DB.

    You can also try http://wordpress.org/extend/plugins/wp-dbmanager/

    Sometimes this is caused by a plugin, but until you know WHAT table, you're guessing.

    If you're not willing to go through your database, yourself, then I can't help you. No I won't do it for you. You may need to hire someone, if your host isn't willing/able to assist.

  11. boflinez
    Posted 5 years ago #

    I am willing to go through it, at the same time I am not sure what exactly I am looking for?

  12. boflinez
    Posted 5 years ago #

    My exported file is a size of 175 when I downloaded it to my PC. My host says it needs to be under 100MB and now I cant upload what I exported so I have no posts.

  13. This is why I said you'd be better served using phpMyAdmin. Which you never answered if you have or not.

    You need to go through the database and figure out what tables are causing the size problems.

    I get your host says you need it to be under 100megs. You either need to review your DB and sort out what's causing the space usage, or get someone else to do it. Your host MIGHT be willing to help you, but if not, you may need to hire someone.

  14. boflinez
    Posted 5 years ago #

    I have phpAdmin, with no files right now..

  15. boflinez
    Posted 5 years ago #

    All I have is a back up file that will not import because of size, so now Im guessing I lost everything????

  16. @mercime
    Volunteer Moderator
    Posted 5 years ago #

    No you haven't. You will just have to import SQL a section/block at a time.
    see the two ways to import? You would have to do the second one. Patience and diligence is key.

    After all that, http://codex.wordpress.org/WordPress_Site_Maintenance

  17. boflinez
    Posted 5 years ago #

    I think I tried that already and because of the size its not taking...

  18. @mercime
    Volunteer Moderator
    Posted 5 years ago #

    You mean you opened a copy of your backed up SQL file and imported blocks of wpprefix_$blogIDnumber_$sections one by one into new database, and repaired tables as you went along?

  19. My blog has reached 100MB well over almost 150MB... I was told to delete somethings from the database.

    Are you sure they were talking about the *database* and not the files?

    Because I have a blog double that size and my db is not that big.

    The images and stuff though, ARE that much.

  20. gulflee
    Posted 5 years ago #

    thinking maybe u have tracking plugins that keep too much info. try clean up that plugins table.. maybe it would help,
    But is true i have site double the post but just lesser then 40MB in db. Look through the phpadmin on each table, you will have idea there.

Topic Closed

This topic has been closed to new replies.

About this Topic


No tags yet.