Export only a part of the database for migration

If you don’t mind exporting pages and posts separately, you can use the default WordPress export tool to achieve that.

On the Export screen you can set the tool to export only posts. Then add a suitable date filter. After that do another export, but this time set the tool to export only pages.

You can read more about the default export tool on the codex, https://codex.wordpress.org/Tools_Export_Screen

I think majority of the backup/export plugins only let you choose which database tables are backedup/exported instead of letting you do such conditional/partial export.

Related Posts:

  1. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  2. Best way to import users, post and categories from an external database
  3. Export WP database for import using WP-CLI on Vagrant Box
  4. Exporting revisions
  5. Export wordpress table to excel
  6. MySQL Syntax Error upon restoring database from backup [closed]
  7. Export / import WordPress database
  8. How to Mirror WordPress database from Remote server to Local server
  9. Exporting table to csv works in the admin but exports HTML data when used on the front end
  10. Merging two databases without borking it
  11. How can i customize the export personal data file?
  12. Import users from old WP site to new one
  13. Export a custom Mysql database product catalog to WordPress
  14. Best practice to import user base (subscribers) from one website to another?
  15. Importer fails to import every post
  16. Is there an easy way of exporting posts with their category already asigned and pictures from localhost?
  17. Is it good practice to import/export a blog to test a redesign?
  18. Exporting Post ID, Post Title, Primary Category and Primary Category ID
  19. I broke database after reuploading local version – what exactly happened? Database error
  20. export individual posts to text files or a single csv file
  21. Saving data to database and exporting to excel
  22. Export Pervasive to MySQL (C#)
  23. Is it fine to have foreign key as primary key?
  24. Detecting errors generated by $wpdb->get_results()
  25. wpdb update add current timestamp not working
  26. Restoring WordPress posts from database only
  27. Displaying content from one WP site on separate WP site
  28. Lost the `wp_options` table: what’s the best way to restore the site?
  29. Performance Gains of Relational DB Setup
  30. How to move existing WordPress wp-content folder along with database to new server and new domain name?
  31. store simple data in get_option()
  32. How might I retrieve a featured post image from an external WP site and display it as a link back?
  33. What are conventions about the schema of the $table_prefix
  34. BuddyPress: What’s the use of wp_bp_xprofile_data table and how does it get updated? [closed]
  35. storing database in version control
  36. Is deleting orphaned wp_options entries safe?
  37. How to build a movie database with wordpress?
  38. What’s the most efficient database method to add and query usermeta?
  39. How to solve slow WordPress site caused by attachment_metadata
  40. Sub-domain or 2nd, temporary different domain?
  41. How do i get user data from a custom table in the wordpress database by user ID?
  42. Converting WordPress into Android or iPhone app
  43. Large database causes slow load
  44. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  45. Database slowdown after update to 3.4.1
  46. WooCommerce sku location in DB
  47. How to insert data into MySQL database from the form created in WordPress site
  48. Emoji support and MariaDB 10.0.30-
  49. Can I have multiple database users within WordPress?
  50. How do I copy a wordpress database?
  51. Export all content from wordpress
  52. Import live site to local setup without access to live site
  53. Modify Database in Multi-Site wp_usermeta table
  54. Form Data not getting stored in WordPress database
  55. Hook directly into query execution
  56. $wpdb doesn’t like to store arrays
  57. Connect to a remote database for wordpress in my own hosting server
  58. WordPress ‘repairing database’ in a constant error loop?
  59. What Is the Proper Way to Merge Usermeta Table to a an existing WP Database?
  60. Importing CSV into database table not working?
  61. “Database Connection Error” upon install in Apache VirtualHost document root.. Why did this happen? [closed]
  62. How Can I Put Meta_Compare in the Database-Query?
  63. Check if an option exists and get its value in one hit
  64. Change options table prefix only
  65. What’s the proper way to sanitize checkbox value sent to the database
  66. Problems with moving my WordPress site to another domain/server
  67. Is it important to have integers inserted using %d rather than %s?
  68. Any risk to changing WP table col CHARACTER_MAXIMUM_LENGTH?
  69. Connect to database in the header of my WordPress website
  70. Should I store critical css in the database or in my theme’s filesystem?
  71. WordPress url transformation script
  72. Is it risky if I update all url in the database due to my site url changed?
  73. Just created a WordPress Table can’t get $wpdb get row to work – need help
  74. Need help fixing sql syntax error after WP 3.2 upgrade
  75. Need help with creating a searchable user data by name or specific number like ID
  76. $wpdb->insert not inserting all rows
  77. Intentionally corrupt WordPress database
  78. How to re-connect WP files in lampp/htdocs to new SQL database to recover site under development
  79. I need to find posts that contain YouTube links without http:// or https:// prefix and add http:// to all of them
  80. How would I see which wordpress posts have a revision history without opening each one?
  81. Creating a custom form with ability to query and submit to SQL
  82. Intermittent Yet Problematic Error – “Error Establishing A Database Connection”
  83. Can I use a wpdb object to connect to a non-WordPress Oracle database [duplicate]
  84. error establishing a database connection 3
  85. User saved through WordPress backend does not show up in database table users
  86. Correct and secure way to access a custom SQL database in a custom PHP template file
  87. Missing latest posts and options after DB migration via phpMyAdmin
  88. get_the_terms is not working
  89. Local host to server import problem
  90. Restoring .sql backup results in “Error establishing a database connection”
  91. Link to handle $_GET request
  92. WordPress sync with phpbb
  93. “MySQL server has gone away” since update to 3.8
  94. Getting deleted users in database
  95. Options of accessing wordpress data from mobile app
  96. Getting data from a table using a query
  97. Database interaction (private-public) [closed]
  98. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
  99. Uploaded images not displaying full size preview or inserting into posts
  100. What’s the cleanest way to transfer WordPress to a new server