Needless to say, it's never been something I've looked forward to.
Then yesterday, while moving a site for a client, I said screw it and started searching for plugins.
That's when I stumbled onto "All-In-One WP Migration".
Damn, man. I couldn't believe it was actually going to work, until it did.
Install the plugin, download the .wpress file, and then install Wordpress on your new host. Upload the plugin to the new host, and import the .wpress file.
Boom, site transferred.
I donated $500 to the dude. He's saved me so much time it's not even funny.
By the way, I have no affiliation to the guy, just so stoked that it worked that I had to donate and share it with the rest of the world.
So if you've gotta move a site, or develop on a test server and need to migrate once you're done, check out that plugin. Seriously simple.
There's a lesson in there about solving people's problems and getting paid handsomely for it, too.