Wordpress Migration

wp_migration

$old_site = 'http://example.com';
$new_site = 'http://newsite.com';
$wpdb_prefix = 'wp';

# Replace slugs
update ${wpdb_prefix}_posts set guid = replace(guid, $old_site, $new_site);

# Replace title, excerpt and content
update ${wpdb_prefix}_posts set post_title = replace(post_title, $old_site, $new_site);
update ${wpdb_prefix}_posts set post_excerpt = replace(post_excerpt, $old_site, $new_site);
update ${wpdb_prefix}_posts set post_content = replace(post_content, $old_site, $new_site);

# Update site url
update ${wpdb_prefix}_options set option_value = '$new_site' where option_name ='home';
update ${wpdb_prefix}_options set option_value = '$new_site' where option_name ='siteurl';

# For serialized data
http://interconnectit.com/124/search-and-replace-for-wordpress-databases/