How to replace the domain name in a WordPress database?

I have a WordPress database which was installed in a development environment… thus, all references to the site itself have a fixed IP address (say 192.168.16.2). Now, I have to migrate that database to a new WordPress installation on a hosting. The problem is that the SQL dump contains a lot of references to the IP address, and I have to replace it with: my_domain.com.

Migrating data between local and development server

I’ve been working away at a medium-size WordPress site. So far I’ve just been hosting the site on my local machine and showing it to internal consultants over our local network. Things are working well, and now it’s time to show it off to the client. I’ve been using git all along, so pushing it to the dev server was a breeze. I duplicated the local DB and pushed it to the dev server manually, which was fairly easy except that I had to manually change a few URL entries.