15 May 2018
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.
- 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
- 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"
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!