SQL queries to switch domain on WP site.

wp-switch-domain.sql

# If you get an error about illegal mixes of collation you might need to force the collation.
# SET NAMES 'utf8' COLLATE 'utf8_unicode_ci';

SET @old_url = 'http://www.oldurl.com';
SET @new_url = 'http://www.newurl.com';

UPDATE wp_options SET option_value = replace(option_value, @old_url, @new_url) WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET guid = replace(guid, @old_url, @new_url);
UPDATE wp_posts SET post_content = replace(post_content, @old_url, @new_url);
UPDATE wp_postmeta SET meta_value = replace(meta_value, @old_url, @new_url);