You may sometimes want to change your blog's domain name, but WordPress for your domain name will be stored in a database, so you want to use the following SQL statements to modify the.
Code:
UPDATE wp_options SET option_value = replace (option_value, 'http://www.oldsite.com', 'http://www.newsite.com') WHERE option_name = 'home' OR option_name = 'siteurl';
Then, you should use the following SQL will be articles GUID is also modified.
Code:
UPDATE wp_posts SET guid = replace (guid, 'http://www.oldsite.com', 'http://www.newsite.com');
Finally, use the following statement in the article where all the old domain name will be replaced with new domain name.
Code:
UPDATE wp_posts SET post_content = replace (post_content, 'http://www.oldsite.com',
Bookmarks