You should not need to change anything in the posts table when moving to a new domain. The guid is meant as an unique identifier, often for syndication (RSS or Atom) items. Except for the occasional (dumb) plugin, theme, or bit of custom code, nothing in WordPress should be using the guid field to provide a permalink to a post.
With that said, there is the issue of file attachments (images or other files uploaded through the post editor), which *can* run into problems due to the guid. I have a plugin that relies on it, and have been thinking through a possible tool to update the field.
Do you mean that i should just let it be and allow guid to have old domain permalink and new domain permalink? Since you said guid is meant for RSS, will it cause error to RSS if i just let it be?
“Do you mean that i should just let it be and allow guid to have old domain permalink and new domain permalink?“
Specifically with posts, that’s pretty much what I say above.
For the purpose of RSS and a few other feed formats, it’s just seen as a string, an unique one for that particular item. The WordPress developers (though not *unique* in choosing it for the guid) decided to use the url (permalink) since it would always be, well, unique.
So do you think i change the domain in the right way? Or did i left out anything or made any mistake?
What im concern about now is what if i removed my old domain account(www.funnydaily.com), will i get any error since my new domain’s wp_posts contains old domain permalink in the guid value.
“So do you think i change the domain in the right way? Or did i left out anything or made any mistake?“
I don’t understand the question. You said everything is working.
There are instructions on moving your WordPress installation in the docs. The steps you needed to take are similar to “Moving WordPress Within Your Site” since you have to change the WordPress and Blog addresses. But no matter the case, if you moved WordPress and it works, then you did nothing wrong.
And let me repeat myself:
You should not need to change anything in the posts table when moving to a new domain.
You made the move. WordPress works. Permalinks take you to their corresponding posts on your new domain. Where is the problem?
The problem is i see guid having my old domain permalink and im afraid that it will cause error since you said RSS depends on guid. How to solve this problem?
This is not a problem. RSS does not *depend* on it in the way you think.
The guid is an unique identifier for an item in ones RSS feed. But as I mention above, the guid is taken simply as a string (an unique string, but a string nonetheless). There is nothing in the RSS specification that requires it to be the url or permalink for the article being syndicated. The WordPress developers chose to stick the permalink in there because the permalink for each post will be, by definition, unique.
So again, it just needs to be an unique string. Nothing more.
So i don’t need to change all the old permalink to new permalink right?
