I have downloaded my site to a production environment. I have set up both the live site and the production site to use the same DB. When i login to the admin panel i get redirected to the live site. I know that wordpress stores URLs in the DB so i want to modify (hard code) my production site not to redirect anywhere.
Where and how?
Edit: I found the solution to this particular problem here http://www.davidpaulellenwood.com/expression/267/
But when one problem was tackled two new ones appeared and as discussed below, it's not worth it.