Welcome, Guest: Join Nairaland / LOGIN! / Trending / Recent / New
Stats: 2,380,125 members, 5,307,127 topics. Date: Sunday, 08 December 2019 at 05:48 PM

The Easiest Way To Clean Your Wordpress Database. - Webmasters - Nairaland

Nairaland Forum / Science/Technology / Webmasters / The Easiest Way To Clean Your Wordpress Database. (4455 Views)

Make Your Wordpress Site Look Like Nairaland... / Easiest Way On How To Get Bulksms Reseller Website Programin Knowledge Nt Needed / Easiest Way To Get More Traffic To Your Blog. (2) (3) (4)

(1) (Reply) (Go Down)

The Easiest Way To Clean Your Wordpress Database. by mahbubzone: 6:31am On Apr 30, 2016
Hello dear members, I hope that you are well.
In this post, I will address a topic that is very important for WordPress bloggers. It concerns cleaning up their WordPress databases.
Why you should clean up your WordPress Database?
If your WordPress site has been around for longer than a few months, then you should think absolutely about a clean up. Indeed, your database may be full of garbage that make your site sluggish and bloated and affect the loading time of you site, and as you know, every additional second your site takes to load, your page abandon rate rises. We hate waiting for pages to load wink
Advantages of cleaning up your WordPress Database
Cleaning up all unnecessary/orphan items in your WordPress database has many advantages, such as:
Reducing the size of your database.
Improving efficiency when accessing tables.
Your site will load faster than before.
Your backup files will be quicker and smaller.
Many plugins are available!
There are several WordPress plugins that help you identifying the items you should clean and help you also cleaning them. However, you should choose carefully what plugin to use for the clean up in order to not break your site. As you know, there are plenty of bad coded plugins wink
What Plugin to choose for the clean up?
I have so far tried many plugins to clean up my WordPress databases such as WP Clean Up, WP-Optimize, WP-Sweep, etc. They all worked to an extent, but there was always some drawbacks such as: the plugin has not been updated for months or years, or the author does not respond to queries, or there were some missing features, or some users had made bad reviews and had problems using the plugin, etc. Until I found and tested the 'Advanced Database Cleaner' plugin, which is for me the best and I recommend it for you too.
About “Advanced Database Cleaner” plugin
'Advanced Database Cleaner' by 'Younes JFR.' is an easy to use and effective database cleaner for WordPress installations. Capable of removing all your spam, old revisions, trash, post meta data, transient data, etc. in seconds while optimizing your tables and reducing the size of the whole database significantly. It has many useful features such as the automation of clean up and optimization, one you are relieved to set and forget. It is also compatible with WooCommerce, Easy Digital Downloads, etc. It is the only plugin that worked for me without any issues and provides the best free features. Moreover, it is well supported by its author, updated regularly, and has 100% positive reviews.
Additionally, it has also a pro version that comes with advanced features such as detecting orphan options, orphan tables, orphan scheduled tasks, etc. These pro features are not available in any other plugin in the market!
You can download the 'Advanced Database Cleaner' plugin from wordpress.org at: https://wordpress.org/plugins/advanced-database-cleaner
After installing the plugin, you will get a one interface with several tabs. You can then choose what orphan elements to clean.
Here are some useful links:
Plugin home page: https://wordpress.org/plugins/advanced-database-cleaner
Screenshots: https://wordpress.org/plugins/advanced-database-cleaner/screenshots
Users reviews: https://wordpress.org/support/view/plugin-reviews/advanced-database-cleaner
FAQ: https://wordpress.org/plugins/advanced-database-cleaner/faq

1 Like 3 Shares

