Tried running this?
UPDATE <code>wp_posts</code> SET guid = replace(guid, 'oldurl','newurl');
UPDATE <code>wp_posts</code> SET post_content = replace(post_content, 'oldurl', 'newurl');
UPDATE <code>wp_postmeta</code> SET meta_value = replace(meta_value,'oldurl','newurl');
The best way I have found is with a backup restore plugin that does it all for you. I always use Akeeba BackupWP and Kickstart to restore the site and make all the necessary db updates. Akeebabackup.com
My preferred way to do this is to configure the localhost server to use the “VirtualHost” technique. Give it the same domain name, use your “hosts” file to tell your b rowser to redirect to the localhost server. The website barely knows that it has moved. Files and databases can be exchanged easily, especially when I match the database names and user etc from wp-config.php.
Configuring SSL is a little harder, similarly configuring email SMTP is not worth the trouble.
More details:
http://httpd.apache.org/docs/current/vhosts/name-based.html
https://en.wikipedia.org/wiki/Hosts_(file)
Take a look at the source code of your site ( CTRL-U ) and check the
tags and their “src” attribute. There you should see what exactly is wrong. I have a feeling it’s the path.