WP-CLI is a great command line tool to help you manage WordPress.
I had trouble figuring out how to use WP-CLI to access a MySQL database that was running in a Docker container. I’m running a Docker LAMP instance locally using this set of Docker and Docker-Compose files from sprintcube.
The MySQL instance holding my local WordPress database is running in a Docker container. However, my WordPress core files are located located in a directory on the host’s physical hard drive defined as a Docker volume.
The trick is defining your DB_HOST environment value to be the IP address of your MySQL Docker container. You can do this either explicitly by the command line or in your WP configuration files (for a typical install in your wp-config.php file, in a bedrock install in your .env files).
Getting the IP Address of the MySQL Docker Container
You can find the IP address of your docker container by executing the following command:
1 2 3 4 5 |
docker inspect -f '{{range.NetworkSettings.Networks}}{{.IPAddress}}{{end}}' CONTAINER-NAME |
Get your container name:
1 2 3 4 5 |
docker container ls |
From this, I see that the Mysql container name is “lamp-database”.
d
Define DB_HOST Environmental Variable
Execute the following command substituting CONTAINER-NAME with your database container:
1 2 3 4 5 |
export DB_HOST=$(docker inspect -f '{{range.NetworkSettings.Networks}}{{.IPAddress}}{{end}}' CONTAINER-NAME |
Define the Path to Your WordPress Install in Your WP-CLI Configuration Files
Create wp-cli.yml file in the directory you will be using WP or, alternatively create ~/.wp-cli/config.yml
The local alias should point to the WordPress file on your Docker volume as shown in this example:
1 2 3 4 5 6 7 8 9 |
@prod: ssh: username@myproductionserver.com:22/home/username/bedrock/www @local: path: /home/local-username/website/bedrock/web/wp [<-- note this is path to WordPress core files ] |
To backup your WordPress database just type:
1 2 3 4 5 |
wp @local db export |
Note that this method is intended to be used for a LAMP Docker install with the WordPress files being simply installed in the document root kept in a defined volume on the host’s physical drive and WP-CLI installed on the physical docker host.
If you are using a WordPress container to run WordPress and/or WP-CLI, then you most likely want to use the ssh tag in wp-cli.yml. See the WP-CLI documentation regarding the ssh tag and brief discussion of the Docker scheme.