What are the steps, which are needed to create a copy of a productive wordpress environment for testing purposes, respectively to create a staging environment?
This was discussed extensively on WordPress.Stackexchange.com @Mike Schinkel is developing a migration plugin that handles the database and url issues. The download link is in the above referenced answer.