Export WordPress Blog for Import to another WordPress Blog

That’s a tough challenge. If you search around you will find several threads about this.
The main problem is this: Probably both blogs will have posts with the same ID#s, i.e. a post with an ID#=89 in both databases; or categories with the same ID, comments with the same id, Pages etc…

Basically you would have to “merge” the two databases but because of the problems mentioned above – there isn’t an easy way. I don’t remember any successful attempt.

Yeah. pondering this…

At first blush, using some sql scripts to extract and reload doesn’t seem all that tough. Except that the new keys for the imported data has to be kept in sync with the child tables. And that puts you in the “data transform” world.

So, you’d load the old wp_posts table into the new wp_posts table (don’t load the key, let mysql generate it). But now you need to update your source data with the NEW keys on all of the post child tables.

If I had free time I’d love to take that on and try to solve it programmatically. Alas, I don’t though.

While hunting around I found this: https://www.technosailor.com/wordpress-to-wordpress-import/

Yep, you’ll find that plugin mentioned a lot here.

When THIS thread was active, however, it didn’t exist yet. ??