thedxw/srdb repository overview

SRDB is a command-line tool for searching and replacing values within a database, designed not to damage serialised objects. It is intended for use when migrating WordPress databases but is suitable for any similar problem.

This command-line tool is almost entirely based on interconnect/it's excellent search & replace tool:

http://interconnectit.com/products/search-and-replace-for-wordpress-databases/⁠

We just wanted something to run on the command-line, so we modified it.

Installation:

Clone the repository at:

https://github.com/dxw/srdb

and run:

$ git submodule update --init

Usage: srdb [options]

Arguments:

search String to look for replace String to replace matches with

Options:

-h MySQL server hostname. (Default: localhost) -p MySQL user's password -u MySQL account name (Default: root) -d MySQL database (Default: wordpress) --tables Comma-separated list of tables to search within (Default: all tables)