WP-CLI Database Functions Cheat Sheet

A Software › WordPress cheat sheet in English by wirehead

Database functions for the Wordpress command line interface

MySQL Database Command Line WordPress Wp-cli

7,082 views 1,284 downloads 21 Dec 2021 History

PRs

Informational

`wp db check`	check the current status of the database
`wp db size`	display the database name and size
`wp db prefix`	display the database table prefix
`wp db tables`	lists the database tables
`wp db columns`	display information about a given table

Manipulation

`wp db import`	imports a database
`wp db export`	exports the database
`wp db search`	finds a string in the database
`wp db query`	executes a SQL query

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

# Execute a query from prompt
$ wp db query '<query>'

DB Functions

This sheet is a quick reference of the commands available to operate with and manipulate within a Wordpress database using wp-cli.

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

Operations

`wp db cli`	open a MySQL console
`wp db create`	create a new database
`wp db drop`	drop an existing database
`wp db reset`	reset the current database
OPTIONS	(create, drop, reset)
`[--dbuser=<value>]`	pass username to mysql Defaults to DB_USER
`[--dbpass=<value>]`	pass password to mysql Defaults to DB_PASSWORD
`[--yes]`	avoid confirmation message
`wp db optimize`	optimizes the database
`wp db repair`	repairs the database

Quick Help

wp db <subcommand> help

lists all options

This will provide further options and parameters available for the command and subcommand specified. The technique is applicable throughout the wp-cli.

Badges

Downloaded from Unusual Locations × 2

Comments (1)

tripdog 21:44 29 Mar 2022

Very useful!