WordPress Website Transfer Find and Replace

You may need to do a search and replace on your WordPress site perhaps for the following reasons or you need to finalise the transfer of data from the local test website to the live server:

- Weird characters in blog entries after upgrade. After performing a WordPress upgrade, some characters will appear as "â€", "’", "??"
- Rename keyword1 to keyword2. You want to rename keyword1 in your entire database to keyword2, but opening the 100Mb database file with your text editor is not the smartest idea. After all, you’ll need to download a file as big as100Mb down before you can start changing, upload it before you can preview.
- You discovered a typo. You been using this phrase all the while and just realized it was wrongly spelled and want to search and replace all blog contents containing this typo.

When using the duplicator plugin, it does a great job of transferring data from a local site to the live server but data within plugins and certain cells in the database may not change. As such links to pages, posts and other content will not work. In fact the links will direct the user to the local site, which is obviously bad.
This script is very useful as it will crawl your database and change appropriate content. For example you may need to change the localtestsite.dev to domain.com. With this script you can so everything on your freshly transferred site is changed to the right link.
Here is the link to the script:
https://interconnectit.com/products/search-and-replace-for-wordpress-databases/

I hope the video helps.