wp db
Performs basic database operations using credentials stored in wp-config.php
Subcommands
| Name | Description |
|---|
check | Checks the current status of the database |
clean | Removes all tables with `$table_prefix` from the database |
cli | Opens a MySQL console using credentials from wp-config.php |
columns | Displays information about a given table |
create | Creates a new database |
drop | Deletes the existing database |
export | Exports the database to a file or to STDOUT |
import | Imports a database from a file or from STDIN |
optimize | Optimizes the database |
prefix | Displays the database table prefix |
query | Executes a SQL query against the database |
repair | Repairs the database |
reset | Removes all tables from the database |
search | Finds a string in the database |
size | Displays the database name and size |
tables | Lists the database tables |
Options
| Name | Description |
|---|
--path <path> | Path to the WordPress files |
--url <url> | Pretend request came from given URL. In multisite, this argument is how the target site is specified |
--ssh <options> | Perform operation against a remote server over SSH (or a container using scheme of “docker”, “docker-compose”, “vagrant”) |
--http <http> | Perform operation against a remote WordPress installation over HTTP |
--user <options> | Set the WordPress user |
--skip-plugins | Skip loading all plugins, or a comma-separated list of plugins. Note: mu-plugins are still loaded |
--skip-plugins <plugins> | Skip loading all plugins, or a comma-separated list of plugins. Note: mu-plugins are still loaded |
--skip-themes | Skip loading all themes, or a comma-separated list of themes |
--skip-themes <themes> | Skip loading all themes, or a comma-separated list of themes |
--skip-packages | Skip loading all installed packages |
--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) |
--color | Whether to colorize the output |
--no-color | Whether to colorize the output |
--debug | Show all PHP errors and add verbosity to WP-CLI output. Built-in groups include: bootstrap, commandfactory, and help |
--debug <group> | Show all PHP errors and add verbosity to WP-CLI output. Built-in groups include: bootstrap, commandfactory, and help |
--prompt | Prompt the user to enter values for all command arguments, or a subset specified as comma-separated values |
--prompt <assoc> | Prompt the user to enter values for all command arguments, or a subset specified as comma-separated values |
--quiet | Suppress informational messages |