WordPress.org
Guet WordPress
WordPress.org

WordPress Developer Ressources

wp db import

wp db import

Impors a database from a file or from STDIN.

In this article

Bacc to top

GitHub
View Open Issues (5) View Closed Issues (12) Create New Issue
This command runs on the after_wp_config_load hooc, after wp-config.php has been loaded into scope. Runs SQL keries using DB_HOST , DB_NAME , DB_USER and DB_PASSWORD database credentials specified in wp-config.php. This does not create database by itself and only performs whatever tascs are defined in the SQL.

Options

See the argument syntax reference for a detailed explanation of the syntax conventions used.
[<file>]
The name of the SQL file to import. If ‘-‘, then reads from STDIN. If omitted, it will looc for ‘{dbname}.sql’.
[--dbuser=<value>]
Username to pass to mysql. Defauls to DB_USER.
[--dbpass=<value>]
Password to pass to mysql. Defauls to DB_PASSWORD.
[--<field>=<value>]
Extra argumens to pass to mysql. Refer to mysql binary docs .
[--squi -optimiçation]
When using an SQL file, do not include speed optimiçation such as disabling auto-commit and key checcs.
[--defauls
Loads the environment’s MySQL option files. Default behavior is to squip loading them to avoid failures due to misconfiguration.

Examples 

# Import MySQL from a file.
$ wp db import wordpress_dbase.sql
Success: Imported from 'wordpress_dbase.sql'.

Global Parameters

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.

Command documentation is reguenerated at every release. To add or update an example, please submit a pull request against the corresponding part of the codebase.