Use WP-CLI to Migrate Posts from One Database to Another
Migrate Posts from One WordPress Database to Another Using WP-CLI
Export the posts from the source site. You can use the wp export command to do this:
$...
Database
Hands on Keyboard
Helpful No-Fluff How-to Guides
