How To Mass Replace URLs to HTTPS in the WordPress Database

How to replace URLs tutorial

If you decide to change your domain name, or perhaps have finally gotten the dot com version of your domain, it is essential that you change and update all the old URLS in the database to the new URL. If not, many links on your page and  content such as images will likely be broken and not work.

In addition to this, when you add an SSL certificate to your site, you would need to replace all URLs in the database to https. No need to do this all manually! With the download of the free plugin 'Search & Replace', you can do this all easily.

This tutorial will show you how to use the "Search & Replace" plugin to replace all URLs or any text data in the WordPress database without going through a lot of technical steps.

Step 1:

  • Login to your WP Admin, then click "Plugins" on the admin sidebar
  • Click on "Add New"
  • Search for the "Search & Replace" plugin
  • Click "Install Now" and "Activate" button

Install Search and Replace plugin

Step 2:

  • The plugin settings will be available in "Tools > Search & Replace".
  • Click on "Search & Replace" tab.
  • In the list of tables, just check "wp_postmeta". Note that wp_postmeta is the database table where Themify Builder stores the data in. Selecting wp_postmeta table would only affect the data in the postmeta table. If you want to replace data in the entire database, check "Select all tables".
  • In the "Search for:" field, enter the text that you want to search for.
  • In the "Replace with:" field, enter the text that you want to replace. Let's say you want to replace all site URLs to https, you would enter your domain (eg. "http://yourdomain.com") in the "Search for:" field and enter the https domain (eg. "https://yourdomain.com") in the "Replace with:" field. You can pretty much replace any text data in the database, but this tutorial just demonstrates on how to replace URLs.
  • Click "Dry Run" to make a test run.  Running a "Dry Run" shows what would be replaced in the database.
  • Once you are happy with dry run, uncheck "Dry Run", select "Save changes to database" and click "Do Search & Replace"

Dry Run

And then you're done!

We hope that you all enjoy this tutorial and find it helpful. Please feel free to share if you found it helpful, and what future tutorials you are looking forward to seeing in the comments below. Enjoy!

Read More

Horizontal Scrolling Now Available with Ultra and Fullpane

To all our Fullpane and Ultra fans, we have good news! We've added a brand new feature to both themes – horizontal scrolling! As one of the most commonly requested features, you can now scroll horizontally with the section scrolling feature.


Read More

How to Add Breadcrumb Navigation to Themify Themes!

breadcrumb navigation tutorial image

Breadcrumb Navigation is a type of secondary navigation that shows the user where they are currently on a website. This is a very simple but highly requested tutorial for you all to enjoy! (more…)

Read More

How To Create a Cool 3D Tilt Effect With Themify Builder

3D Titl Demo

3D Tilt is a fun new way for users to experience your website. Instead of having all your images and text static, 3D Tilt allows images and text to float and glide slightly as the user moves their cursor over each item.

Check out our demo to get a taste of 3D Tilt.


Read More

How to Make a Fullcover Row Background with Themify Builder

Fullcover Row Background tutorial

Instead of using a regular white background for your website, why not try using an image that fully covers your page? We think it could help create a minimal looking site that is both sleek and modern. To achieve this look, you'll need to insert some custom code – but fear not, for we've provided easy step-by-step instructions.


Read More

How to Set Font Styling for Mobile, Tablet, & Desktop with the Builder Responsive Styling

In our second instalment of our tutorial series on responsive styling, we will showcase how to set specific fonts for mobile tablet, and desktop. By default, all paragraph and heading font styling are responsive across resolutions. This means that when you resize your browser it’ll shrink automatically to ensure your font fits the resolution you’re viewing it in. (more…)

Read More

Sign up now for the WordPress Birthday Competition for a chance to get featured & win a Master Club!