There is a simple way to update WordPress options with the new blog location. You can just type the following SQL command:
UPDATE wp_options SET option_value = replace(option_value, 'http://www.old-domain.com', 'http://www.new-domain.com') WHERE option_name = 'home' OR option_name = 'siteurl';
After you've done that, you have to fix URLs of the WordPress posts and pages, which translated from post slug, and stored in database wp_posts table as guid field.
You must change The URL values in this field using the following SQL query below because The URL values are stored as absolute URLs instead of relative URLs. Here the query:
UPDATE wp_posts SET guid = replace(guid, 'http://www.old-domain.com','http://www.new-domain.com');
The next to be fixed is an internal link problem. If you have linked internally within blog posts or pages with absolute URLs, these links will point to wrong locations after you move the blog location. To do the correction and fix all internal links to own blog in all WordPress posts and pages, you can use the following SQL commands :
UPDATE wp_posts SET post_content = replace(post_content, 'http://www.old-domain.com', 'http://www.new-domain.com');
Now, using all tips above, you can easily move your Wordpress blog to a new domain.
