1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Huge WP Database on Small Site

Discussion in 'Blogging' started by sdeezle, Aug 29, 2013.

  1. sdeezle

    sdeezle Junior Member

    Joined:
    Aug 13, 2012
    Messages:
    129
    Likes Received:
    23
    I have what I think is a weird issue, when I go to backup my site with BackUpWordpress I see it says "Backup my 653MB database and files..."

    This number seems way too big as the site is only 30 odd pages, yet I don't know where to look to see what's using up so much memory, any help with this?

    I do have it set to files AND database but it still seems far too big, any idea if this is a normal amount?

    EDIT: As a note, I did a backup a few days ago and it was only 68mb in size, I have only since added a couple of posts
     
  2. HeRBaR

    HeRBaR Supreme Member

    Joined:
    Aug 15, 2011
    Messages:
    1,216
    Likes Received:
    980
    Occupation:
    Sleeping
    Location:
    localhost
    Home Page:
    For a 30page blog, NO this is not normal, but I think that Backup Wordpress can backup files and database seperated from each other, so try to make a backup of them separated and see which one have the big size...
    Or maybe you made too much backups and you are backuping even the old backups of your site, so if your site was 50Mb and you backuped it 10 times, ti will make 500Mb of backups because you will have 10 different backups inside of one...
     
  3. sdeezle

    sdeezle Junior Member

    Joined:
    Aug 13, 2012
    Messages:
    129
    Likes Received:
    23
    Right I deleted all but the latest backup and checked, 6MB for database, 647MB for files :/

    Where can I find these stored files through Cpanel? I had a look around and nothing stood out as irregular
     
  4. HeRBaR

    HeRBaR Supreme Member

    Joined:
    Aug 15, 2011
    Messages:
    1,216
    Likes Received:
    980
    Occupation:
    Sleeping
    Location:
    localhost
    Home Page:
    You can find them using a FTP client...
    Maybe you have uploaded a lot of images, or maybe you have uploaded a psd file when you uploaded your wp theme and that psd file is too big
     
    • Thanks Thanks x 1
  5. HeRBaR

    HeRBaR Supreme Member

    Joined:
    Aug 15, 2011
    Messages:
    1,216
    Likes Received:
    980
    Occupation:
    Sleeping
    Location:
    localhost
    Home Page:
    I can help you to see where the problem is, but you have to give me FTP access or Cpanel access...
    Or if you have a fast internet connection you can download your backup file, extract it on your local computer and sort its folders by size and like this you can find which folder are the biggest ones and why...
     
  6. sdeezle

    sdeezle Junior Member

    Joined:
    Aug 13, 2012
    Messages:
    129
    Likes Received:
    23
    I figured out I had some leftover partial backups from when I tried out a different plugin that attempted to backup a lot more data (including plugins) removing this bought it down to 90mb. Sound better?
     
    Last edited: Aug 29, 2013
  7. Sky Tiger

    Sky Tiger Jr. VIP Jr. VIP Premium Member

    Joined:
    Jul 18, 2013
    Messages:
    897
    Likes Received:
    199
    Images and plugins can take up lots of space.
     
  8. HeRBaR

    HeRBaR Supreme Member

    Joined:
    Aug 15, 2011
    Messages:
    1,216
    Likes Received:
    980
    Occupation:
    Sleeping
    Location:
    localhost
    Home Page:
    I think that 90mb is OK, but with some tweakings and some image resizing you can make it even better, maybe 50mb
     
  9. saber210

    saber210 Supreme Member

    Joined:
    Sep 1, 2011
    Messages:
    1,358
    Likes Received:
    500
    Location:
    -
    Wordpress have a function that autosave your post and page for revisions.

    It is also stored in the database.

    IF you go to your post db, you will see unpublished post.