Change siteurl and baseurl in wp-options table. Also change the urls in your posts, refer http://gerardmcgarry.com/2010/wordpress-how-to-use-mysql-to-replace-the-url-in-your-posts/
Checked out the link provided but don´t see how I can change from OLD SITE to NEW SITE when they are both http://www.fotokunstner.no – just changed the hosting provider.
