Download the PHP package wp-cli/search-replace-command without Composer

On this page you can find all versions of the php package wp-cli/search-replace-command. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

  • Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
  • To use Composer is sometimes complicated. Especially for beginners.
  • Composer needs much resources. Sometimes they are not available on a simple webspace.
  • If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
  • Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Please rate this library. Is it a good library?

Informations about the package search-replace-command

wp-cli/search-replace-command

Searches/replaces strings in the database.

Testing

Quick links: Support

Using

wp search-replace <old> <new> [<table>...] [--dry-run] [--network] [--all-tables-with-prefix] [--all-tables] [--export[=<file>]] [--export_insert_size=<rows>] [--skip-tables=<tables>] [--skip-columns=<columns>] [--include-columns=<columns>] [--precise] [--recurse-objects] [--verbose] [--regex] [--regex-flags=<regex-flags>] [--regex-delimiter=<regex-delimiter>] [--regex-limit=<regex-limit>] [--format=<format>] [--report] [--report-changed-only] [--log[=<file>]] [--before_context=<num>] [--after_context=<num>]

Searches through all rows in a selection of tables and replaces appearances of the first string with the second string.

By default, the command uses tables registered to the $wpdb object. On multisite, this will just be the tables for the current site unless --network is specified.

Search/replace intelligently handles PHP serialized data, and does not change primary key values.

OPTIONS

<old>
    A string to search for within the database.

<new>
    Replace instances of the first string with this new string.

[<table>...]
    List of database tables to restrict the replacement to. Wildcards are
    supported, e.g. `'wp_*options'` or `'wp_post*'`.

[--dry-run]
    Run the entire search/replace operation and show report, but don't save
    changes to the database.

[--network]
    Search/replace through all the tables registered to $wpdb in a
    multisite install.

[--all-tables-with-prefix]
    Enable replacement on any tables that match the table prefix even if
    not registered on $wpdb.

[--all-tables]
    Enable replacement on ALL tables in the database, regardless of the
    prefix, and even if not registered on $wpdb. Overrides --network
    and --all-tables-with-prefix.

[--export[=<file>]]
    Write transformed data as SQL file instead of saving replacements to
    the database. If <file> is not supplied, will output to STDOUT.

[--export_insert_size=<rows>]
    Define number of rows in single INSERT statement when doing SQL export.
    You might want to change this depending on your database configuration
    (e.g. if you need to do fewer queries). Default: 50

[--skip-tables=<tables>]
    Do not perform the replacement on specific tables. Use commas to
    specify multiple tables. Wildcards are supported, e.g. `'wp_*options'` or `'wp_post*'`.

[--skip-columns=<columns>]
    Do not perform the replacement on specific columns. Use commas to
    specify multiple columns.

[--include-columns=<columns>]
    Perform the replacement on specific columns. Use commas to
    specify multiple columns.

[--precise]
    Force the use of PHP (instead of SQL) which is more thorough,
    but slower.

[--recurse-objects]
    Enable recursing into objects to replace strings. Defaults to true;
    pass --no-recurse-objects to disable.

[--verbose]
    Prints rows to the console as they're updated.

[--regex]
    Runs the search using a regular expression (without delimiters).
    Warning: search-replace will take about 15-20x longer when using --regex.

[--regex-flags=<regex-flags>]
    Pass PCRE modifiers to regex search-replace (e.g. 'i' for case-insensitivity).

[--regex-delimiter=<regex-delimiter>]
    The delimiter to use for the regex. It must be escaped if it appears in the search string. The default value is the result of `chr(1)`.

[--regex-limit=<regex-limit>]
    The maximum possible replacements for the regex per row (or per unserialized data bit per row). Defaults to -1 (no limit).

[--format=<format>]
    Render output in a particular format.
    ---
    default: table
    options:
      - table
      - count
    ---

[--report]
    Produce report. Defaults to true.

[--report-changed-only]
    Report changed fields only. Defaults to false, unless logging, when it defaults to true.

[--log[=<file>]]
    Log the items changed. If <file> is not supplied or is "-", will output to STDOUT.
    Warning: causes a significant slow down, similar or worse to enabling --precise or --regex.

[--before_context=<num>]
    For logging, number of characters to display before the old match and the new replacement. Default 40. Ignored if not logging.

[--after_context=<num>]
    For logging, number of characters to display after the old match and the new replacement. Default 40. Ignored if not logging.

EXAMPLES

# Search and replace but skip one column
$ wp search-replace 'http://example.test' 'http://example.com' --skip-columns=guid

# Run search/replace operation but dont save in database
$ wp search-replace 'foo' 'bar' wp_posts wp_postmeta wp_terms --dry-run

# Run case-insensitive regex search/replace operation (slow)
$ wp search-replace '\[foo id="([0-9]+)"' '[bar id="\1"' --regex --regex-flags='i'

# Turn your production multisite database into a local dev database
$ wp search-replace --url=example.com example.com example.test 'wp_*options' wp_blogs wp_site --network

# Search/replace to a SQL file without transforming the database
$ wp search-replace foo bar --export=database.sql

# Bash script: Search/replace production to development url (multisite compatible)
#!/bin/bash
if $(wp --url=http://example.com core is-installed --network); then
    wp search-replace --url=http://example.com 'http://example.com' 'http://example.test' --recurse-objects --network --skip-columns=guid --skip-tables=wp_users
else
    wp search-replace 'http://example.com' 'http://example.test' --recurse-objects --skip-columns=guid --skip-tables=wp_users
fi

Installing

This package is included with WP-CLI itself, no additional installation necessary.

To install the latest version of this package over what's included in WP-CLI, run:

wp package install [email protected]:wp-cli/search-replace-command.git

Contributing

We appreciate you taking the initiative to contribute to this project.

Contributing isn’t limited to just code. We encourage you to contribute in the way that best fits your abilities, by writing tutorials, giving a demo at your local meetup, helping other users with their support questions, or revising our documentation.

For a more thorough introduction, check out WP-CLI's guide to contributing. This package follows those policy and guidelines.

Reporting a bug

Think you’ve found a bug? We’d love for you to help us get it fixed.

Before you create a new issue, you should search existing issues to see if there’s an existing resolution to it, or if it’s already been fixed in a newer version.

Once you’ve done a bit of searching and discovered there isn’t an open or fixed issue for your bug, please create a new issue. Include as much detail as you can, and clear steps to reproduce if possible. For more guidance, review our bug report documentation.

Creating a pull request

Want to contribute a new feature? Please first open a new issue to discuss whether the feature is a good fit for the project.

Once you've decided to commit the time to seeing your pull request through, please follow our guidelines for creating a pull request to make sure it's a pleasant experience. See "Setting up" for details specific to working on this package locally.

Support

GitHub issues aren't for general support questions, but there are other venues you can try: https://wp-cli.org/#support

This README.md is generated dynamically from the project's codebase using wp scaffold package-readme (doc). To suggest changes, please submit a pull request against the corresponding part of the codebase.

All versions of search-replace-command with dependencies

PHP Build Version
Package Version
Requires wp-cli/wp-cli Version ^2.5
Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package wp-cli/search-replace-command contains the following files

Loading the files please wait ....