redirecting to localhost
Posted by Raza Ali on February 6, 2008
Issue: when you upload your wordpress site to server and import your DB, then opening your site url redirect to localhost domain. e.g; http://www.sample.com/mywordpress redirects to http://localhost/mywordpress.
Solution: When you upload your site with import db from your localhost, not configuring it on the server. wp-options,table, has the information to where to redirect it, so what you need delete all tables from your server DB except wp-options and export all tables from your localhost DB except wp-options then import these tables to your server DB. 
Mihai said
i had some troubles with this! based on your post i find out that you have to modify entry no.39 in table ‘wp_options’, option name ‘home’! i was tryng to access the blog with my personal ip ex: http://ip/wordpress/ and it was poining to http://localhost/wordpress/ making impossible to access from another computer on the internet ! thanks & forgive my poor english! that solve my problem.