Tools for Handling WordPress Database by Docker and WP-CLI.
You must install Docker for this module to work.
$ npm install wpdb --saveOptions:
--version, -v show this version. [boolean]
--help, -h show this help. [boolean]
Install the Docker files.
$ wpdbStart Docker.
$ docker-compose build
$ docker-compose up -dStop Docker.
$ docker-compose down -vRestart Docker (When fixed php.ini etc.).
$ docker-compose restartReset Database.
$ docker-compose exec wordpress wp db reset --allow-rootImport the SQL file.
$ docker-compose exec wordpress wp db import /var/lib/mysql/import.sql --allow-rootExport the SQL file.
$ docker-compose exec wordpress wp db export /var/lib/mysql/export.sql --allow-root$ docker-compose exec wordpress wp db import /var/lib/mysql/import.sql --allow-root
$ docker-compose exec wordpress wp search-replace http://example.com http://localhost --allow-root$ docker-compose exec wordpress wp db export /var/lib/mysql/export.sql --allow-root$ docker-compose exec wordpress wp search-replace http://localhost http://example.com --allow-root
$ docker-compose exec wordpress wp db export /var/lib/mysql/upload.sql --allow-root
$ docker-compose exec wordpress wp search-replace http://example.com http://localhost --allow-root$ docker-compose exec wordpress wp search-replace http://localhost http://example.com --export=/var/lib/mysql/upload.sql --allow-root$ docker-compose exec wordpress wp search-replace 'http:\/\/example.com' 'http:\/\/localhost' --allow-rootPlease change the first line of /docker/wordpress/Dockerfile.
# Default
FROM wordpress:latest
# PHP 7.0
FROM wordpress:php7.0-apache
Please refer to the link below for usable containers.
WordPress Docker Official Images
$ docker-compose logs | grep wordpress$ docker-compose exec wordpress /bin/bash$ docker-compose exec wordpress composer -v$ docker-compose exec wordpress ./vendor/bin/phpcs --standard=PSR2 ./wp-content/themes/my-theme/$ docker-compose exec wordpress ./vendor/bin/php-cs-fixer fix --dry-run --diff --diff-format udiff ./wp-content/themes/my-theme/
$ docker-compose exec wordpress ./vendor/bin/php-cs-fixer fix ./wp-content/themes/my-theme/$ cp ./docker-comopse-ssl.yml ./docker-compose.yml
$ cp ./docker/wordpress/Dockerfile-ssl ./docker/wordpress/Dockerfile$ brew install mkcert
$ brew install nss
$ mkcert -install$ cd ./docker/certs/
$ mkcert localhost 127.0.0.1
$ ls
---
localhost+1-key.pem
localhost+1.pem$ docker-compose build
$ docker-compose up -dAccess SSL URL !!!
wpdb().then(() => {
console.log('Complete!!');
});- WordPress
- WordPress（SSL）
Please Edit Hosts File. Then you will be able to access it with the URL you want.
$ sudo vi /etc/hosts
---
127.0.0.1 example.com- phpMyAdmin
- MailHog
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent