wp-migrate.sql

-- Update options (site url, home)
--
UPDATE wp_options 
SET option_value = REPLACE( option_value, 'http://url1', 'http://url2' )
WHERE option_value LIKE 'http://%';

-- Update post content
--
UPDATE wp_posts
SET post_content = REPLACE( post_content, 'http://url1', 'http://url2' );

-- Update meta variables that may contain old links
--
UPDATE wp_postmeta
SET meta_value = REPLACE( meta_value, 'http://url1', 'http://url2' );

UPDATE wp_options 
SET option_value = REPLACE( option_value, 'http://meuller.pw', 'http://nick' )
WHERE option_value LIKE 'http://%';