Dump custom post type database

You can do that by two ways. One is by a function or other by SQL query.

In your function just get all the posts having post_type = <your-custom-post-type> and delete those . Just add that function to theme init method.

You can also do that through just SQL query. Query may be like below.

SELECT * FROM wp_posts WHERE post_type=<your-custom-post_type>

If your are non-technical then second options will be best for your.

Note: Before doing any thing just backup your database for your safety, if any thing goes wrong, you can directly replace the dump.

Related Posts:

  1. Should I use custom post types or a custom database tables for plugin development?
  2. Where are wordpress custom types stored?
  3. Delete all posts of a custom post type—efficiently
  4. Custom Post Types, or completely custom?
  5. Custom Post Type with Input fields to seperate table on database.
  6. Right way of storing large number of custom post fields
  7. How to use custom database tables for custom post types?
  8. Custom Post Type or Custom Tables
  9. Custom post type or just use custom fields
  10. Create Pages from Database
  11. Use Custom Database with Custom Post Type
  12. Custom Search | Wrong output & question
  13. How do I write this SQL statement for Posts written in last 24 hours?
  14. Save or update data when custom post published
  15. Custom post type Vs. data in own table
  16. Save custom post type in different table
  17. Using posts and postmeta table to store custom Address Book Plugin data
  18. How to use custom post type APIs, but use a different db table
  19. Developing WordPress on Kubernetes
  20. Recommended custom post type structure for TV Schedule site?
  21. WordPress post count not showing for custom post type author
  22. Where to store custom tagging data associated with a custom post type
  23. wpdb custom post_type problem
  24. Adding custom tables to WordPress
  25. WP All Import – Using Xpath to set a select value
  26. Sorting custom post type columns with external data and without meta values
  27. How to use custom taxonomies to reference complex relationships?
  28. Create a clone from one WordPress site to another in a few minutes
  29. Database to page routing API?
  30. Store CPT ‘Reviews’ average ratings to a WordPress DB table or to a DB custom table?
  31. How to change wp prefix for custom post type only?
  32. Is it possible to store Custom Post Type data in separate set of tables and still have wp_post class functionality?
  33. Add update or delete database records using custom post type
  34. How to import a custom MySQL DB table into a WordPress custom post type
  35. WP_Query orderby and tax_query
  36. Importing Data from a Non-WordPress database, into WP
  37. How to organise this data within WordPress
  38. Organize WordPress site, so it can maintain with huge database
  39. Save custom post type to external database
  40. Show data from one Custom Post Type in another Custom Post Type
  41. Specifying meta field’s column type in Database using add_post_meta
  42. Replace dynamically content in a custom database table when a custom post is created
  43. Running a song lyrics site on WordPress
  44. Save and user submitted data from a form and display them in the wp backend
  45. Should I use custom taxonomies or not?
  46. Designing a custom post type with a minimum number of meta fields
  47. Allow front end users to add data to a custom post type
  48. WordPress hook which triggers on post import
  49. Update all published posts at once
  50. Entity to store contact form entries?
  51. Ideas to connect external database table to wordpress posts as custom field source
  52. Database alteration: users who voted
  53. WordPress as a frontend website for iOS app [closed]
  54. Using custom post types WordPress network
  55. delete duplicate meta_value with same post_id
  56. custom post type: own database table structure and custom “new-post” interface
  57. Import External XML
  58. Say I have a tech blog, how best would I store technical specs for a phone, if i use custom post types
  59. How do you make relational post types in WordPress? [duplicate]
  60. Having a repeating custom field in admin custom post type, what I’d go better with, for DB’s sake? ACF repeater or query a different post type?
  61. Does this archive template part look like its making too many calls to the db?
  62. Right way to store a large set of similar information on website? [duplicate]
  63. when looping through custom post data not appearing
  64. custom post types, custom fields and normalization
  65. Custom post type and custom taxonomy key lenght & query performance
  66. How select query is generated in a Custom Post Type?
  67. dynamic vue widget inside custom post
  68. Create 3 Levels of relations with WordPress
  69. Exporting Post type from one theme and importing it to another theme
  70. How to replicate data storage and querying using WordPress. Custom posts/fields or Custom db tables?
  71. custom data model – link and populate from admin backend
  72. How to store additional data that is related to core data
  73. Confused about where to store my data
  74. Event Manager: Events Deleted are still in DB as published but hidden in admin
  75. Changing an item in drop down after 5 latest posts per taxonomy
  76. Populate custom post type/custom fields from an external database
  77. Limit Number of Custom Post Type Dashboard
  78. Automatically convert standard posts with custom fields to custom post types
  79. In WordPress do I create tables for my plugin or do I create custom post types for a Student and Classes Registration system?
  80. CPT or Custom Table for Repository of Serial Numbers
  81. How to enable the user to add value through the admin panel?
  82. Use Tags to Query Associated Multiple Posts and Get The Average Of Custom Field Values
  83. Shared Custom post type between WP network sites
  84. Custom Post Types and Posts are mixed
  85. Pulling Content from Existing Database
  86. Displaying database table in backend of wordpress
  87. custom post type for custom talbe
  88. Check in function on custom page
  89. Most efficient way of deleting post
  90. Problem with menu categories doubling up when updating database?
  91. Inserting into WP DB
  92. Save number of Facebook likes to database
  93. WordPress and Unity high scores table
  94. Checking for published posts in a certain post type
  95. Switched server & domain name, now custom post types won’t save
  96. custom post types containing a collection of items
  97. WordPress Admin Page Slow. Customer Post Type is the slowest
  98. Why WordPress does not Use Separate Table for Post Types (When Registring)?
  99. Remote database access on another wordpress site’s custom post type
  100. What would be the optimal CPT / Taxonomy design for the following entities structure
tech