Huge WP Database on Small Site

S

sdeezle

Junior Member
Joined
Aug 13, 2012
Messages
130
Reaction score
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
 
Advertise on BHW
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...
 
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
 
sdeezle said:
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
Click to expand...

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
 
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...
 
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:
sdeezle said:
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?
Click to expand...

I think that 90mb is OK, but with some tweakings and some image resizing you can make it even better, maybe 50mb
 
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.
 
Advertise on BHW
You must log in or register to reply here.
Sign up now!

Main Menu

Home Main Forum List Black Hat SEO White Hat SEO BHW Newbie Guide Blogging Black Hat Tools Social Networking Downloads

Marketplace

Account Selling Content / Copywriting Hosting Images, Logos & Videos Proxies For Sale SEO - Link building SEO - Packages Social Media Social Media - Panels Misc

Making Money

Affiliate Programs Hire a Freelancer Making Money Pay Per Click Site Flipping

BlackHatWorld

BHW Merch Forum Suggestions & Feedback Introductions Lounge Dispute Resolution

Other

Domain Name Forum IM Journeys Web Hosting Newsletter
Back
Top