WordPress.org

Support

Support » Miscellaneous » Database reaching well over 100MB using WP

Database reaching well over 100MB using WP

  • 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??

    Content
    1,461 Posts
    10 Pages
    8 Categories
    702 Tags

    Discussion
    0 Comments
    0 Approved
    0 Pending
    0 Spam

Viewing 15 replies - 1 through 15 (of 19 total)
  • You could try cleaning up post revisions.

    BACKUP YOUR DATABASE BEFORE EVEN THINKING ABOUT TRYING THIS!!!!!

    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";

    This might be a ‘safer’ version for some people:

    http://wordpress.org/extend/plugins/better-delete-revision/

    Especially for those who have no access to SQL.

    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.

    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?

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

    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.

    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…

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

    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.

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

    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.

    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.

    I have phpAdmin, with no files right now..

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

    No you haven’t. You will just have to import SQL a section/block at a time.
    http://www.tamba2.org.uk/wordpress/restore/#three
    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

Viewing 15 replies - 1 through 15 (of 19 total)
  • The topic ‘Database reaching well over 100MB using WP’ is closed to new replies.
Skip to toolbar