Moving WordPress Sites Server To Server
UPDATE `wp_posts` SET `post_content` = REPLACE(post_content, 'http://localdomain.dev', 'http://livedomain.com'); UPDATE `wp_posts` SET `post_excerpt` = REPLACE(post_excerpt, 'http://localdomain.dev', 'http://livedomain.com'); UPDATE `wp_posts` SET `guid` = REPLACE(guid, 'http://localdomain.dev','http://livedomain.com'); UPDATE `wp_options` SET `option_value` = REPLACE(option_value, 'http://localdomain.dev', 'http://livedomain.com'); UPDATE `wp_postmeta` SET `meta_value` = REPLACE(meta_value, 'http://localdomain.dev', 'http://livedomain.com');