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
-
Having a Subfolder/Subdirectory With a Different Design Than the Root Domain
Hi Everyone, I was wondering what Google thinks about having a subfolder/subdirectory with a different design than the root domain. So let's say we have MacroCorp Inc. which has been around for decades. MacroCorp has tens of thousands of backlinks and a couple thousand referring domains from quality sites in its industry and news sites. MacroCorp Inc. spins off one of its products into a new company called MicroCorp Inc., which makes CoolProduct. The new website for this company is CoolProduct.MacroCorp.com (a subdomain) which has very few backlinks and referring domains. To help MicroCorp rank better, both companies agree to place the MicroCorp content at MacroCorp.com/CoolProduct/. The root domain (MacroCorp.com) links to the subfolder from its navigation and MicroCorp does the same, but the MacroCorp.com/CoolProduct/ subfolder has an entirely different design than the root domain. Will MacroCorp.com/CoolProduct/ be crawled, indexed, and rank better as both companies think it would? Or would Google still treat the subfolder like a subdomain or even a separate root domain in this case? Are there any studies, documentation, or links to good or bad examples of this practice? When LinkedIn purchased Lynda.com, for instance, what if they kept the https://www.lynda.com/ design as is and placed it at https://www.linkedin.com/learning/. Would the pre-purchase (yellow/black design) https://www.linkedin.com/learning/ rank any worse than it does now with the root domain (LinkedIn) aligned design? Thanks! Andy
Web Design | | AndyRCWRCM1 -
Domain name change
Dear team, If a website with a domain name - example - raisins.com wishes to change to peanuts.com is this a dangerous task or a relatively simple one? I hope that by keeping my Q short, provides ease.
Web Design | | AdrianCGreen0 -
Does having too many wordpress portfolio pages with little content hurt a site's SEO?
I have a site that is for a service company, not image based like a photographer or artist. We utilize the Portfolio feature to create a gallery of floor coating finishes (images of all the flooring finish options available) but this solution has created /portfolio/file-name pages for each image. These pages have no other content besides the image. I've run SEMrush audits on this site which shows a high percentage of pages with low text/code ratio and duplicate content (a lot of the finishes have very similar names). This site has been extremely slow to improve any visibility online (more than 9 months) and I'm wondering if this is a factor by possibly having a negative effect on our site. We initially chose the portfolio option because it was the best-looking solution for our users but we can certainly change it to another format if that is better. Thanks!
Web Design | | WillGMG0 -
HTML to Wordpress - a good idea?
I have an HTML site that is 12 yrs. old and ranks well in Google. I want the more user friendly Wordpress format to update content myself. Should I, and how do I make the transition. Thanks.
Web Design | | Stuttering0 -
Google search issue with exact domain
We had a site from Feb-2011 to Nov-2011 at the domain amcoexterminating.com. The site was pure HTML/CSS and the daily unique visitors steadily increased over that time. So all was fine. We then moved the site to a CMS (Joomla) on Dec. 6th. From that day forward, the daily visitors went into the tank. Before the move, if you typed "amcoexterminating.com" or "amco exterminating" into Google search, the site would be the first result (as you'd expect since those are the words that make up the actua domain). But we tried this yesterday and the site did not come up at all. NOT GOOD. It would work in Yahoo or Bing, but not in Google. So obviously, the problem with Google search directly affected the daily visitors. We just checked Webmaster tools yesterday (yes, this should have been done sooner, lesson learned) and it said "Site has severe health issues - Important page blocked by robots.txt". It listed the "important" page URL and it was just a link to an image. Regardless, I wiped out the Joomla created robots.txt file and added a new one and made it just say... User-agent: *Allow: / About 14 hours later, after the new robots.txt file was recognized by Google, the "severe health" message went away. However if I search in Google for "amcoexterminating.com", it still doesn't show up and the client is concerned (as they should be). Do you think the search engines just need more time to refresh? If so, once it refreshes, should the site show up first again right away? Or is it possible the robots.txt file had nothing to do with the issue? If so, what other things could I check into that might cause Google search to not find a site even if you search for exact domain name? Please share any and all things I should look into as I need to get this site showing in Google search again (as it was before moving to the CMS). Thanks!
Web Design | | MarathonMS0 -
Drupal and Wordpress on same TLD
As Rand says on the Whiteboards, "Howdy SEOmoz fans", I am obsessed with Wordpress, but wanted to spread my wings a bit and have been playing around with Drupal. I really like it. I had the idea for a new site that would have a Drupal set up (in the front end for pages and training) with a Wordpress blog on the subdomain or a directory for the Social Media integration I like to do with Wordpress. I'm just brainstorming a couple questions: 1. Would you guys and gals recommend sticking to just one or the other for SEO or does this not really matter as long as they are deep linked well? 2. Also, would you recommend subdomain or directory for WP? Have a good one, Jared
Web Design | | JaredBroker0 -
Need an SEO pro to build us a new fine art website
Hey Seomoz friends My friends and I started buying and selling art 5 years ago. We did it all on ebay. Two years ago I decided to try an attempt at building us a website to further our business outside of ebay. www.originalartbroker.com I used homestead.com software aka intuit to do this. I was able to get a lot of first page results in seo after a ton of work and willing to do a lot more. I'm sure the homestead site slowed my efforts down. I need more power 🙂 What we do. We sell fine art. We are trying to aspire to the leading seller of fine contemporary art online. We will do whatever it takes to get there. Our issue is not our product. Our issue is getting traffic to the site. I only have 175-200 visitors a day. I need better results for the keywords of our artists and inquires that surround them. We have a bounce rate of 70%, average time on site of 1 minute 50 seconds, and a slow loading site that is almost impossible to create individual pages for pieces (mgmt nightmare) Outside of our site we have blogs, squidoo pages, facebook account with 2500 fans, twitter page with 2k followers, youtube channel, and a blog on the site for new arrivals. We have a 200-250 piece on our site at any given time. We add probably ten pieces on average a week. We don't need any kind of ecommerce management software as most of our sales are done over the phone being that it is higher end art. I need a site that out performs my competition. I need to be in the top three when someone types in "leroy neiman" "peter max" and so on. I, with limited knowledge, need to be able to use the software everyday to upload new art as it comes in. I want every piece to have its own page so that I can also add pieces to a google merchant account. When I add new pieces under a certain artists and it creates its own page i want it to create h tags and an url extension for each product as I add them based off the discription and artists name. I would like some sort of blog integration to post our new arrivals as we get them. I would like some sort of customer capture. I am thinking something along the lines of them prociding email, name, and zip code to see the prices on the site. You are the seo pro so you know what it takes. I would like to know what a solution would cost to get us on the ground with more seo power. A site with speed that is easily indexed. It doesn't need to have a lot of bells and whistles. Please look at my site and let me know what you think. You can get an idea from that of what we are doing. Please give me an idea of what you can do and what it would cost. Thank you
Web Design | | forecastedinvestments0 -
Wordpress vs. mvc framework
What's the benefits of choosing an mvc framework such as codeigniter or cakephp over wordpress? Wordpress has so many plugins, and a universally known UI for customers, it just saves a ton of time. However, a lot of the 'big guys' like SEOmoz and Distilled(?) use Cakephp and other mvc frameworks so it has me wondering what the benefits are...... anyone?
Web Design | | DonnieCooper2