I want to restore a copy of a database that I created previously with PHPMyAdmin Export function.

I dropped ALL the tables from the destination database where I want to restore the data.

I ran the Import function.
Success message appeared:
"Import has been successfully finished, 432 queries executed."

Then I try to load WordPress in my browser - nothing!
This error message:
"Redirect Loop


Firefox has detected that the server is redirecting the request for this address in a way that will never complete.

The browser has stopped trying to retrieve the requested item. The site is redirecting the request in a way that will never complete."

Whats going on??

Try this plugin disable-canonical-redirects.phps hopefully it will solve your issues. This assume that only you home page has redirect problem or are you not even able to go to your admin screen?

You might find something here that can solve your problem.

http://wordpress.org/support/topic/224332