Docker compose for wordpress

docker-compose.yml

version: '3.1'

services:

  mywebdb:
    image: mysql:5.7
    volumes:
      - mywebdb_data:/var/lib/mysql
    environment:
      MYSQL_ROOT_PASSWORD: supersecretpassword
      
  myweb:
    depends_on:
      - mywebdb
    image: wordpress:4.8.0-php7.0-apache
    volumes:
      - myweb_data:/var/www/html
    ports:
      - 80:80
    environment:
      WORDPRESS_DB_PASSWORD: supersecretpassword
      WORDPRESS_DB_HOST: mywebdb

volumes:
  myweb_data:
  mywebdb_data:

To backup mysql database

docker exec ${mywebdb container} mysqldump -uroot -psupersecretpassword wordpress > backup.sql

To execute queries in MySQL

docker exec -it ${mywebdb container}  mysql -uroot -psupersecretpassword

To backup wordpress web files

docker cp ${myweb container}:/var/www/html .