There are plugins that will do this for you (example). Whether it’s worth installing it and learning how to use it, depends on how many posts, pages and so on, you have.
If you have less than, say, a hundred you can use the screen options tab on posts, pages and users to select a high enough number to be shown on one page. Then simply select all and trash. This also works for media in the list mode (rather than default grid mode with infinite scroll).
I wouldn’t mess with the database for this. Unless you really have a lot of data to wipe that would be too time consuming to figure out for a one off job.
Related Posts:
- How to transfer one domain to another domain without losing theme options (customizer)?
- How to use multiple check-box values to work in a function and insert values in database
- When to use is_home() vs is_front_page()?
- Best practices – Should I create a child theme vs. customizing a framework theme? (such as HTML5 reset)
- How to disable 3.1 “Admin Bar” via script for the admin user?
- How the WordPress sidebar works
- Should we localize custom-made themes / plugins?
- Extend walker – navigation, adding data attribute to a tag
- How can I remove the Static Front Page option from the Customizer
- How can i customize the comment list
- How to add custom template tag in wordpress theme?
- How to handle theme customization and sass variables
- wp_enqueue_scripts not called on search page?
- wp_head() not inserting the default stylesheet style.css
- First completely customized theme, where should I start?
- WordPress how to override function adjacent_posts_rel_link_wp_head() in link-template.php the correct way
- Theme Customizer not loading
- How to retrieve an image from a post and display it before excerpt of a post? [duplicate]
- Best practices: Custom theme sidebar menu – hardcode or widget?
- Best approach to create sites with Modular Content? [closed]
- Modify the Additional CSS section (adding a disclaimer)
- What’s the best action to use when you want to do something only once per theme setup?
- Change setting name in Customizer and keep the data
- Customizer API and add_panel(). Panel doesn’t show
- How to correctly add JQuery in a WP theme?
- Creating multiple hooks for theme
- What is the best way to handle multiple calls to get_template_directory_uri() and similar functions?
- How to add a second stylesheet to the editor
- Removing non native customizer settings from a child theme
- How to reorganize the items returned by wp_list_comments()?
- For best DB performance should I serialize all theme options together or by type?
- which is the best way to customize nav-menu-template.php?
- WP Northwind for Theme Development?
- Conditional statement to show pagination
- How to create a custom template to admin dashboard
- How to change database values on theme update
- How do I Add images uploaded in the post to a default custom field
- How to add a button which saves the post then executes a function
- Limitations when modifying wp_title with a filter
- How to make animated intro?
- How to edit theme functions file to modify pagination?
- How to display all subpages and short by year
- Getting custom posts by post id from cutomizer text input
- Disabling Customizer Selective Refresh shortcut icons for selected controls
- StoreFront product pages: Turn the Short Description section into a kindred tab section [closed]
- “Add A Widget” button in the Customizer
- Zoom on custom theme without child
- Q: How to pull data from custom table to populate zustomizer setting/control select options
- Move default page templates to sub directory
- Changing a slider to a grid [closed]
- Custom Navigation build using wp_nav_menu and walker
- Using My Own Classes On Wp Unit Tests
- Efficiency of wp_options vs a new table
- WooCommerce: multiple input field for multiple product variations
- Integrate WooCommerce theme with a WordPress theme [closed]
- How do you use WordPress for a website that’s not in a blog format?
- Database Tables in WordPress Theme
- Child Theme header1.php file not overwriting parent theme’s header1.php file
- Replace site title with logo when logo is uploaded in customizer using
- How to make theme configurable
- Extending Twenty Eleven Theme
- Templates without a loop, best practice?
- searchform.php doesn’t work properly
- CSS added through customizer neglects the need of a child theme?
- Customizer: get_preview_url() inside customize_save_after hook
- How to add custom meta box when you have a custom page template file
- How to call a widget in a loop at a specific iteration value?
- Right procedure when you develop a WP Website for a client
- New to WordPress – Read the Codex, Other Docs; Still Confused
- Create theme for mobile phones and tablets only?
- How to add custom page elements to the WYSIWYG editor?
- Using the media library for theme customization
- Alternatives to handle customizer settings
- My contact form – I’ve changed the source code but the changes are not being applied
- How to custom category template based on category?
- What is difference between add_theme_support and Theme Customization API?
- Is hand coding required at all?
- Text View (Code View) in WordPress Customizer TinyMCE Editor
- how to edit woocommerce checkout page
- What is the best practice workflow for new website overhaul and keeping current SEO ranking? [closed]
- Add a customize control depending wich radio setting is checked
- WordPress Customizer Help with FontAwesome Icon
- Query wp_postmeta into an array based on post_id
- Undefined index: custom_sidebars
- How to share posts (and plugins) between existing site and new, separate dev/test installation?
- How to prevent XSS attack in wordpress theme?
- page.php is not called when I load a Page
- wpdb->insert adds too many rows
- WordPress 3.5 + Foundation 5 not working on IE9
- Theme Option’s Save Button is not working
- How to convert that page to a wordpress template? [closed]
- How do I change the tagline input to textarea?
- WordPress theme Modifications not showing up on live server
- Turning WordPress Into full-featured website?
- Workflow of Collaboration on wordpress development [closed]
- Best practice to create required pages
- Permalinks problem with custom theme
- How to split the site’s layout without damaging this layout? [closed]
- Multiple content areas with Gutenberg – Transparent areas mid content
- Website Developer has gone missing! How to gain full access of your code from a WordPress website?