Docker und phpMyAdmin
dockermysqlmariadbphpmyadmin
MySQL/MariaDB Dump mit Docker und phpMyAdmin betrachten
docker-compose.yml
version: "3.7"
services:
mysql-server:
image: mysql:8.0.19
container_name: trashable_mysql
environment:
MYSQL_ROOT_PASSWORD: secret
volumes:
- mysql-data:/var/lib/mysql
ports:
- "3306:3306"
phpmyadmin:
image: phpmyadmin/phpmyadmin:5.0.1
container_name: phpmyadmin
environment:
PMA_HOST: mysql-server
PMA_USER: root
PMA_PASSWORD: secret
UPLOAD_LIMIT: 300M
ports:
- "8080:80"
volumes:
mysql-data:
Load Dump
docker-compose up
docker exec -i trashable_mysql mysql -uroot -psecret -e "CREATE DATABASE IF NOT EXISTS __DB_NAME__"
docker exec -i trashable_mysql mysql -uroot -psecret __DB_NAME__ < your_local_db_dump.sql
open http://127.0.0.1:8080/
Remove Persistent Data
docker-compose down --volumes
Resourcen & Referenzen
Meta-level
- Article language
- German
- Article date
- July 2, 2020
- Updated at
- July 11, 2021
