WordPress Move to SSL How to Update Media Assets to HTTPS?

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:

Updating your home and site URL

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“.

SSL mixed content issue (grey lock)

Try one of the two options:

1. Third-party: Search/Replace DB

There’s a third-party tool tool that allows you

  1. Go and download Interconnect IT’s Database Search & Replace Script here
  2. Unzip the file and drop the folder in your localhost where your WordPress is installed (the root) and rename the folder to replace (screenshot)
  3. Navigate to the new folder you created in your browser (ex: http://web.site/replace) and you will see the search/replace tool
  4. It should be pretty self-explanatory up to this point: enter your old URL in the search for… field and the new URL in the replace 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.

Leave a Comment