docker-compose mysql init sql 不执行

2021-12-26 00:00:00 docker sql database docker-compose mysql

我正在尝试设置一个 mysql docker 容器并执行 init sql 脚本.不幸的是,sql 脚本没有执行.我做错了什么?

I am trying to set up a mysql docker container and execute init sql script. Unfortunately the sql script is not executed. What am I doing wrong?

version: '3.3'
services:
  api:
    container_name: 'api'
    build: './api'
  ports:
    - target: 8080
      published: 8888
      protocol: tcp
      mode: host
  volumes:
    - './api:/go/src/app'
  depends_on:
    - 'mysql'
 mysql:
  image: 'mysql:latest'
  container_name: 'mysql'
  volumes:
    - ./db_data:/var/lib/mysql:rw
    - ./database/init.sql:/docker-entrypoint-initdb.d/init.sql:ro
  restart: always
  environment:
    MYSQL_USER: test
    MYSQL_PASSWORD: test
    MYSQL_ROOT_PASSWORD: test
    MYSQL_DATABASE: test
  ports:
    - '3306:3306'
volumes:
  db_data:

我用 docker-compose up -d --build

推荐答案

许多容器化应用程序,尤其是有状态的应用程序,都有一种运行 init 脚本(如这里的 sql 脚本)和他们应该只运行一次.

Many containerized applications, especially stateful ones, have a way of running init scripts (like the sql scripts here) and they are supposed to run only once.

由于它们是有状态的,卷是容器在容器重启时是否运行 init 脚本的真实来源.

And since they are stateful, the volumes are a source of truth for the containers on whether to run the init scripts or not on container restart.

就像您的情况一样,删除用于绑定安装的文件夹或使用新命名的卷应该重新运行任何存在的 init 脚本.

Like in your case, deleting the folder used for bind mount or using a new named volume should re-run any init scripts present.

相关文章