X
X
Xe1ga2021-01-15 21:39:06
MySQL
Xe1ga, 2021-01-15 21:39:06

Why is a part of mysql tables lost when restoring from a dump in a docker container?

When restoring a database from a dump, some of the tables were lost. What could be wrong?
The content of the docker-compose orchestration file looks like this:

version: "3.9"
services:
  db_mysql:
    image: mysql:8.0.22
    container_name: db_mysql
    command: --default-authentication-plugin=mysql_native_password
    volumes:
     - ./data:/var/lib/mysql
     - ./tz2.sql:/docker-entrypoint-initdb.d/tz2.sql
    restart: always
    ports:
     - "3306:3306"
    environment:
     - MYSQL_ROOT_PASSWORD=${MYSQL_ROOT_PASSWORD}
     - MYSQL_DATABASE=${DB_NAME}
     - MYSQL_USER=${DB_USER}
     - MYSQL_PASSWORD=${DB_PASSWORD}

  phpmyadmin:
    image: phpmyadmin/phpmyadmin
    container_name: phpmyadmin
    environment:
     - PMA_ARBITRARY=1
    restart: always
    depends_on:
     - db_mysql
    ports:
     - "8080:80"
    volumes:
     - /sessions
     - ~/docker/phpmyadmin/config.user.inc.php:/etc/phpmyadmin/config.user.inc.php
     - /custom/phpmyadmin/theme/:/www/themes/theme/

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question