How to delete all posts, categories and tags from WordPress database

Use WP-CLI to remove all tables from the database in MySQL.

Runs DROP_DATABASE and CREATE_DATABASE MySQL statements using DB_HOST, DB_NAME, DB_USER and DB_PASSWORD database credentials specified in wp-config.php.

wp db reset --yes

Related Posts:

  1. Deleting data from a custom table in WordPress
  2. Function to delete a post, it’s children and it’s grand children (half way there already)
  3. Multiple Category Query
  4. how to replace old DW site with new WP site? [closed]
  5. Fastest and most efficient SQL query to check if UID exists
  6. How to have more post in a page than in your home page
  7. How can I add more code to this?
  8. SQL Query : how copy all tags of post into their post content in wordpress by sql query
  9. How to display SQL query that ran in query?
  10. Best way to eliminate xmlrpc.php?
  11. How can I create a meta_query with an array as meta_field?
  12. What SQL Query to do a simple find and replace
  13. Query multiple meta key values?
  14. How to Optimize WP site for millions of posts
  15. Best practices for localizing WordPress content?
  16. How to get comments by post ID?
  17. WordPress Paginate $wpdb->get_results
  18. Differences between wpdb->get_results() and wpdb->query()
  19. Is there a way of increasing the speed of this query?
  20. Get all image from single page using this query
  21. How can I query all users who registered today?
  22. Get Terms by IDs with IDs order
  23. Custom Search Query
  24. Reversing the order of posts AFTER the query is performed
  25. How to Handle Distributed Development Workflow
  26. what are the numbers between curly brackets in search query
  27. simple sql query on wp_postmeta very slow
  28. Using WordPress public query variables
  29. How to Use Wildcards in $wpdb Queries Using $wpdb->get_results & $wpdb->prepare?
  30. When/why does ‘$query->get( ‘tax_query’ );’ return empty?
  31. How to move wp-content (or uploads) outside of the WordPress directory
  32. How to get link and title of next and previous post on single page
  33. Create pagination and order according to alphabet
  34. wpdb get posts by taxonomy SQL
  35. Editing Complex Pages in Visual Mode
  36. How to List Events by Year and Month Using Advanced Custom Fields?
  37. Is there any difference between hooks posts_where with posts_join and posts_search performance wise?
  38. wordpress query – orderby child post date
  39. How many WordPress SQL Queries per page?
  40. How to display Section for certain time
  41. Add multiple value to a query variable in WordPress
  42. Search custom post type by meta data
  43. Custom query_var causes displaying posts archive on front page
  44. Slow wp_enqueue_media()
  45. Multipart/formatted MySQL query problem
  46. What is the most efficient way of implementing a favorite post system?
  47. Split content into multiple columns using more tag?
  48. Remove [gallery] shortcode altogether
  49. Compare two numeric custom fields
  50. wp_dropdown_categories with multiple select
  51. Advanced Custom Fields – Query Efficiency
  52. Why does get_the_time(‘F j’) return November 30 for all posts?
  53. Multiple content areas per page
  54. Query by one meta_key and sort by another (possibly NULL value)
  55. How to tune search argument in WP_Query to show only exactly the same results?
  56. Custom query filter not working on woocommerce category page
  57. How to delete a transient on post/page publish?
  58. Some way to Flush or Overwrite all Imported Content in a Site for a Fresh Import – How?
  59. Very slow query
  60. Have multiple local wordpress installs share a wp-content folder and database
  61. query multiple taxonomy and show post count
  62. Search Terms – Querying on either description__like OR name__like in the same Term Query?
  63. Query & Sort Comments by custom comment meta
  64. How to get my loop to pull posts into three columns
  65. How to display lastest post date in the homepage?
  66. Custom $wpdb Query for Custom Post Type by Category
  67. Add default content to post (for specific category)
  68. Custom CSS for full post vs. excerpt (Content Options)
  69. Highlighting Sub topic in a post?
  70. Get a user’s most recent post title
  71. Categories and products in random order
  72. add_query_arg() XSS Vulnerability
  73. Count user posts by user ID, Post type and Post status
  74. Can’t pass table to $wpdb->prepare
  75. Query set using tax_query with relation ‘OR’ modifies category object?
  76. $query->query_var[‘post_type’] not set for pages
  77. Create subpage /user/ or /my-profile/ like /author/ with additional query like /user/user123
  78. is_archive() doesn’t work on public query var archive pages?
  79. How to extract all ID variables from a query string?
  80. When add_query_arg() is necessary?
  81. Different Main Navigation per category
  82. How to get category link without a database query
  83. Insert html after certain amount of posts?
  84. wp remove query
  85. Save metabox checkboxes values to custom content type
  86. Show recent products first but “sold out last” in query
  87. WordPress creating excessive joins on meta_query with search
  88. How to display liked posts of current user in wordpress?
  89. Take excerpt of the content of the post and send it as the title to create new post
  90. Filter query posts by the count of metas for a meta key
  91. How to tell if $query_var isset?
  92. Order post by year DESC and month ASC
  93. Show All Posts Insert Edit Link
  94. Retrieve and display data from custom db table in admin area?
  95. $wpdb->get_var not returning a result
  96. search through post-type attachments titles
  97. How to count get_users query?
  98. How to find if a post with custom_field == X exists?
  99. Date query year and month OR just year
  100. Customize in category page
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)