Yes, site1 and site 2 are on 2 different servers.
I copied over wp_posts and wp_postmeta. Also the authors are the same authors that posted before.
Unfortunately, the import/export tool can’t be used because using it before, it couldn’t capture the 26,000 posts. It was always incomplete.
I’m still very baffled as to why some of the posts are posting and others aren’t.