If you have used a mass import utility to add your old posts to your new blog then chances are that the new posts created in the new blog do not have the same IDs as the old ones. So even if you wrote the correct SQL queries, you would not be able to connect the posts with their correct comments.
However if you do have a away of connecting the old posts with the news ones then the best way to add the comments would be the “WordPress” way, which means doing it by calling iterating old comments and adding them to the new posts via calls to WordPress core functions.
One other alternative might have been installing your new theme to your old blog and then fixing whatever was wrong with it in the first place, but then you wouldn’t have to worry about importing your posts and comments somewhere else.
(@yehudamoon)
8 years, 2 months ago
Hi,
I recently rebuilt http://www.yehudamoon.com from scratch (using ComicPress and Comic Easel). I created 1,500+ new posts using the Comic Easel plugin import feature.
I used to have an old WordPress version of the site that I’d like to move the 54,000 comments…
…and match them to the new posts. So all of the original old site’s comments associated with say, post ‘2008-01-22’, would then appear under the same post but on the new website.
Is this possible?
My first thoughts were to:
1. Use MySQL queries and update the Comments table in the old site and then import the table into the new website. If this solution was possible, could I merge with the new comments table already in existence?
2. Find a plugin that might do this for me?
3. Find someone with much better programming skills that I do it for me (if doing it is even possible).
Has anyone else accomplished this?
Thanks for any help you can provide.
Rick Smith
[removed from public forum]