I have some select posts on one database that I need to export and import into a different database.
Because both databases are operating independently, there is overlap with post IDs so I can't export the ID from wp_posts.
I can successfully export and import the posts, but the post meta is dropped. And, since I'm not exporting the ID, I can't export the wp_postmeta without referencing the appropriate (NEW) ID.
Any ideas on how I can transfer only some posts to a different site and keep the post_meta while ditching the ID?