Re: The Easiest Way To Clean Your Wordpress Database. by adekayo1234(m): 6:35am On Apr 30, 2016
Cool shocked shocked
Re: The Easiest Way To Clean Your Wordpress Database. by yomalex(m): 6:39am On Apr 30, 2016
Nice tip
Re: The Easiest Way To Clean Your Wordpress Database. by charsobodo(m): 6:41am On Apr 30, 2016
I use WP Optimizer on my blog and it works great for me.
Re: The Easiest Way To Clean Your Wordpress Database. by aragon4realz(m): 6:45am On Apr 30, 2016
will try it out...
Re: The Easiest Way To Clean Your Wordpress Database. by Speakdatruth: 7:21am On Apr 30, 2016
all these hungry people wey dey call demselve blogger
Re: The Easiest Way To Clean Your Wordpress Database. by Bigajeff(m): 7:28am On Apr 30, 2016
pls guru in the house, any WordPress plugin to resolve "resource limit reached error error message" on unlimited band with and space hosting plan
Re: The Easiest Way To Clean Your Wordpress Database. by khalifjgusau(m): 7:28am On Apr 30, 2016
Gud, you just touched where it sweet me most... I really benefited...
Re: The Easiest Way To Clean Your Wordpress Database. by dayoungmoney1: 7:30am On Apr 30, 2016
thanks for the tips
Re: The Easiest Way To Clean Your Wordpress Database. by 77al: 7:45am On Apr 30, 2016
I just hope those plugins won't mistakely delete some important stuffs
Re: The Easiest Way To Clean Your Wordpress Database. by bot101(m): 7:59am On Apr 30, 2016
Bigajeff:
pls guru in the house, any WordPress plugin to resolve "resource limit reached error error message" on unlimited band with and space hosting plan
No plugin for that. Buy more bandwidth, or just get a better hosting plan.
Re: The Easiest Way To Clean Your Wordpress Database. by mohammad11: 8:33am On Apr 30, 2016
Good topic @OP
Re: The Easiest Way To Clean Your Wordpress Database. by mohammad11: 8:33am On Apr 30, 2016
Good topic @OP
Re: The Easiest Way To Clean Your Wordpress Database. by emillionaire: 9:23am On Apr 30, 2016
nice
Re: The Easiest Way To Clean Your Wordpress Database. by Boldtrust(m): 9:49am On Apr 30, 2016
Bigajeff:
pls guru in the house, any WordPress plugin to resolve "resource limit reached error error message" on unlimited band with and space hosting plan
This problem is not from WordPress, it's from the host. Please register for cloud flaring and activate it in the domain name. It takes care of certain limited resources issues. However, you have to identify which of the resources you are having a problem with, in that case we can narrow down the solutions for you.
Re: The Easiest Way To Clean Your Wordpress Database. by Kennycyphers(m): 4:51pm On Apr 30, 2016
NICE POST
Re: The Easiest Way To Clean Your Wordpress Database. by hostkobo(m): 6:07pm On Apr 30, 2016
Bigajeff:
pls guru in the house, any WordPress plugin to resolve "resource limit reached error error message" on unlimited band with and space hosting plan

it just means your website does not have enough bandwidth / memory to serve the page requested.

What is your subscribed packages' bandwidth capacity?

regards
HK
Re: The Easiest Way To Clean Your Wordpress Database. by Emeka71(m): 2:41am On May 01, 2016
Boldtrust:
This problem is not from WordPress, it's from the host. Please register for cloud flaring and activate it in the domain name. It takes care of certain limited resources issues. However, you have to identify which of the resources you are having a problem with, in that case we can narrow down the solutions for you.
Is the cleaning process applicable to those on the free hosted W[color=#000000]ordPress?[/color]
Re: The Easiest Way To Clean Your Wordpress Database. by Akinduyo2(m): 10:34pm On May 27, 2018
Hi guys, I'm running a promo for all bloggers. Get a customized blogger template at 2500 naira.Why is it so cheap? because, I want to attract customers before raising it high. contact me on akinduyoeniola17@yahoo.com all you just have to do is to tell me how you want it to look like. hurry up, this promo is ending on the 30th of june. you pay after service. trust me. benefits: seo optimized mobile view different colors ads friendly template set up support. visit: www.guruscoach.com.ng

(1) (Reply)

12 Things That Will Kill Your Blog Post Every Time Blogging / Checkout Our New Post / Learn How To Build Websites And Make Money

(Go Up)

Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health
religion celebs tv-movies music-radio literature webmasters programming techmarket

Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10)

Nairaland - Copyright © 2005 - 2019 Oluwaseun Osewa. All rights reserved. See How To Advertise. 94
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.