It’s a fairly common issue when you update your WordPress site’s URL from HTTP to HTTPS or if you are migrating to a new domain. While the WordPress (home
) and Site (siteurl
) address have been updated to the new HTTPS link:
However, that doesn’t mean that your SSL structure in your posts will be fixed. This results in some of your pages pointing to your HTTP link instead, AKA “getting mixed content warnings“.
Try one of the two options:
1. Third-party: Search/Replace DB
There’s a third-party tool tool that allows you
- Go and download Interconnect IT’s Database Search & Replace Script here
- Unzip the file and drop the folder in your localhost where your WordPress is installed (the root) and rename the folder to
replace
(screenshot) - Navigate to the new folder you created in your browser (ex:
http://web.site/replace
) and you will see the search/replace tool - It should be pretty self-explanatory up to this point: enter your old URL in the
search for…
field and the new URL in thereplace with…
field
2. Plugin: Search & Replace
If you don’t have access to your website’s source (via FTP, etc.) you can perform the same function by using the Search & Replace plugin within your WordPress site. The process is easy to use and you can also preview what tables and rows will be affected before applying those changes.
Edit: Michael Cropper
For those using the plugin route, I had to use the “Replace Domain URL” option to change from http://web.site to https://web.site, then download the SQL file, then upload this via phpMyAdmin. As always, backup DB before you do this as while this worked for me, may require a few tweaks for yourself.