The SQL you need to execute to change a Wordpress site from one host to the other

move-site-wordpress-mysql-settings.sql

# Update the options for site settings:

UPDATE wp_options 
    SET
        option_value = replace(
            option_value,
            'http://oldsite.com/path',
            'http://spankingnew.com/otherpath'
        )
    WHERE
        option_name = 'home'
    OR
        option_name = 'siteurl';

# Update the post contents and the post slugs/urls at the same time:

UPDATE wp_posts 
    SET
        post_content = replace(
            post_content,
            'http://oldsite.com/path',
            'http://spankingnew.com/otherpath'
        ),
        guid = replace(
            guid,
            'http://oldsite.com/path',
            'http://spankingnew.com/otherpath'
        );

wp_options.php

<?php

// In /wp-config.php, add this:

define('WP_HOME','http://spankingnew.com/otherpath');
define('WP_SITEURL','http://spankingnew.com/otherpath');

?>