Manually change WordPress’ home and siteurl in MySQL
In my tidy process, I had to copy WordPress from one host to another, then access it from various URLs so that the production and the development versions were both accessible from the same public IP. To duplicate the data in a fast manner, I dumped the SQL data and tarred the WWW directory. The problem is that WordPress' home and siteurl are kept the same between those instances. And since you try to access the administration zone, you’re redirected to the original location… To modify the duplicated instance, you can configure WordPress straight from MySQL. Here are the directions:
Move your OSX home folder to a second disk
Those are the commands I use to tell OSX to use my second hard drive as the /Users mount point.