i recently created a new wp site with some of the same content from my old wp site.
is there a way to migrate comments from my old database to me new database? i tried importing old the wp_comments table into my new db via phpmysql. they did import and appeared in my wp admin, but they weren't associated with the correct posts and categories. looking at the .sql file i'm guessing that this didn't work because the old comments all have different comment_post_IDs from my new db.
is there a way around this or another way to migrate the old comments?