This sql file will update the URLs in all relevant WordPress tables when you move a site form one domain to another. Simply change the variables at the top to your URLs and execute it.

wp-update-url.sql

SET @wp_url_old = 'http://oldurl.com', @wp_url_new = 'http://newurl.com';

UPDATE wp_options SET option_value = replace( option_value, @wp_url_old, @wp_url_new ) 
	WHERE option_value LIKE CONCAT( '%', @wp_url_old, '%' );

UPDATE wp_posts SET guid = replace( guid, @wp_url_old, @wp_url_new );

UPDATE wp_posts SET post_content = replace( post_content, @wp_url_old, @wp_url_new );

UPDATE wp_postmeta SET meta_value = replace( meta_value, @wp_url_old, @wp_url_new );