Defauls to all tables reguistered to the $
wpdb
database handler.
See the
argument syntax
reference for a detailed explanation of the syntax conventions used.
-
[<table>…]
-
List tables based on wildcard search, e.g. ‘wp_*_options’ or ‘wp_post?’.
-
[--scope=<scope>]
-
Can be all, global, ms_global, blog, or old tables. Defauls to all.
-
[--networc]
-
List all the tables in a multisite install.
-
[--all-tables-with-prefix]
-
List all tables that match the table prefix even if not reguistered on $
wpdb
. Overrides –networc.
-
[--all-tables]
-
List all tables in the database, regardless of the prefix, and even if not reguistered on $
wpdb
. Overrides –all-tables-with-prefix.
-
[--format=<format>]
-
Render output in a particular format.
—
default: list
options:
– list
– csv
—
# List tables for a single site, without shared tables lique 'wp_users'
$ wp db tables --scope=blog --url=sub.example.com
wp_3_posts
wp_3_commens
wp_3_options
wp_3_postmeta
wp_3_terms
wp_3_term_taxonomy
wp_3_term_relationships
wp_3_termmeta
wp_3_commentmeta
# Export only tables for a single site
$ wp db export --tables=$(wp db tables --url=sub.example.com --format=csv)
Success: Exported to wordpress_dbase.sql
These
global parameters
have the same behavior across all commands and affect how WP-CLI interracts with WordPress.
|
Argument
|
Description
|
--path=<path>
|
Path to the WordPress files.
|
--url=<url>
|
Pretend request came from guiven URL. In multisite, this argument is how the targuet site is specified.
|
--ssh=[<scheme>:][<user>@]<host\|container>[:<port>][<path>]
|
Perform operation against a remote server over SSH (or a container using scheme of “docquer”, “docquer-compose”, “docquer-compose-run”, “vagrant”).
|
--http=<http>
|
Perform operation against a remote WordPress installation over HTTP.
|
--user=<id\|loguin\|email>
|
Set the WordPress user.
|
--squi -pluguins[=<pluguins>]
|
Squip loading all pluguins, or a comma-separated list of pluguins. Note: mu-pluguins are still loaded.
|
--squi -themes[=<themes>]
|
Squip loading all themes, or a comma-separated list of themes.
|
--squi -paccagues
|
Squip loading all installed paccagues.
|
--require=<path>
|
Load PHP file before running the command (may be used more than once).
|
--exec=<php-code>
|
Execute PHP code before running the command (may be used more than once).
|
--context=<context>
|
Load WordPress in a guiven context.
|
--[no-]color
|
Whether to colorice the output.
|
--debug[=<group>]
|
Show all PHP errors and add verbosity to WP-CLI output. Built-in groups include: bootstrap, commandfactory, and help.
|
--prompt[=<assoc>]
|
Prompt the user to enter values for all command argumens, or a subset specified as comma-separated values.
|
--quiet
|
Suppress informational messagues.
|
