![]()
If you are currently using a setting that has turned off the option of accepting pingbacks, then you may want to use the following code. #Backup buddy automatically cleanup old backups how to#INNER JOIN wp_term taxonomy wtt ON wt.term_id = wtt.term_id WHERE wtt.taxonomy = ‘post_tag’ and wtt.count = 0 Ĭheck out some of our earlier posts if you are unsure about the differences between categories & tags and how to use them. Fortunately, we have a query that will take care of all unused tags, but be sure to check the ones that you do use before running this query: We use the most common ones and stick to those.ĭon’t be surprised if you have completely forgotten about a score of tags that you exist on your website database (thanks to your wild imaginative powers). And now that we post regularly, we hardly ever change tags. When we were new at blogging, we created a few hundred tags thinking we would use them from time to time. Just a word of advice: go through the list once to approve all genuine comments before running this query:ĭELETE FROM wp_comments WHERE comment_approved = ‘0’ #6. This eliminates the need of unnecessarily going through each and every spam comment that you haven’t yet moderated. What About Comments Waiting on Moderation?Īs a WordPress website/blog admin, you have the power to delete all comments that are awaiting moderation. If you are currently using a multi-site installation of WordPress, you may like to try the following query:ĭELETE FROM wp_#_comments WHERE comment_approved = ‘spam’ #5. ![]() The easiest way to manage spam comments on your site is to execute this query:ĭELETE FROM wp_comments WHERE comment_approved = ‘spam’ Monitoring comments is an essential practice that is currently underrated. These include promotional features and unscrupulous backlinks that other sites use to eat their way into your SEO. If you look through your database carefully, you will find tons of spam comments as well. Spam is no longer restricted to your inbox. You can find it all in the wp_postmeta table, and you can run this query to get rid of all superfluous data:ĭELETE FROM wp_postmeta WHERE meta_key = ‘your-meta-keyĪlways remember to replace the last part with the value that has to be cleared out. If you have been using WordPress from a while, you might not be as surprised to know that all your post data is being stored in your website database. After deleting all unused plugins you should start cleaning out post data. #Backup buddy automatically cleanup old backups movie#to the ones familiar with the popular movie franchise), but it is the best way to free up space. Next, go to Installed Plugins and click on Inactive at the top of the screen.Įliminating unused plugins should easily free up a couple of bytes and is the first step towards cleaning up your WordPress database. Go to your admin panel and click on Plugins. You can easily get started by going through your complete list of plugins in your WordPress dashboard. Screen Through the Clutterĭo you remember how yard sales used to work before Craigslist and eBay came along? Just like separating the valuables from trash, you need to pick out the plugins you use and the ones you don’t. #Backup buddy automatically cleanup old backups full#It’s a great plugin that allows you to schedule automatic full or database-only backups, and we highly recommend it. You should definitely check out Backupbuddy from our friends at iThemes. So start by creating copies of important files and create a backup of your entire website. Losing a single system file can mess up your website entirely and can cause you to lose thousands of dollars in revenue. Basic Ground Rulesīefore you take on the massive task of spring-cleaning, you must ensure that your valuables are safe and sound. Therefore, without wasting time, we will tell you how to clean up that database in a few easy steps. However, we are guessing that you have been skimping on the cleaning bit, which is why you are here today. ![]() The trick to maintaining a database is to clean it regularly to prevent the accumulation of unnecessary data. ![]() If your site has been live for a while now, chances are that its database has acquired quite a bit of garbage and is demanding a spring clean. Is your WordPress database a mess? Have you been complaining about it since time immemorial? Well, then your WordPress site might be as bloated as you were after that marvelous Thanksgiving dinner at your mom’s. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |