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
-
Switched from Wix to Wordpress dreaded hashtag URL
Recently took over managing a site for a non-profit which was using the dreaded Wix. Switched over to Wordpress but now Google still has the old URL's with the hashtag. Can't forward them in .htaccess and don't want to add javascript for fear of slowing down load time. I found a solution that seems like it will take hours and hours of work. I found the solution at http://www.thedriversgarage.com/web-technology/redirecting-hashbang-urls-wix-urls/ but it seems like it would take hours with all the URL's. I submitted an XML sitemap in Google webmaster tools. My question is, how serious could this effect SEO for my site? Google accepted the new sitemap but still has the old URL's in SERP. How long does this generally take to remove? Will the hashtag URL's penalize the site for duplicate content? If so is there a way to tell Google the homepage without hashtags is the page with original content? Sort of like the rel=canonical tag which I know wont work as the hashtag URL's all redirect to the homepage so they will all have the tag. Does Google ignore the hashtag? Could there even be a benefit to this, possibly the homepage getting more page authority due to the redirects? How serious is this? Thanks in advancing.
Web Design | | limited70 -
Online Catalog (E-commerce like) Wordpress Themes?
I'm currently looking for a Wordpress theme similar to e-commerce/shopping websites like ebay. I'm planning to put up a buy and sell site for shoes where people can upload shoe listings on their own.. The site we're planning doesn't have a buy/checkout button and paypal integration so it will look like more of an online catalog and not a shopping cart. We will just add a contact number/email in the product listing so a buyer can contact and personally meet the seller. Let me know if this can be done in Wordpress + e-commerce plugins. I would also like to know if there's a WP plugin that will allow users to use Facebook or Twitter to login/sign up in our website/platform. Let me know if this is possible in Wordpress by installing a plugin. Thanks in advance!
Web Design | | esiow20130 -
Many errors from previous ecommerce site. Domain is now just a localized wordpress site.
Many errors from previous ecommerce site. Do I need to redirect every single page that no longer exists at this domain? loveyourcabinets.com used to be loveyourkitchenandbath.com but we have since changed course. We want loveyourkitchenandbath.com to be our local site on Long Island and NYC. Loveyourcabinets.com will be an ecommerce project that I'll be revamping in the coming months. I think Moz as well as Google still has all of the old ecommerce pages indexed. And of course, Moz is shooting me a bunch of error all regarding pages from the ecommerce site that used to be on loveyourkitchenandbath.com. Any thoughts? Commentary? Thx
Web Design | | loveyourkitchen0 -
My site build in HTML has been badly hit this recent update and I have been toying on the idea of changing it to Wordpress
My site build in HTML has been badly hit this recent update and I have been toying on the idea of changing it to Wordpress. Would this help in my rankings? It seems the hit came only that last 2-4 days when business become much quieter. Frankly i have no idea on why the site fell in ranking all of a sudden. Been comparing to competitors and even a friend in the same industry and nothing makes sense so far (link profile, DA, PA etc) This site has been ranking well for 3 years prior to this. 2. My site has loads of content and visitors arrive from various landpages. But by changing it wordpress, the url of most of them would probably change. What should i do? 301 redirect all of them or is there a better method?
Web Design | | rester0 -
Wordpress Frameworks for SEO - Genesis - Does it Get Any Better?
I'm sure there's a ton of people in this community running Wordpress, any Genesis developers/users out there? For anybody who doesn't know, Genesis is a parent framework for building wordpress child themes. It saves a ton of time for people that aren't too handy w/ php (like me). I'm working on a few sites locally with it right now, and it's really impressive. I'm seriously never planning on using another WP framework. It also integrates perfectly with Yoast SEO, which is something not all frameworks do. So I thought I'd try to get some input from the community here, anybody have another framework they like? Or have an opinion on the SEO benefit of genesis? Would love to hear...
Web Design | | SVmedia0 -
Does doubling up on domains increase my ranking?
I own two websites. One is older and contains the bulk of my content. The other is a web-based tool that has less written content, but is equally important to my business. For the sake of examples we'll call the older website "oldsite.com" and new website "newsite.com". Would it benefit my old site to direct traffic to the web-based tool using a domain like "newsite.oldsite.com"? What's the best way to integrate the two sites so I am not splitting my traffic?
Web Design | | Travis-W0 -
How do you deal with comment spam: wordpress?
I have akismet installed on my Wordpress blog, and it does a great job of filtering the spam comments, but for some reason my site (and server) gets slammed by the amount of spam comments akismet blocks. If I check my spam folder there will be over 100 spam comments in an hour. (which in turn puts a load on my server.) Does anyone have any thoughts on how to put a stop to this? (Or at least slow it down?) I know I could use a captcha, but I really don't want to put any barriers on people commenting and I don't even like using those captcha's myself. Thoughts? By the way, does anyone know how spam like this works? This has been going on for sometime now. Are spammers just using automated software to do this?
Web Design | | NoahsDad0 -
Wordpress templates
Hi. Anyone recommend a good source or membership scheme for 3.0 wordpress templates that are coded to be SEO friendly and with good support. Looked at www.templatesold.com but they get very poor reviews www.templatemonster.com seem to only sell templates individually Peter
Web Design | | peterds0