How to export Wordpress comments ONLY to a new domain
-
Hi Guys,
We have a bit of situation here. We have a website (let's say it is www.oldsite.com) where we had more than 2000 posts. There arose a need whereby we had to move some 60-70 posts from this oldsite.com to another domain of ours (www.newsite.com). So, here is what we did:
- Move those 60-70 posts manually from oldsite.com to newsite.com
- Did a 301 redirect of each of those 60-70 posts from oldsite.com to newsite.com. Google has now started to rank the posts from the newsite.com for this. That's all good till now.
- Now, here comes the situation. We also want to move the comments from some of those posts of oldsite.com (some 10-12 posts out of those 60-70) to the respective posts of newsite.com.
How do we do that? Do note that we are pretty comfortable with databases and to some extent PHP. Please help.
-
Hey Shalin,
Assuming you have a large number of comments to deal with on those pages, the best option would probably be to delete those manual posts, then import the full 2000 posts using Wordpress's native import/export funtions, and then delete the posts you don't want. This process should only take 1-3 hours and is easier than your other options below.
It's possible to get into SQL and export just the comments table, but because you've manually created those new posts, you would have to manually rewrite all of the post ids that the comments are tied to, and delete all of the irrelevant comments after that.. Plus, the possibility of a small typo messing up the import is high.
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
New Website
With all the changes in web design, I feel it best to seek advice from my fellow Mozzers. We are definitely going with a custom design and I know it MUST be responsive and faster load speed than we currently employ. What other requirements should I seek from our designer? Approximately 50 product pages w/ ECWID shopping cart holding a dozen or less products. TY,
Web Design | | KevnJr
KJr0 -
New Re-design will my website rankings drop?
Hi guys, I have had to re-design my site although we are only 4 months into the seo game we have seen some good progress with our rankings. My question is there anything I need to consider before implementing the new designs so it doesn't effect my current rankings or any of our SEO work. Our current designs are content thing and so we have had to create more content to better optimize our site, however if doing so will this loose our current ranking position? Apperciate any advice around this Thanks
Web Design | | edward-may0 -
Domain branding and such
I have a client that has a website hosted with the site designers hosting company. That designer has proven to be unreliable, ineffective and non-responsive. We have since built a new website using a new domain name, but now we have lost all citations and links. Can I reclaim this domain name by pointing it towards my server and migrating the new site to his established domain? Should I update all of his citations to the new domain? What will happen to the old site? The old designer does not respond to any emails or phone calls so any help would be appreciated. Thanks
Web Design | | mrobby10 -
Question & Answers Forum pluggin for wordpress
I am looking to install on my website a Question & Answers Forum pluggin for wordpress Like MOZ Q&A What pluggin do you recommend for questions and answers Would be to replace the one on this site that i don't like due to some problems i have on configuration. http://www.propdental.es/dentista/
Web Design | | maestrosonrisas0 -
What pluggin translator is the newest and the best to install on wordpress. Thank you very much
What pluggin translator is the newest and the best to install on wordpress. Thank you very much
Web Design | | maestrosonrisas0 -
HTML vs WordPress
Which website gets better SEO results? I was told that HTML is crawled better than WordPress. Which is a more expensive website to design? What are the pros and cons of each?
Web Design | | CapitolShine0 -
Broad Phrase keywords as domain name
Hello, Am new here, can you advise if its good idea to buy broad phrase keywords as domain name e.g whatisagoodwebsite.com? Thank you
Web Design | | seoatbest0 -
Ecommerce Style Wordpress But No Shopping Cart.
Wondering if anyone knows if you can purchase an ecommece style wordpress theme, but not use the shopping cart portion or display pricing. We would like to display our website how an ecommerce is set up, but at this time, we do not sell anything online. We are considering in the near future to sell half of our products. And this would not be very large. Or can ecommerce be added to any wordpress theme. ?
Web Design | | hfranz0