{"id":41763,"date":"2024-11-24T14:43:30","date_gmt":"2024-11-24T12:43:30","guid":{"rendered":"https:\/\/coma.lv\/2024\/11\/24\/how-to-delete-all-wordpress-comments-in-one-go\/"},"modified":"2024-11-24T14:43:30","modified_gmt":"2024-11-24T12:43:30","slug":"how-to-delete-all-wordpress-comments-in-one-go","status":"publish","type":"post","link":"https:\/\/coma.lv\/en\/2024\/11\/24\/how-to-delete-all-wordpress-comments-in-one-go\/","title":{"rendered":"How to Delete All WordPress Comments in One Go"},"content":{"rendered":"\n

It is rare, but in some cases a site owner may decide to delete all the comments from their site. In this article we will show how you can do this in one go.<\/p>\n

Before You Delete All Comments in WordPress<\/h2>\n

There are many scenarios in which a user may really need to delete all the comments from a site. For example, if your site is full of empty comments created to test functionality. First of all, you need to back up your site. Deleting comments is an irreversible action and you will not be able to restore everything once the comments are deleted. That is exactly why you need to make a backup.<\/p>\n

Method One: Delete All Comments on a WordPress Site with a Plugin<\/h2>\n

First you need to install and activate the WP Bulk Delete<\/a> plugin. After activating it, go to WP Bulk Delete in the dashboard menu and choose Delete Comments. Select the types of comments to delete and click the Delete Comments button.<\/p>\n

\"WordPress\"<\/p>\n

Now you can go to the comments page and you will see that all comments have been removed from the site.<\/p>\n

Method Two: Delete All Comments on a WordPress Site with phpMyAdmin<\/h2>\n

You can also quickly delete all WordPress comments using MySQL or phpMyAdmin<\/a>. This method is recommended for more advanced users. Log in to your hosting’s cPanel and, under the databases area, click phpMyAdmin.<\/p>\n

\"WordPress\"<\/p>\n

Inside you need to find your WordPress database. You will see a page like this with a bunch of database tables.<\/p>\n

\"WordPress\"<\/p>\n

Tick the box next to the wpprefix_comments and wpprefix_commentmeta tables. The name of the comments table may differ depending on the prefix you chose when installing WordPress. After selecting the comments tables, find the With selected: drop-down menu below the list of tables and choose Empty from the drop-down menu. phpMyAdmin will now show a warning asking whether you really want to empty these tables.<\/p>\n

\"WordPress\"<\/p>\n

Click the yes button and this will delete all WordPress comments from your database. You can also delete all WordPress comments using the MySQL console (command line). Just log in to it and enter the following command:
\n
\nDELETE FROM wp_commentmeta;
\nDELETE FROM wp_comments;<\/strong><\/p>\n

\n

Our specialization is WordPress website development and maintenance. Contact us for a free consultation \u2014 vadim@coma.lv<\/a>, +371 29394520<\/a><\/em><\/p>\n

\n","protected":false},"excerpt":{"rendered":"

It is rare, but in some cases a site owner may decide to delete all the comments from their site. In this article we will show how you can do this in one go. Before You Delete All Comments in WordPress There are many scenarios in which a user may really need to delete all […]<\/p>\n","protected":false},"author":1,"featured_media":37987,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1225,1409,1407],"tags":[],"class_list":["post-41763","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-wordpress","category-plugins","category-tutorials"],"_links":{"self":[{"href":"https:\/\/coma.lv\/en\/wp-json\/wp\/v2\/posts\/41763","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/coma.lv\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/coma.lv\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/coma.lv\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/coma.lv\/en\/wp-json\/wp\/v2\/comments?post=41763"}],"version-history":[{"count":0,"href":"https:\/\/coma.lv\/en\/wp-json\/wp\/v2\/posts\/41763\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/coma.lv\/en\/wp-json\/wp\/v2\/media\/37987"}],"wp:attachment":[{"href":"https:\/\/coma.lv\/en\/wp-json\/wp\/v2\/media?parent=41763"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/coma.lv\/en\/wp-json\/wp\/v2\/categories?post=41763"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/coma.lv\/en\/wp-json\/wp\/v2\/tags?post=41763"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}