Wordpress with docker and pagespeed

Start in 5 minutes.

1. Copy the env_example and paste with the name .env
2. Execute the command

$ docker-compose up -d

Dump database

Normal Dump

$ docker-compose exec mysql sh -c 'export MYSQL_PWD="$MYSQL_PASSWORD";exec mysqldump -u wordpress site' > ./database.sql

GZ dump

If you are running windows you need mount the volume /docker-entrypoint-initdb.d and pass the gzip command into the exec and save the file on the mounted volume.

$ docker-compose exec mysql sh -c 'export MYSQL_PWD="$MYSQL_PASSWORD";exec mysqldump -u wordpress site' | gzip -9 -c > database.sql.gz

Change the url

$ sed -i 's/http:\/\/dev.com/http:\/\/mynewsite.com/g' ./database.sql

Debugging.

You only need define your ip address in the os enviroment variable IP_ADDRESS on linux for example you can execute the command

$ IP_ADDRESS=$(hostname -I | cut -d' ' -f1) docker-compose up -d

Other command to get the ip could be $(ip addr show wlp2s0 | grep -Po 'inet \K[\d.]+')

Also if you are using Visual Code in the debugger process you can add the follow config to support the debbugger:

"pathMappings": {
    "/var/www/html/wp-content":"${workspaceFolder}/wp-content"
}