logo
Ask your WordPress questions! Pay money and get answers fast! (more info)

This is an old version of this answer!

Return to the current answer
Here 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');

idt | 05/13/12 at 2:40am

This is an old version of this answer!

Return to the current answer