Mine is a small website, with mostly 40-50 pages, a dozen posts & videos. Problem is the database has swelled to around 3gb. I installed & uninstalled many plugins, maybe the waste has accumulated. Now all backup scripts fail and I am in a fix. Anyone know how I could remove the waste/transients? Any tip in this direction will be appreciated. Thanks
Cleaning my WP database
- Thread starter Bhankas
- Start date
- Apr 4, 2009
- 13,911
- 71,091
- May 17, 2013
- 3,967
- 24,252
3GB?? That's a lot!
Are you sure you are talking about the .sql database, and not about the root (full of unused backups, etc)?
D
Deleted member 752298
Guest
I recommend using Advanced Database Cleaner:
https://sigmaplugin.com/downloads/wordpress-advanced-database-cleaner/
If you want, I can upload it here for free.
D
Deleted member 183008
Guest
There is some error in your DB. I just checked by exporting my DB with 700+ posts and it was 5.1MB
Please use any wordpress database cleaner to clean your db.
- May 17, 2013
- 3,967
- 24,252
There is something wrong. I never seen that db size in my life (considering the site's size).
I know. All scripts trying to backup database fail. None can make a copy. I saw over 1241 entries and one entry had over 250mb data, not sure what it could be. Moreover I do not know which entries to delete. Without a backup, taking chances risky.
affanperfusion
Regular Member
- Apr 9, 2014
- 200
- 62
Use advanced database cleaner plugin. It is very effective
I downloaded the database (finally) and tried importing in my localhost. It failed too!
Problem is each plugin says "Optimised" nothing further. Most clean up the posts, comments etc and I have none.
Problem is each plugin says "Optimised" nothing further. Most clean up the posts, comments etc and I have none.
MiSparrow
Junior Member
- Jul 29, 2024
- 108
- 47
You should try using database cleanup plugins, such as WP-Optimize or Advanced Database Cleaner, which can remove unnecessary data and optimize your database. It’s also a good idea to check your plugins and themes for any issues or excessive records
CArolineBecks
Regular Member
- May 25, 2022
- 408
- 146
Don’t forget about deleting transients, orphaned tables, spam comments, and post revisions. It helps your site feel better!
I tried WP-optimize, it said optimized, nothing further. Same with ADC.
I have no comments or post revisions. Transients is one thing to look for I know for sure. But now that I have downloaded the database, uploading on localhost to try removing transients is first priority. But no utility loads HUGE database
Just now, used WP Migrate plugin, and took a backup. Excluded transients, and the final size is just 21Mb. Don't know what it contains. I will import into localhost using the same plugin and see what it brought along. Fingers crossed!
Plugins work very vaguely. DB Migrate sent full website data, which I downloaded, sizing to 270 MB. Now I tried importing using the same app on localhost. Surprisingly, despite uploading the downloaded zip, it connected to the parent site, and I got a Server 500 error. In shared hosting what else to expect. IMO this is incorrect.
terrycody
Elite Member
- Sep 29, 2012
- 6,420
- 3,329
You can just extract all the articles, then wipe everything, start to install a wordpress on the domain, import all the articles, then you get a whole new website, but keep the old URL structure, like revamp your website, your database size will be normal this time.
- Sep 10, 2010
- 11,806
- 26,657
perhaps try adding a few more plugins and it might just start working out of sheer pressure.. lol.
The first error you got (Request entity too large) was because your php myadmin could not handle such a large file. You need to increase the upload limit, max post limit etc. Your host is returning ISE probably because you went over your resource limit. This could have been avoided if you searched the table that was huge, and truncated it, instead of downloading everything.
Whenever I try listing the database tables, see a message "there is a critical error in your database" but there is no verbose explanation for me to analyze
D
Deleted member 752298
Guest
Feel free to send me a PM and I'll have a look (free of course). It might be possible that your db tables are incorrect or damaged.