Plugin: Database Search & Replace

Extremly detailed article on manually searching and replacing.

Search-replace from command line

If you can install WP-CLI, superior way is to use WP-CLI search-replace command.

I have used a PHP CLI script called Search-Replace-DB and I am quite satisfied. Read about it here.

This is how you install it

cd /var/www/vhosts/hostingtipp.ch
wget https://github.com/interconnectit/Search-Replace-DB/archive/master.zip
unzip master.zip && rm master.zip && mv Search-Replace-DB-master srdb
chmod a+x srdb/srdb.cli.php

And use it with

cd /var/www/vhosts/hostingtipp.ch
srdb/srdb.cli.php --dry-run -h localhost -u hostingtipp-ch -p "S06d7#mw" -n hostingtipp-ch -s "http://www.hostingtipp.ch/wp-content/" -r "/wp-content/"

Search-replace with a plugin

Sometimes I need to do a lot of replacement, so a nicer way is needed - as a Wordpress plugin. So decided to do a research on this.

The same Search-Replace-DB script is converted to a plugin and is found under the name Better Search Replace. Read more details about it here.

Also very flexible is Search Regex, but it doesn’t search in wp_options table and probably not in any unknown plugin table, because it does not support serialized data.

Note: This is almost perfect plugin. Just read more here

The most famous one is Search and Replace but it’s incredible how shitty it is.

• The Replace Contents plugin performs search and replace on HTML content and is authored by my favorite Japanese minimalist developer.