After I moved from localhost to reside, Used to do a find and replace on my small database for anything with http://localhost and switched it with my new url. Now I have got an issue of my admin panel redirecting towards the site root.

I observed my url for admin gets re-written and re-directed before signing in.

Say i visited http://www.mysites.com/wp-admin/

The url changes to http://www.mysites.com/wp-login.php?redirect_to=http%3A%2F%2Fmysites.com&reauth=1

What's screwed up during my database? :(