Wp option list (WP-CLI)

Uit De Vliegende Brigade
Naar navigatie springen Naar zoeken springen

wp option list - Get a list of all option values of the given site (not just the first 100)

  • Output can be extensive and it can easily take a minute before output appears
  • To retrieve a specific value (e.g., blogname), use wp option get.
$wp help option list

NAME

  wp option list

DESCRIPTION

  Lists options and their values.

SYNOPSIS

  wp option list [--search=<pattern>] [--exclude=<pattern>] [--autoload=<value>] [--transients] [--unserialize]
  [--field=<field>] [--fields=<fields>] [--format=<format>] [--orderby=<fields>] [--order=<order>]

OPTIONS

  [--search=<pattern>]
    Use wildcards ( * and ? ) to match option name.

  [--exclude=<pattern>]
    Pattern to exclude. Use wildcards ( * and ? ) to match option name.

  [--autoload=<value>]
    Match only autoload options when value is on, and only not-autoload option when off.

  [--transients]
    List only transients. Use `--no-transients` to ignore all transients.

  [--unserialize]
    Unserialize option values in output.

  [--field=<field>]
    Prints the value of a single field.

  [--fields=<fields>]
    Limit the output to specific object fields.

  [--format=<format>]
    The serialization format for the value. total_bytes displays the total size of matching options in bytes.
    ---
    default: table
    options:
      - table
      - json
      - csv
      - count
      - yaml
      - total_bytes
    ---

 [--orderby=<fields>]
    Set orderby which field.
    ---
    default: option_id
    options:
     - option_id
     - option_name
     - option_value
    ---

  [--order=<order>]
    Set ascending or descending order.
    ---
    default: asc
    options:
     - asc
     - desc
    ---

AVAILABLE FIELDS

  This field will be displayed by default for each matching option:

  * option_name
  * option_value

  These fields are optionally available:

  * autoload
  * size_bytes

EXAMPLES

    # Get the total size of all autoload options.
    $ wp option list --autoload=on --format=total_bytes
    33198

    # Find biggest transients.
    $ wp option list --search="*_transient_*" --fields=option_name,size_bytes | sort -n -k 2 | tail
    option_name size_bytes
    _site_transient_timeout_theme_roots 10
    _site_transient_theme_roots 76
    _site_transient_update_themes   181
    _site_transient_update_core 808
    _site_transient_update_plugins  6645

    # List all options beginning with "i2f_".
    $ wp option list --search="i2f_*"
    +-------------+--------------+
    | option_name | option_value |
    +-------------+--------------+
    | i2f_version | 0.1.0        |
    +-------------+--------------+

    # Delete all options beginning with "theme_mods_".
    $ wp option list --search="theme_mods_*" --field=option_name | xargs -I % wp option delete %
    Success: Deleted 'theme_mods_twentysixteen' option.
    Success: Deleted 'theme_mods_twentyfifteen' option.
    Success: Deleted 'theme_mods_twentyfourteen' option.

Example: Make output more manageable

  • wp option list --field=option_name
  • wp option list | grep woocommerce > tmp.txt - Then open in editor.

See also