This is an old version of this answer!
Return to the current answerHere are the tables you may need to check and change value to your new domain:
wp_options - site_url and home
wp_blogs - domain
wp_site - domain and path
wp_sitemeta - site_url
You also need to update each of the wp_*_options (e.g. wp_1_ , wp_2_, wp_3_) table and adjust the fields site_url and home
Then this:
UPDATE wp_posts SET guid = REPLACE (guid, 'http://oldsiteurl.com', 'http://newsiteurl.com');
UPDATE wp_posts SET guid = REPLACE (post_content, 'http://oldsiteurl.com', 'http://newsiteurl.com');
wp_options - site_url and home
wp_blogs - domain
wp_site - domain and path
wp_sitemeta - site_url
You also need to update each of the wp_*_options (e.g. wp_1_ , wp_2_, wp_3_) table and adjust the fields site_url and home
Then this:
UPDATE wp_posts SET guid = REPLACE (guid, 'http://oldsiteurl.com', 'http://newsiteurl.com');
UPDATE wp_posts SET guid = REPLACE (post_content, 'http://oldsiteurl.com', 'http://newsiteurl.com');
idt | 05/13/12 at 2:40am
