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()?
- Using classes instead of global functions in functions.php
- What are the ADVANTAGES of ORIGINAL wordpress template structure?
- Change admin bar to default:off
- How to change admin bar color scheme in MP6 / WP 3.8 front end?
- Template for individual post designs
- When to use esc_url, esc_html, esc_attr, and friends?
- Best practices – Should I create a child theme vs. customizing a framework theme? (such as HTML5 reset)
- How can you develop on a live WordPress installation that is using W3 Total Cache? [closed]
- How to disable 3.1 “Admin Bar” via script for the admin user?
- What is the best practice for customizing a plugin’s JavaScript/jQuery?
- How to deploy a new theme/theme options from staging to production site
- Front End Post Submit Form
- Feature Survey – What would you want in a resume theme?
- How the WordPress sidebar works
- Should we localize custom-made themes / plugins?
- Change loop order via form or link (jquery, not URL)
- Extend walker – navigation, adding data attribute to a tag
- How can I remove the Static Front Page option from the Customizer
- Set front page as static page [closed]
- How to programmatically bring back “excerpts” field in post editor in WP 3.1+
- How can i customize the comment list
- How to add custom template tag in wordpress theme?
- How should I store global information such as a phone number so that it is editable through the CMS?
- When developing a distributable Theme, does it HAVE to be “inheritable”?
- 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
- Upgrading a custom theme through the Dashboard
- 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
- Responsive Images – Generating multiple images from Theme Customizer control upload?
- How to retrieve an image from a post and display it before excerpt of a post? [duplicate]
- Modify Javascript Configuration Options for Theme Customizer Colour Picker
- 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?
- Version control for both Vagrant config and themes being developed [closed]
- Change setting name in Customizer and keep the data
- Customizer API and add_panel(). Panel doesn’t show
- Child Theme header1.php file not overwriting parent theme’s header1.php file
- How to have content scroll over background
- WordPress Template Part in iFrame
- Replace site title with logo when logo is uploaded in customizer using
- Is there a WordPress boolean for “theme_customizer_active()”?
- How to make theme configurable
- Extending Twenty Eleven Theme
- How to clean up the theme for production?
- 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
- Valid SQL query not returning results
- add shortcode support in customizer
- How to call a widget in a loop at a specific iteration value?
- Right procedure when you develop a WP Website for a client
- Woocommerce Product attribute not imported with wordpress Importer [closed]
- 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
- Update Specific Key Value in Complex `wp_options` object
- Can’t change theme name
- Remove/Hide a Widget on a Custom Template
- 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?
- Duplicate child theme incl. design changes
- 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]
- WordPress Twenty-Fourteen: How to Remove Home Page Header Image from Other Pages
- WordPress menu walker – Get parent item text inside end_lvl function
- How to dowload and edit content of a website
- HTML TO WP Theme : Submenu goes down wp_nav_menu
- Add a customize control depending wich radio setting is checked
- Any way to permanently translate themes?
- 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?
- Best strategy for providing theme options using customizer
- Customizer API way function is_customize_preview() works only in main page?
- page.php is not called when I load a Page
- wpdb->insert adds too many rows
- Support Multiple featured images
- WordPress 3.5 + Foundation 5 not working on IE9
- How Does One Create a Global Variable Repository
- What hook to use for loading a custom class extension during Theme initialization?
- trying to figure out how to use more that one image upload in the same section in theme customizer
- Theme Option’s Save Button is not working
- How to convert that page to a wordpress template? [closed]