WordPress URL Changer

wp_move.sql

/* update all post permalinks */
update wp_posts
set guid = REPLACE(guid, 'http://oldsite.com', 'http://newsite.com')
where guid LIKE '%http://oldsite.com%';

/* update all post content */
update wp_posts
SET post_content = REPLACE(post_content, 'http://oldsite.com', 'http://newsite.com')
where post_content LIKE '%http://oldsite.com%';

/* update all post meta */
update wp_postmeta
SET meta_value = REPLACE(meta_value, 'http://oldsite.com', 'http://newsite.com')
where meta_value LIKE '%http://oldsite.com%';

/* update all options */
update wp_options
set option_value = REPLACE(option_value, 'http://oldsite.com', 'http://newsite.com')
where option_value LIKE '%http://oldsite.com%';