Find and replace with a WordPress plugin
The easiest option for replacing data within your WordPress database is to use a plugin. They're useful for changing the domain, or any other information for your WordPress site. A common plugin used for this is Search & Replace by Inpsyde.
-
Log in to WordPress.
-
Search for and install the Search & Replace plugin.
-
Activate the plugin.
-
Go to Tools > Search & Replace.
-
Under the Backup Database tab, click on Create SQL File.
Note: This will create a backup of your database before making any changes.
-
Pick a set of steps based on what you need to replace:
Change WordPress domain URL
- Click on the Replace Domain URL tab.
- Enter your new domain into the 'Replace with' field.
- Click Do Replace Domain/Url.
Replace other data
- Click on the Search & Replace tab.
- Fill out the 'Search for' field with the data you want replaced.
- Fill out the 'Replace with' field with the new data.
- Click Do Search & Replace.
More info
Section titled “More info”- Check out the developer's plugin page for more information about the Search & Replace plugin.