Adding a service to the docker-compose.yml:
db:
image: mysql:5.7
restart: always
environment:
MYSQL_DATABASE: test
MYSQL_USER: test
MYSQL_PASSWORD: test
MYSQL_RANDOM_ROOT_PASSWORD: '1'
volumes:
- db:/var/lib/mysql
Popular mysql versions:
mysql:5.7
mysql:8.0.39
mysql:9.0.1
How to import a dump
Add a volume to the container:
volumes:
- ./path/to/dump.sql:/dump.sql
Now open a terminal session for this container and type:
mysql -uwordpress -pwordpress -pwordpress wordpress < /dump.sql
Andrew Dorokhov