This free script will help you move your WordPress websites easily without breaking the serialization in the database which occurs with some other methods. I develop nearly all of the sites I build on my localhost development server. In the past when moving sites online from my localhost I’ve exported the sql file from the database, opened the file in Programmer’s Notepad, and ran a search and replace on the urls before uploading it to the new database. This worked but I always ended up losing all of my theme options settings because it broke the serialization. Then I found this free database search and replace tool from the WordPress gurus at interconnectit.com.
After uploading your files and the database from my local version and updating the WP configuration file, it’s as simple as running this simple search and replace tool on the urls in the database. In my case I’m usually replacing http://localhost/ with the domain of the website I’m setting up. Update the links using the search and replace tool, don’t forget to delete it afterwards, go into the WordPress administration and update the permalinks. Test your site.
UF2JXSCRG8XX
