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. What is an ORM, how does it work, and how should I use one? [closed]
  23. What is the difference between an ORM and an ODM?
  24. What is this JavaScript “require”?
  25. Rename a table in MySQL
  26. How should I tackle –secure-file-priv in MySQL?
  27. What is this JavaScript “require”?
  28. What is “Advanced” SQL?
  29. What’s the difference between identifying and non-identifying relationships?
  30. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  31. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  32. Export Pervasive to MySQL (C#)
  33. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  34. What are the differences between B trees and B+ trees?
  35. MySQL SELECT increment counter
  36. How to resolve ORA-011033: ORACLE initialization or shutdown in progress
  37. Example of a strong and weak entity types
  38. Oracle SQL query for Date format
  39. phpMyAdmin – Error > Incorrect format parameter?
  40. Strange Characters in database text: Ã, Ã, ¢, â‚ €,
  41. Difference between partition key, composite key and clustering key in Cassandra?
  42. How SID is different from Service name in Oracle tnsnames.ora
  43. What is a relation in database terminology?
  44. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  45. Database vs File system storage
  46. Can I have multiple primary keys in a single table?
  47. Exclude Statement in SQL
  48. How do you query for “is not null” in Mongo?
  49. What is a file based database?
  50. Is it fine to have foreign key as primary key?
  51. Storing Images in DB – Yea or Nay?
  52. Using wpdb to connect to a separate database
  53. how to Optimize WordPress database for 10 million post? [duplicate]
  54. MySQL Database User: Which Privileges are needed?
  55. Why is my database import losing text widget data?
  56. Database synchronization between dev/staging and production
  57. Keeping WP database synced across multiple developers using git
  58. WPDB Insert or if exists Update
  59. Multiple developers / editors working on a site in progress
  60. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  61. get_results using wpdb
  62. Will it break my site if I delete all transient records in wp_options table?
  63. Checking if Database Table exists
  64. Why WordPress choose data serialization over json_encode?
  65. What’s the simplest way to backup my WordPress database?
  66. WordPress (MyISAM) database is slow, should I switch to InnoDB?
  67. $wpdb won’t insert NULL into table column
  68. Relaunch 4.2 utf8mb4 database upgrade
  69. Fastest way (least amount of steps) to locally import a remote database using WP-CLI
  70. Safest way to bulk delete post revisions
  71. Please explain how WordPress works with MySQL character set and collation at a low level
  72. Solution for database version control and deployment?
  73. The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?
  74. How many users can WordPress handle?
  75. Get error messages when $wpdb->insert() returns false?
  76. Detecting errors generated by $wpdb->get_results()
  77. Staging sites, how do you manage synchronising updates in the DB?
  78. Does dbDelta delete columns as well?
  79. How to get the post publish date outside the loop?
  80. MariaDB as a backend database
  81. wpdb update add current timestamp not working
  82. Site stuck in “Database Update Required” loop
  83. How to fetch Data in WordPress using MySQLi or $wpdb
  84. WordPress Database lost auto increment
  85. Count & Display Database Queries
  86. Connect to database using wordpress wp-config file
  87. How can I make a WordPress database portable and url independent?
  88. Are There Any Plans for WordPress to Support Databases Other Than MySQL?
  89. wpdb->insert multiple record at once
  90. How to migrate a HTTPS WordPress installation to localhost?
  91. Two WordPress sites sharing the same content
  92. How to integrate custom database table in WordPress and using WordPress functions
  93. Reset Post IDs to less than 64bit integer
  94. WP Multisite: load content from site X on site Y
  95. Custom form that store input in database
  96. Restoring WordPress posts from database only
  97. What is the purpose of the option name hack_file in the options table?
  98. Where can I find the database changes between WordPress versions?
  99. Automate WordPress Database Upgrade
  100. Database connection close
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)