wp db

EXAMPLES EXAMPLES

# Create a new database.
$ wp db create
Success: Database created.

# Drop an existing database.
$ wp db drop --yes
Success: Database dropped.

# Reset the current database.
$ wp db reset --yes
Success: Database reset.

# Execute a SQL query stored in a file.
$ wp db query < debug.sql

Top ↑

SUBCOMMANDS SUBCOMMANDS

Name Description
wp db check

Checks the current status of the database.

wp db clean

Removes all tables with `$table_prefix` from the database.

wp db cli

Opens a MySQL console using credentials from wp-config.php

wp db columns

Displays information about a given table.

wp db create

Creates a new database.

wp db drop

Deletes the existing database.

wp db export

Exports the database to a file or to STDOUT.

wp db import

Imports a database from a file or from STDIN.

wp db optimize

Optimizes the database.

wp db prefix

Displays the database table prefix.

wp db query

Executes a SQL query against the database.

wp db repair

Repairs the database.

wp db reset

Removes all tables from the database.

wp db search

Finds a string in the database.

wp db size

Displays the database name and size.

wp db tables

Lists the database tables.