Some SQL for quickly moving WordPress sites between servers.

wordpress-hostchange.sql

SET @FROMDOMAIN = 'myolddomain.com';
SET @TODOMAIN = 'mynewdomain.com';
SET @FROMSCHEME = 'http';
SET @TOSCHEME = 'http';


#-------------- STANDARD TABLES -------------#


UPDATE wp_options
	SET option_value = CONCAT(@TOSCHEME, '://', @TODOMAIN, '/')
WHERE option_name IN('siteurl', 'home');


#------------- MULTISITE TABLES -------------#


UPDATE wp_sitemeta 
	SET meta_value = CONCAT(@TOSCHEME, '://', @TODOMAIN, '/')
WHERE meta_key = 'siteurl';

UPDATE wp_blogs
	SET domain = @TODOMAIN
WHERE domain = @FROMDOMAIN COLLATE utf8_general_ci;

UPDATE wp_site
	SET domain = @TODOMAIN
WHERE domain = @FROMDOMAIN COLLATE utf8_general_ci;

UPDATE wp_domain_mapping
	SET domain = REPLACE(domain, @FROMDOMAIN, @TODOMAIN);