wp db

Performs basic database operations using credentials stored in wp-config.php

Subcommands

NameDescription
checkChecks the current status of the database
cleanRemoves all tables with `$table_prefix` from the database
cliOpens a MySQL console using credentials from wp-config.php
columnsDisplays information about a given table
createCreates a new database
dropDeletes the existing database
exportExports the database to a file or to STDOUT
importImports a database from a file or from STDIN
optimizeOptimizes the database
prefixDisplays the database table prefix
queryExecutes a SQL query against the database
repairRepairs the database
resetRemoves all tables from the database
searchFinds a string in the database
sizeDisplays the database name and size
tablesLists the database tables

Options

NameDescription
--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-pluginsSkip 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-themesSkip 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-packagesSkip 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)
--colorWhether to colorize the output
--no-colorWhether to colorize the output
--debugShow 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
--promptPrompt 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
--quietSuppress informational messages