WordPress.org

Plugin Reviews

Search & Replace

Search & Replace data in your database with WordPress admin, replace domains/URLs of your WordPress installation.

5 reviews
Average Rating
4.4 out of 5 stars
You are currently viewing the reviews that provided a rating of 2 stars. Click here to see all reviews.
Doesn't work
By , for WP 4.5.3

I tried to replace an URL with a new URL, but it doesn't work. I won't rate this 1/5 as this doesn't break my site.

Seems to have problems with latest version of WP
By , for WP 4.2.2

I've found this plugin useful in the past but now a search and replace of my database does not find any results. In my PHP error logs I see things like

WordPress database error COLLATION 'utf8_bin' is not valid for CHARACTER SET 'utf8mb4' for query SELECT * FROM wp_commentmeta WHEREmeta_idlike...

It seems like the recent changes to the WP database have caused some compatibility issues with this plugin.

Too simplistic, Does Not handle serialized strings
By , for WP 4.0

Many plugins use "serialized data", several settings put into one field in the database. The length of each setting string is stored along with the setting.

If you use a tool that replaces text without replacing the length of the text in the serialized data, your data is messed up for the plugin.

The Changelog says "Exclude serialized data from replace function".

Find another tool. I'm trying "WPEX Replace DB Urls" next, which specifically says "Serialized strings are also supported. You can replace a URL with another."

Powerful, confusing, dangerous
By , for WP 3.5.1

This plugin advises you to back up your database before using it, which is good, because it is really easy to shoot yourself in the foot with this plugin.

The user experience is confusing. It tries to get you to experiment before doing anything that will actually change data, which is great, but in doing so, it adds complexity and confusion.

I have a few ideas on making it clearer and safer.

  • For consistency, give people the option to limit the tables & fields they search agains in the trial/test section (it is currently only available when changing the database
  • Make the whole process more "wizzard-like." Hide the UI for the potentially destructive actions and only expose it once the user has made the trial actions
  • Require people to test the search/replace before allowing them to perform any changes on data.
  • Once people have done a trial run, don't let them change the search/replace data before performing changes on data unless they do a new trial run
  • Before performing changes, automatically make backup copies of the tables that will be changed

So, the flow would be:

  1. Click to the Search & Replace Screen
  2. Select fields and tables, enter search and replace criteria
  3. Click to run a trial query
  4. Review results
  5. Click to proceed with changing the database, or return to step #2 and alter the selected fields and criteria
  6. Confirm that you want to backup the tables and change the database
  7. Database table(s) is copied to a backup table(s), replace query is run
  8. User reviews results, is given the option of reverting to the backup tables
  9. If user clicks to approve of the results, they are then asked if they want to delete the backup.
  10. If they do not choose to delete the backup, the backup tables will be listed on a section of the main Search & Replace page where they can choose to delete them. If they don't choose to restore the backup immediately after running and reviewing the replace action, they are not given the option on the list of old backups. In order to reduce the chance that they accidentally restoring over new data, they will have to work directly with the database.
Soon as your page and post count gets higher, it simply fails
By , for WP 3.4.2

Its trying to allocate over 90MB of RAM to handle the search alone. We ended up building and using MySQL replace function directly in MySQL.

You must log in to submit a review. You can also log in or register using the form near the top of this page.