{"id":25046,"date":"2021-06-02T17:00:47","date_gmt":"2021-06-02T15:00:47","guid":{"rendered":"https:\/\/qodeinteractive.com\/magazine\/?p=25046"},"modified":"2021-06-01T12:52:04","modified_gmt":"2021-06-01T10:52:04","slug":"wordpress-delete-all-comments","status":"publish","type":"post","link":"https:\/\/qodeinteractive.com\/magazine\/wordpress-delete-all-comments\/","title":{"rendered":"How to Easily Bulk Delete All WordPress Comments"},"content":{"rendered":"<div class=\"wpb-content-wrapper\"><p>[vc_row][vc_column][vc_column_text]Comments are a great tool for interacting with your audience and getting their feedback. Comments have been a part of WordPress for a long time and they are present across a vast number of websites. However, allowing comments on your website attracts spammers, which are a headache for every website owner. Even with the best anti-spam plugins protecting your website, spammy comments can accumulate. Then, it&#8217;s easier to simply delete all the comments you have on your WordPress website to deal with this problem.<br \/>\n[\/vc_column_text][vc_empty_space height=&#8221;28px&#8221;][vc_column_text]However, if you\u2019ve been running your website for a while, you might have accumulated a great deal of WordPress comments. As such, deleting all of them manually, one at a time, would require a lot of effort and time to accomplish. Then it becomes a priority to find a quick solution for bulk deleting comments in those kinds of situations. In this article, we\u2019ll take a look at how your WordPress site could benefit if you delete all comments and we\u2019ll explore several ways of doing so:<br \/>\n[\/vc_column_text][vc_empty_space height=&#8221;22px&#8221;]<ul class=\"qodef-unordered-list-item qodef-toc\">\n    <li>\n\t        <div class=\"qodef-ul-title-holder\">\n            <span class=\"qodef-ul-title-content\"><a href=\"#using-the-wordpress-dashboard-options\">Using the WordPress dashboard options<\/a><\/span>        <\/div>\n            <\/li>\n<\/ul>[vc_empty_space height=&#8221;5px&#8221;]<ul class=\"qodef-unordered-list-item qodef-toc\">\n    <li>\n\t        <div class=\"qodef-ul-title-holder\">\n            <span class=\"qodef-ul-title-content\"><a href=\"#using-wordpress-plugins\">Using WordPress plugins<\/a><\/span>        <\/div>\n            <\/li>\n<\/ul>[vc_empty_space height=&#8221;5px&#8221;]<ul class=\"qodef-unordered-list-item qodef-toc\">\n    <li>\n\t        <div class=\"qodef-ul-title-holder\">\n            <span class=\"qodef-ul-title-content\"><a href=\"#using-phpmyadmin\">Using phpMyAdmin<\/a><\/span>        <\/div>\n            <\/li>\n<\/ul>[vc_empty_space height=&#8221;68px&#8221;][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]<\/p>\n<h2 class=\"qodef-h4\">Why you may need to bulk delete all WordPress comments<\/h2>\n<p>[\/vc_column_text][vc_column_text]Despite their usefulness, you need to <a href=\"https:\/\/qodeinteractive.com\/magazine\/how-to-moderate-wordpress-comments\/\">moderate your comments<\/a> if you want them to have a positive impact on your website and its content. But, moderating comments properly can cause headaches, particularly if you attract a lot of spam, malicious links, or promotions. And if your site tackles any controversial topics, there could be a lot of inappropriate and offensive comments, as well. All of it gives a bad impression of your website to new visitors.[\/vc_column_text][vc_empty_space height=&#8221;28px&#8221;][vc_column_text]To deal with all of that, webmasters use different measures, such as deleting some comments or <a href=\"https:\/\/qodeinteractive.com\/magazine\/disable-comments-wordpress\/\">disabling commenting<\/a> altogether. And, if the amount of unwanted comments is too large, you can delete them all and start over with a clean slate.[\/vc_column_text][vc_empty_space height=&#8221;28px&#8221;][vc_column_text]Additionally, if you\u2019ve added a lot of dummy comments during the development stage of your website, you should remove them all before launching your site. Inserting dummy content, such as comments, during website development will help you see how a certain functionality looks and works on your site. However, if you plan on making your website public by <a href=\"https:\/\/qodeinteractive.com\/magazine\/moving-wordpress-localhost-to-live-server\/\">migrating to a live server<\/a> when it\u2019s done, you will need to delete those dummy comments. Otherwise, they will hurt your website\u2019s SEO and confuse your readers.[\/vc_column_text][vc_empty_space height=&#8221;28px&#8221;][vc_column_text]If you find yourself in a situation similar to one of these, you should consider cleaning up your WordPress website by deleting all comments.<br \/>\n[\/vc_column_text][vc_empty_space height=&#8221;80px&#8221;][vc_widget_sidebar sidebar_id=&#8221;new-top-picks-banner&#8221;][vc_empty_space height=&#8221;80px&#8221;][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]<\/p>\n<h2 class=\"qodef-h4\">How to bulk delete all WordPress comments<\/h2>\n<p>[\/vc_column_text][vc_column_text]Now that you have a clearer picture of how deleting all your WordPress comments can benefit you, let\u2019s examine how you can do so. In the following sections, we will explain three possible approaches for deleting all WordPress comments. We suggest you go through all three and consider each before deciding which one suits you best.<br \/>\n[\/vc_column_text][vc_empty_space height=&#8221;28px&#8221;][vc_column_text]However, deleting comments is an irreversible action, therefore you should <a href=\"https:\/\/qodeinteractive.com\/magazine\/how-to-manually-backup-wordpress-website\/\">make a website backup<\/a> in case you change your mind later on. This is also an important safety precaution against any unforeseen issues during the process as well as a recommended practice for all site owners. Once you\u2019ve done that, you can proceed as outlined below.[\/vc_column_text][vc_empty_space height=&#8221;72px&#8221;][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]<\/p>\n<h3 class=\"qodef-h5\"><a id=\"using-the-wordpress-dashboard-options\"><\/a>Using the WordPress dashboard options<\/h3>\n<p>[\/vc_column_text][vc_column_text]The most obvious way of bulk removing WordPress comments is by using the options for bulk removal provided within the WordPress dashboard. However, this method is most suitable for users who have a lower number of comments on their website. There is a way to increase the number of comments you can bulk delete at once, and we\u2019ll show you how that\u2019s done. But, if your website has thousands of comments, you should consider using one of the other two methods we will discuss later, instead.[\/vc_column_text][vc_empty_space height=&#8221;28px&#8221;][vc_column_text]To remove all comments using the dashboard options, <strong>navigate to the <em>Comments<\/em> section<\/strong>. Then, <strong>make sure you\u2019re located within the <em>All<\/em> tab<\/strong>, which displays all comments from the categories: Mine, Pending and Approved.<strong> Tick the checkbox next to the <em>Author<\/em> label<\/strong> near the top of your screen. This will select all the comments displayed in the list on your screen.[\/vc_column_text][vc_empty_space height=&#8221;50px&#8221;]<div class=\"qodef-single-image-holder   qodef-has-border \">\n    <div class=\"qodef-si-inner\" >\n                                    <img loading=\"lazy\" decoding=\"async\" width=\"969\" height=\"518\" src=\"https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/All-Comments.jpg\" class=\"attachment-full size-full\" alt=\"All Comments\" srcset=\"https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/All-Comments.jpg 969w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/All-Comments-300x160.jpg 300w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/All-Comments-768x411.jpg 768w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/All-Comments-620x331.jpg 620w\" sizes=\"auto, (max-width: 969px) 100vw, 969px\" \/>                        <\/div>\n<\/div>[vc_empty_space height=&#8221;38px&#8221;][vc_column_text]<strong>By default, the number of comments that are displayed per page is 20.<\/strong> If your site has more than that, you will get page navigation links below the comments list. This means that <strong>you\u2019ll have to repeat the same steps for each page of comments in order to delete them.<\/strong>[\/vc_column_text][vc_empty_space height=&#8221;28px&#8221;][vc_column_text]<strong>As this can be quite tedious, you can increase the default value of 20 to a higher number, which will speed up the process. However, keep in mind that displaying a very large number of comments can hurt your website\u2019s performance or even cause it to crash. Therefore, you should try to aim for a number that shortens the deletion process, but doesn\u2019t hurt your website performance too much.<\/strong>[\/vc_column_text][vc_empty_space height=&#8221;28px&#8221;][vc_column_text]To increase the number of visible comments, start by <strong>clicking on <em>Screen Options<\/em><\/strong> in the top right corner of the <em>Comments<\/em> section. This will open a subset of options that were previously hidden. Then, to increase the default number of comments that are displayed per page, <strong>insert the new value in the <em>Number of items per page<\/em> field<\/strong> and <strong>click on the <em>Apply<\/em> button<\/strong> below.[\/vc_column_text][vc_empty_space height=&#8221;50px&#8221;]<div class=\"qodef-single-image-holder   qodef-has-border \">\n    <div class=\"qodef-si-inner\" >\n                                    <img loading=\"lazy\" decoding=\"async\" width=\"969\" height=\"518\" src=\"https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Comments-Number-of-Items.jpg\" class=\"attachment-full size-full\" alt=\"Comments Number of Items\" srcset=\"https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Comments-Number-of-Items.jpg 969w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Comments-Number-of-Items-300x160.jpg 300w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Comments-Number-of-Items-768x411.jpg 768w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Comments-Number-of-Items-620x331.jpg 620w\" sizes=\"auto, (max-width: 969px) 100vw, 969px\" \/>                        <\/div>\n<\/div>[vc_empty_space height=&#8221;38px&#8221;][vc_column_text]Once you\u2019ve increased the number of comments that can be displayed on each page, you should proceed to move the comments to the Trash. To do so, make sure all the comments are selected, then <strong>click on the dropdown where it says <em>Bulk actions<\/em><\/strong>. From there, you need to <strong>select the <em>Move to Trash<\/em> option<\/strong>. Then, <strong>click on the <em>Apply<\/em> button next to the dropdown<\/strong> to bulk apply your action.[\/vc_column_text][vc_empty_space height=&#8221;50px&#8221;]<div class=\"qodef-single-image-holder   qodef-has-border \">\n    <div class=\"qodef-si-inner\" >\n                                    <img loading=\"lazy\" decoding=\"async\" width=\"969\" height=\"518\" src=\"https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Move-All-Comments-to-Trash.jpg\" class=\"attachment-full size-full\" alt=\"Move All Comments to Trash\" srcset=\"https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Move-All-Comments-to-Trash.jpg 969w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Move-All-Comments-to-Trash-300x160.jpg 300w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Move-All-Comments-to-Trash-768x411.jpg 768w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Move-All-Comments-to-Trash-620x331.jpg 620w\" sizes=\"auto, (max-width: 969px) 100vw, 969px\" \/>                        <\/div>\n<\/div>[vc_empty_space height=&#8221;38px&#8221;][vc_column_text]Moving all your comments to Trash means that they will be located within the last two tabs\u2014Spam and Trash. Therefore, you only need to empty those two tabs to finish the process of permanently removing all WordPress comments. To empty the Trash tab, <strong>click on it to open<\/strong> and then <strong>press the <em>Empty Trash<\/em> button<\/strong> found within.[\/vc_column_text][vc_empty_space height=&#8221;50px&#8221;]<div class=\"qodef-single-image-holder   qodef-has-border \">\n    <div class=\"qodef-si-inner\" >\n                                    <img loading=\"lazy\" decoding=\"async\" width=\"969\" height=\"518\" src=\"https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Empty-Trash.jpg\" class=\"attachment-full size-full\" alt=\"Empty Trash\" srcset=\"https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Empty-Trash.jpg 969w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Empty-Trash-300x160.jpg 300w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Empty-Trash-768x411.jpg 768w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Empty-Trash-620x331.jpg 620w\" sizes=\"auto, (max-width: 969px) 100vw, 969px\" \/>                        <\/div>\n<\/div>[vc_empty_space height=&#8221;38px&#8221;][vc_column_text]Depending on the number of comments, you might need to <strong>wait a bit<\/strong> for the action to be completed. When it\u2019s done, you will see a success message near the top of your screen.[\/vc_column_text][vc_empty_space height=&#8221;50px&#8221;]<div class=\"qodef-single-image-holder   qodef-has-border \">\n    <div class=\"qodef-si-inner\" >\n                                    <img loading=\"lazy\" decoding=\"async\" width=\"969\" height=\"518\" src=\"https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Comments-Deleted.jpg\" class=\"attachment-full size-full\" alt=\"Comments Deleted\" srcset=\"https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Comments-Deleted.jpg 969w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Comments-Deleted-300x160.jpg 300w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Comments-Deleted-768x411.jpg 768w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Comments-Deleted-620x331.jpg 620w\" sizes=\"auto, (max-width: 969px) 100vw, 969px\" \/>                        <\/div>\n<\/div>[vc_empty_space height=&#8221;38px&#8221;][vc_column_text]Afterward, <strong>navigate to the Spam tab<\/strong> and <strong>press the<em> Empty Spam<\/em> button<\/strong> to remove the remaining comments.[\/vc_column_text][vc_empty_space height=&#8221;50px&#8221;]<div class=\"qodef-single-image-holder   qodef-has-border \">\n    <div class=\"qodef-si-inner\" >\n                                    <img loading=\"lazy\" decoding=\"async\" width=\"969\" height=\"518\" src=\"https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Empty-Spam.jpg\" class=\"attachment-full size-full\" alt=\"Empty Spam\" srcset=\"https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Empty-Spam.jpg 969w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Empty-Spam-300x160.jpg 300w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Empty-Spam-768x411.jpg 768w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Empty-Spam-620x331.jpg 620w\" sizes=\"auto, (max-width: 969px) 100vw, 969px\" \/>                        <\/div>\n<\/div>[vc_empty_space height=&#8221;38px&#8221;][vc_column_text]Similarly, a success message will be shown after it is done.[\/vc_column_text][vc_empty_space height=&#8221;50px&#8221;]<div class=\"qodef-single-image-holder   qodef-has-border \">\n    <div class=\"qodef-si-inner\" >\n                                    <img loading=\"lazy\" decoding=\"async\" width=\"969\" height=\"518\" src=\"https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Spam-Comments-Deleted.jpg\" class=\"attachment-full size-full\" alt=\"Spam Comments Deleted\" srcset=\"https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Spam-Comments-Deleted.jpg 969w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Spam-Comments-Deleted-300x160.jpg 300w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Spam-Comments-Deleted-768x411.jpg 768w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Spam-Comments-Deleted-620x331.jpg 620w\" sizes=\"auto, (max-width: 969px) 100vw, 969px\" \/>                        <\/div>\n<\/div>[vc_empty_space height=&#8221;38px&#8221;][vc_column_text]Once again, we have to reiterate that <strong>the previously mentioned actions have to be repeated for all comments, in case your comments pagination has two or more pages.<\/strong> By performing those actions, you will remove all WordPress comments and their relational metadata. We will touch more on this subject in the following two methods of bulk deleting WordPress comments.[\/vc_column_text][vc_empty_space height=&#8221;72px&#8221;][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]<\/p>\n<h3 class=\"qodef-h5\"><a id=\"using-wordpress-plugins\"><\/a>Using a WordPress plugin<\/h3>\n<p>[\/vc_column_text][vc_column_text]Given the large selection of different WordPress plugins, finding one for deleting WordPress comments is quite easy. You can either look for plugins that are made for altering comments specifically or ones that alter the database in general. When looking at the latter, make sure to pick a plugin that enables you to delete targeted data. This can be through an intuitive set of options or by allowing you to target specific database tables. However, working with the database is more suitable for advanced WordPress users, and if you opt for this approach, you should <a href=\"https:\/\/qodeinteractive.com\/magazine\/how-to-backup-wordpress-database\/\">make a database backup first<\/a>. Then you can edit the wp_comments and wp_commentmeta database tables, where the comments and comment metadata are stored without worry.[\/vc_column_text][vc_empty_space height=&#8221;28px&#8221;][vc_column_text]The plugin which we opted to use for this article falls under the database-altering category and is called <a href=\"https:\/\/wordpress.org\/plugins\/wp-bulk-delete\/\" target=\"_blank\" rel=\"noopener\">WP Bulk Delete<\/a>. The plugin is perfect for removing database bloat in general or removing one type of data in particular. It allows you to bulk delete posts, comments, users, terms, and taxonomies, as well as any orphaned metadata from your database. While the option to delete the same data based on filters and conditions is reserved for the premium version of the plugin, you can still use the free version on your WordPress site to delete all comments. We will explain how to do this below.[\/vc_column_text][vc_empty_space height=&#8221;28px&#8221;][vc_column_text]After <a href=\"https:\/\/qodeinteractive.com\/magazine\/how-to-install-a-wordpress-plugin\/\">installing the plugin<\/a>,<strong> navigate to WP Bulk Delete &gt; Delete Comments<\/strong>. In this section, you will be able to review comment-related options, although some will be available only with the premium version of the plugin.[\/vc_column_text][vc_empty_space height=&#8221;28px&#8221;][vc_column_text]To delete all comments from your website,<strong> tick the checkbox next to all types of comments in the <em>Comment Status<\/em> subsection<\/strong>. Then, <strong>click on the <em>Delete Comments<\/em> button<\/strong> below.[\/vc_column_text][vc_empty_space height=&#8221;50px&#8221;]<div class=\"qodef-single-image-holder   qodef-has-border \">\n    <div class=\"qodef-si-inner\" >\n                                    <img loading=\"lazy\" decoding=\"async\" width=\"969\" height=\"633\" src=\"https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/WP-Bulk-Delete-Comments.jpg\" class=\"attachment-full size-full\" alt=\"WP Bulk Delete Comments\" srcset=\"https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/WP-Bulk-Delete-Comments.jpg 969w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/WP-Bulk-Delete-Comments-300x196.jpg 300w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/WP-Bulk-Delete-Comments-768x502.jpg 768w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/WP-Bulk-Delete-Comments-620x405.jpg 620w\" sizes=\"auto, (max-width: 969px) 100vw, 969px\" \/>                        <\/div>\n<\/div>[vc_empty_space height=&#8221;38px&#8221;][vc_column_text]Afterward, you will be prompted to confirm your choice. If are sure that you want to delete all comments from your website, <strong>click on the <em>Ok<\/em> button<\/strong> to proceed.[\/vc_column_text][vc_empty_space height=&#8221;50px&#8221;]<div class=\"qodef-single-image-holder   qodef-has-border \">\n    <div class=\"qodef-si-inner\" >\n                                    <img loading=\"lazy\" decoding=\"async\" width=\"969\" height=\"518\" src=\"https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Delete-Comments-Confirm.jpg\" class=\"attachment-full size-full\" alt=\"Delete Comments Confirm\" srcset=\"https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Delete-Comments-Confirm.jpg 969w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Delete-Comments-Confirm-300x160.jpg 300w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Delete-Comments-Confirm-768x411.jpg 768w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Delete-Comments-Confirm-620x331.jpg 620w\" sizes=\"auto, (max-width: 969px) 100vw, 969px\" \/>                        <\/div>\n<\/div>[vc_empty_space height=&#8221;38px&#8221;][vc_column_text]Shortly after, you will see a success message similar to the one shown below, specifying how many comments were deleted.<br \/>\n[\/vc_column_text][vc_empty_space height=&#8221;50px&#8221;]<div class=\"qodef-single-image-holder   qodef-has-border \">\n    <div class=\"qodef-si-inner\" >\n                                    <img loading=\"lazy\" decoding=\"async\" width=\"969\" height=\"518\" src=\"https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Plugin-Comments-Deleted.jpg\" class=\"attachment-full size-full\" alt=\"Plugin Comments Deleted\" srcset=\"https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Plugin-Comments-Deleted.jpg 969w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Plugin-Comments-Deleted-300x160.jpg 300w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Plugin-Comments-Deleted-768x411.jpg 768w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Plugin-Comments-Deleted-620x331.jpg 620w\" sizes=\"auto, (max-width: 969px) 100vw, 969px\" \/>                        <\/div>\n<\/div>[vc_empty_space height=&#8221;38px&#8221;][vc_column_text]However, this might not be enough to thoroughly remove all traces of the comments from your site. Since a WordPress website relies on a MySQL database, which is a relational database, some data pointing to those comments might still be present within the database. Removing the comments makes this data obsolete, and it should be removed to optimize your database storage space. The technical term for this kind of data is <em>orphaned<\/em>, and you can find its mention in various WordPress plugins that have database-optimizing capabilities. The plugin we chose to showcase in this article can help you with this as well.[\/vc_column_text][vc_empty_space height=&#8221;28px&#8221;][vc_column_text]To delete any orphaned data, <strong>navigate to WP Bulk Delete &gt; Delete Meta Fields<\/strong> and <strong>make sure you\u2019re in the <em>Cleanup<\/em> tab<\/strong>. We will focus only on the orphaned metadata in this article, but it might be helpful to know that this plugin also offers the possibility to delete any duplicated post, user, or term metadata.[\/vc_column_text][vc_empty_space height=&#8221;28px&#8221;][vc_column_text]<strong>Tick the checkbox next to any orphaned metadata option that has more than 0 rows you can delete.<\/strong> In most cases, since you have deleted the comments, you will only need to tick the checkbox next to <em>Orphaned Comment Meta<\/em>. However, you might need to tick some of the other options as well, to include all data concerning comments you deleted. Let us explain why this happens.[\/vc_column_text][vc_empty_space height=&#8221;28px&#8221;][vc_column_text]Some WordPress plugins or themes may place comment-like content inside the wp_comments and wp_commentmeta tables. This includes reviews and customer notes, for example. By removing the comments, we deleted all types of entries within the wp_comments table, which encompassed those added entries as well. With that, we created orphaned term metadata within some other tables that are used by your theme or plugins and that reference the added data.[\/vc_column_text][vc_empty_space height=&#8221;28px&#8221;][vc_column_text]Therefore,<strong> to completely remove the orphaned metadata, you should remove the orphaned term metadata as well.<\/strong> In the case you didn\u2019t want to delete that added data, you can <a href=\"https:\/\/qodeinteractive.com\/magazine\/manually-restore-wordpress-website-backup\/\">restore the website backup<\/a> you made and then bulk delete all comments from the WordPress dashboard. With that being said, let us explain the remaining part of deleting the orphaned metadata.[\/vc_column_text][vc_empty_space height=&#8221;28px&#8221;][vc_column_text]Once you\u2019ve ticked the appropriate options, you can <strong>click on the <em>Run Cleanup<\/em> button<\/strong> below.[\/vc_column_text][vc_empty_space height=&#8221;50px&#8221;]<div class=\"qodef-single-image-holder   qodef-has-border \">\n    <div class=\"qodef-si-inner\" >\n                                    <img loading=\"lazy\" decoding=\"async\" width=\"969\" height=\"561\" src=\"https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Delete-Meta-Fields.jpg\" class=\"attachment-full size-full\" alt=\"Delete Meta Fields\" srcset=\"https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Delete-Meta-Fields.jpg 969w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Delete-Meta-Fields-300x174.jpg 300w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Delete-Meta-Fields-768x445.jpg 768w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Delete-Meta-Fields-620x359.jpg 620w\" sizes=\"auto, (max-width: 969px) 100vw, 969px\" \/>                        <\/div>\n<\/div>[vc_empty_space height=&#8221;38px&#8221;][vc_column_text]In this case, you won\u2019t be prompted to confirm your choice. Instead, it will be executed and, shortly after, you will see a success message similar to the one shown below.<br \/>\n[\/vc_column_text][vc_empty_space height=&#8221;50px&#8221;]<div class=\"qodef-single-image-holder   qodef-has-border \">\n    <div class=\"qodef-si-inner\" >\n                                    <img loading=\"lazy\" decoding=\"async\" width=\"969\" height=\"518\" src=\"https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Meta-Deleted.jpg\" class=\"attachment-full size-full\" alt=\"Meta Deleted\" srcset=\"https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Meta-Deleted.jpg 969w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Meta-Deleted-300x160.jpg 300w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Meta-Deleted-768x411.jpg 768w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/Meta-Deleted-620x331.jpg 620w\" sizes=\"auto, (max-width: 969px) 100vw, 969px\" \/>                        <\/div>\n<\/div>[vc_empty_space height=&#8221;82px&#8221;][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]<\/p>\n<h3 class=\"qodef-h5\"><a id=\"using-phpmyadmin\"><\/a>Using phpMyAdmin<\/h3>\n<p>[\/vc_column_text][vc_column_text]Whereas the previous two methods are suitable for a wide range of users, this last one is geared towards more advanced WordPress users. This method requires you to be somewhat familiar with the structure of a common WordPress database. However, it will let you remove all comments and comment metadata very quickly. This is achieved by deleting all the rows from the wp_comments and wp_commentmeta database tables.<br \/>\n[\/vc_column_text][vc_empty_space height=&#8221;28px&#8221;][vc_column_text]As we mentioned in the previous section, some themes and plugins can insert data similar to comments inside those two tables. This data could represent things like reviews and notes, for example. And it will be deleted once you empty the two database tables in question.<br \/>\n[\/vc_column_text][vc_empty_space height=&#8221;28px&#8221;][vc_column_text]With that being said, to delete the contents of those two database tables, you will need to access the phpMyAdmin application. This can be done within cPanel or, if you\u2019re working on localhost, by accessing the <em>your-server-name\/phpmyadmin<\/em> address. We assume your site is already live, so we will focus on showing you the former.[\/vc_column_text][vc_empty_space height=&#8221;28px&#8221;][vc_column_text]After logging into cPanel, <strong>click on the <em>phpMyAdmin<\/em> option<\/strong> found within the <em>Databases<\/em> section.[\/vc_column_text][vc_empty_space height=&#8221;50px&#8221;]<div class=\"qodef-single-image-holder   qodef-has-border \">\n    <div class=\"qodef-si-inner\" >\n                                    <img loading=\"lazy\" decoding=\"async\" width=\"969\" height=\"518\" src=\"https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/04\/phpMyAdmin.jpg\" class=\"attachment-full size-full\" alt=\"phpMyAdmin\" srcset=\"https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/04\/phpMyAdmin.jpg 969w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/04\/phpMyAdmin-300x160.jpg 300w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/04\/phpMyAdmin-768x411.jpg 768w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/04\/phpMyAdmin-620x331.jpg 620w\" sizes=\"auto, (max-width: 969px) 100vw, 969px\" \/>                        <\/div>\n<\/div>[vc_empty_space height=&#8221;38px&#8221;][vc_column_text]The phpMyAdmin application will open momentarily. Within it,<strong> locate the database of your website<\/strong> and <strong>click once to access it.<\/strong>[\/vc_column_text][vc_empty_space height=&#8221;50px&#8221;]<div class=\"qodef-single-image-holder   qodef-has-border \">\n    <div class=\"qodef-si-inner\" >\n                                    <img loading=\"lazy\" decoding=\"async\" width=\"969\" height=\"653\" src=\"https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/phpMyAdmin-Test.jpg\" class=\"attachment-full size-full\" alt=\"phpMyAdmin Test\" srcset=\"https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/phpMyAdmin-Test.jpg 969w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/phpMyAdmin-Test-300x202.jpg 300w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/phpMyAdmin-Test-768x518.jpg 768w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/phpMyAdmin-Test-620x418.jpg 620w\" sizes=\"auto, (max-width: 969px) 100vw, 969px\" \/>                        <\/div>\n<\/div>[vc_empty_space height=&#8221;38px&#8221;][vc_column_text]If you aren\u2019t sure what is the name of your database, you will need to inspect the wp-config.php file. More precisely, you need to look for the following line of code, which will have your database name in it:<br \/>\n[\/vc_column_text][vc_empty_space height=&#8221;28px&#8221;][vc_column_text]<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">define( \u2018DB_NAME\u2019, \u2018database_name_here\u2019 );<\/pre>\n<p>[\/vc_column_text][vc_empty_space height=&#8221;28px&#8221;][vc_column_text]For more details about the content of this file, you can take a look at our article on <a href=\"https:\/\/qodeinteractive.com\/magazine\/how-to-edit-wp-config-file\/\">working with the wp-config.php file<\/a>. Once you\u2019ve figured out the name of your database, you can proceed with the steps.[\/vc_column_text][vc_empty_space height=&#8221;28px&#8221;][vc_column_text]Next, <strong>locate<\/strong> and <strong>select the comments and commentmeta tables<\/strong>. If you haven\u2019t <a href=\"https:\/\/qodeinteractive.com\/magazine\/how-to-change-wordpress-database-prefix\/\">changed the default WordPress prefix<\/a>, they will be called wp_comments and wp_commentmeta, respectively. Otherwise, they will have the database prefix you have set. Then, <strong>locate the <em>With selected<\/em> dropdown menu<\/strong> at the bottom of the screen and <strong>select the <em>Empty<\/em> option from it<\/strong>.[\/vc_column_text][vc_empty_space height=&#8221;50px&#8221;]<div class=\"qodef-single-image-holder   qodef-has-border \">\n    <div class=\"qodef-si-inner\" >\n                                    <img loading=\"lazy\" decoding=\"async\" width=\"969\" height=\"621\" src=\"https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/phpMyAdmin-Empty-Comments.jpg\" class=\"attachment-full size-full\" alt=\"phpMyAdmin Empty Comments\" srcset=\"https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/phpMyAdmin-Empty-Comments.jpg 969w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/phpMyAdmin-Empty-Comments-300x192.jpg 300w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/phpMyAdmin-Empty-Comments-768x492.jpg 768w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/phpMyAdmin-Empty-Comments-620x397.jpg 620w\" sizes=\"auto, (max-width: 969px) 100vw, 969px\" \/>                        <\/div>\n<\/div>[vc_empty_space height=&#8221;38px&#8221;][vc_column_text]You will be prompted with a warning, asking you to confirm the choice that you made. The option will be replaced with the following two queries which are equivalent to the option you chose:<br \/>\n[\/vc_column_text][vc_empty_space height=&#8221;28px&#8221;][vc_column_text]<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">TRUNCATE `wp_commentmeta`;\r\nTRUNCATE `wp_comments`;<\/pre>\n<p>[\/vc_column_text][vc_empty_space height=&#8221;28px&#8221;][vc_column_text]If you are sure that you want to empty those two tables, i.e. delete all the comments and comment metadata, <strong>click on the <em>Yes<\/em> button.<\/strong>[\/vc_column_text][vc_empty_space height=&#8221;50px&#8221;]<div class=\"qodef-single-image-holder   qodef-has-border \">\n    <div class=\"qodef-si-inner\" >\n                                    <img loading=\"lazy\" decoding=\"async\" width=\"969\" height=\"518\" src=\"https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/phpMyAdmin-Confirm.jpg\" class=\"attachment-full size-full\" alt=\"phpMyAdmin Confirm\" srcset=\"https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/phpMyAdmin-Confirm.jpg 969w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/phpMyAdmin-Confirm-300x160.jpg 300w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/phpMyAdmin-Confirm-768x411.jpg 768w, https:\/\/qodeinteractive.com\/magazine\/wp-content\/uploads\/2021\/06\/phpMyAdmin-Confirm-620x331.jpg 620w\" sizes=\"auto, (max-width: 969px) 100vw, 969px\" \/>                        <\/div>\n<\/div>[vc_empty_space height=&#8221;38px&#8221;][vc_column_text]Depending on the number of comments you had on your website, all the comments data should be deleted shortly after.<br \/>\n[\/vc_column_text][vc_empty_space height=&#8221;68px&#8221;][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]<\/p>\n<h2 class=\"qodef-h4\">Final Thoughts<\/h2>\n<p>[\/vc_column_text][vc_column_text]WordPress comments are a great way of fostering relationships with your visitors. They can let your readers interact and your customers build a loyal base. However, comments can also be a gateway for a lot of spam. It is up to every WordPress webmaster to decide whether they want these comments on their website, and to remove them quickly before the spamming issue becomes severe. However, you can clear your WordPress site and delete all comments quickly and easily by following any of the three methods we described in this article. And, to ensure no harm comes from this process, we highly recommend creating a backup before you start working.<br \/>\n[\/vc_column_text][\/vc_column][\/vc_row]<\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Spammy comments are a norm nowadays, but you shouldn&#8217;t have to put up with them\u2014unburden your WordPress site and delete all comments.<\/p>\n","protected":false},"author":11229,"featured_media":25084,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[4,13],"class_list":["post-25046","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials","tag-tips","tag-wordpress"],"_links":{"self":[{"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/posts\/25046","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/users\/11229"}],"replies":[{"embeddable":true,"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/comments?post=25046"}],"version-history":[{"count":0,"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/posts\/25046\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/media\/25084"}],"wp:attachment":[{"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/media?parent=25046"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/categories?post=25046"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/tags?post=25046"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}