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