Just run the following commands in your database
DELETE FROM wp_commentmeta;
DELETE FROM wp_comments;
If you changed the db prefix, the name might be foo_comments / foo_commentmeta or similar.
Related Posts:
- Why is Woocommerce writing in my wp_comment table?
- How to use a different database to list and manage comments in the backend
- Retrieve data from the database to table such as comments in the admin control panel
- SELECT SQL_CALC_FOUND_ROWS with wordpress search
- Counting user’s comments – efficient way?
- phpMyAdmin – Error > Incorrect format parameter?
- Difference between partition key, composite key and clustering key in Cassandra?
- How SID is different from Service name in Oracle tnsnames.ora
- What is a relation in database terminology?
- Why is my database import losing text widget data?
- Does dbDelta delete columns as well?
- Are There Any Plans for WordPress to Support Databases Other Than MySQL?
- Reset Post IDs to less than 64bit integer
- Insert data in database using form
- how can get database name in wordpress?
- Long option names fail silently?
- Upload files – total size limit – WordPress/Contact Form 7
- Relationship between performance and database size
- Why does WordPress rely on an fully qualified site_url with a 15-step plan for moving a site?
- WordPress and automated MySQL backups to a different host
- Scheduling posts in database
- Size article thumbnails and retrieve them directly from database
- Should I be able to run two different “close” code versions of wordpress with the same DB
- Need of separate security plugins for both root and subfolder sites WordPress?
- Escaping / encoding data before insert into a database?
- Get total number of comment of the posts written by an author
- how to store arrays into a database
- Error: SELECT SQL_CALC_FOUND_ROWS
- How can I create a Bible search engine via WordPress? [closed]
- Error establishing a database connection; After importing DB & Theme
- Where are WP_Errors Saved
- Get all images from this database table
- Delete transients in website
- Error establishing database connection – high traffic?
- Bulk-create posts from SQL database
- Populate dropdown from database
- I am switching laptops. I host my WP server through MAMP. I want to transfer [closed]
- wordpress ‘database update required’ loop after update
- Database Table for customer user
- Is there a solution to auto-post data to a WP post from a database
- How to Access wp_usermeta Data Immediately After a New User is Created
- Cleanup: best way to remove WooCommerce comments from the wp_comments table
- Logins from WP users table use on another page
- How to paginate information obtained from a query to a custom table?
- How can I show related posts from multiple separate installations
- Uknown meta entries in wp_postmeta
- Error establishing a database connection problem in xampp saver
- WordPress site URL changed; how to fix it without database access?
- I’m not able to get access to $wpdb [duplicate]
- Error establishing a database connection,
- Create table with dbDelta,can’t put any DEFAULT data
- WordPress database connection [closed]
- Changing between Local Host DB to Production DB and in reverse
- Post Views / Hit Counter Problem?
- Clear Terms from Taxonomy for Specific Post IDs?
- Options on how to Display member specific data from a MS SQL database
- Unkown meta_value in ACF
- Buddypress avatar image in database [closed]
- WordPress security [closed]
- How to split the WordPress database?
- $wpdb->get_var – What value is returned when zero records are found?
- Installing local to live WP into subdirectory
- WordPress SQL – How to Check for Category?
- SymmetricDS in dev + prod workflow?
- Fixing YARPP plugin FULLTEXT MySQL indexing
- Getting WordPress to work inside a rails 3 application
- Advantages of dbDelta
- Only allow user to access a link once a year, based on their joining date
- Error establishing a database connection in wordpress site , website not opening
- MSQL database wp_postmeta has meta key tve_revision
- Occasional Error Establishing a Database Connection
- Display user data in numbered list
- Removing old_slug and old_date from WordPress Database
- Help with $wpdb on custom code
- “BS_” rows in postmeta table
- Migrating meta_key and meta_value from old theme to new one
- How do I change several broken URLs in a several wordpress databases in the fastest way?
- How to rerieve comments and their replies from DB
- Optimize WP site for millions of posts
- I Want a More Concice Form of Data than an Array
- Duplicate database to roll back theme & content changes
- database error WordPress move from one hosting to other
- WordPress Migration – Issue with admin panel changes
- Select data from foreach loop and send it to wordpress database
- mySQL database size large, but tables size less
- Error establishing database connection error during first WordPress run
- Same DB for live and dev versions
- How much post meta data is too much?
- I have include wp-config, should I add global $wpdb also?
- Localize strings from db
- Can’t Install WordPress (local) Failed to open file wp-includes/wp-db.php
- version control for wordpress? (wordpress folder and database at same time)
- not saving post in wp_post wordpress database table
- Redirect Issue: WordPress database
- Install WordPress with SQL database
- Creating Job Tickets
- Best db table structure for users with many records
- How to stop WordPress from using utf8mb4_unicode_ci collation
- WP Multisite Users Not Linking
- Query a meta key using an array of values where the database value is a string