When you want to change your domain name for wordpress site. You need to first take backup of your file system and mysql database. Make sure that backup is completely taken. Verify with any wordpress developer. Then only you start the migration.
I already written detail article for this. You should read following article.
http://wordpressapi.com/2010/02/27/wordpress-migration-hosting-service-domain/
Here is list of mysql queries which are very important when you are doing the wordpress site migration.
UPDATE wp_options SET option_value = REPLACE(option_value, 'oldsite.com', 'newsite.com'); UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, 'oldsite.com', 'newsite.com'); UPDATE wp_posts SET post_content = REPLACE(post_content, 'oldsite.com', 'newsite.com'); UPDATE wp_posts SET post_excerpt = REPLACE(post_excerpt, 'oldsite.com', 'newsite.com'); UPDATE wp_posts SET guid = REPLACE(guid, 'oldsite.com', 'newsite.com');






Really helpful for wordpress developers. I found useful.
This post makes a lot of sense !
Awesome post. I so good to see someone taking the time to share this information
Hello, this is my first time i visit here. I found so many interesting in your blog especially on how to determine the topic. keep up the good work.
Interesting read, perhaps the best article iv’e browse today. We learn everyday cheers to you!
Nice post! You truly have a wonderful way of writing which I find captivating! I will definitely be bookmarking you and returning to your blog. In fact, your post reminded me about a strange thing that happened to me the other day. I’ll tell you about that later…
I would like to say “wow” what a inspiring post. This is really great. Keep doing what you’re doing!!
Intriguing post. I have been searching for some good resources for solar panels and discovered your blog. Planning to bookmark this one!
Of course, what a great site and informative posts, I will add backlink – bookmark this site? Regards, Reader
I’ve just started off a blog, the knowledge you give on this site has aided me extremely. Thank you for all your time & work.
Good! Thank you! I always wanted to write in my site something like that. Can I take part of your post to my blog?
Hello, this is my first time i visit here. I found so many interesting in your blog especially on how to determine the topic. keep up the good work.
I’ve been checking your blog for a while now, seems like everyday I learn something new
Thanks
I REALLY liked your post and blog! It took me a minute bit to find your site…but I bookmarked it. Would you mind if I posted a link back to your post?
Great read. Thanks for the info!
I’ve been checking your blog for a while now, seems like everyday I learn something new
Thanks
Thanks for posting. Good to see that not everyone is using RSS feeds to build their blogs
Good! Thank you! I always wanted to write in my site something like that. Can I take part of your post to my blog?
I was just having a conversation over this I am glad I came across this it cleared some of the questions I had.
Awesome post. I so good to see someone taking the time to share this information
I was just having a conversation over this I am glad I came across this it cleared some of the questions I had.