为什么我的docker.compose文件没有创建我的数据库？

Question

我有一个码头工人。编写文件，当我启动它时，我希望它创建一个包含一些表的数据库。

我的码头工人组成：

services:
  mysql:
    image: mysql:latest
    container_name: mysqldb
    cap_add:
      - SYS_NICE # CAP_SYS_NICE
    # container_name: my_very_special_server
    ports:
      - 3307:3306
    environment:
      MYSQL_DATABASE: todo
      MYSQL_ROOT_PASSWORD: password!
      MYSQL_PASSWORD: password!
    volumes:
      - ./DbScripts/DumpTodoOnly.sql:/docker-entrypoint-initdb.d/DumpTodoOnly.sql
      - db_data:/var/lib/mysql
    restart: always
  phpmyadmin:
    image: phpmyadmin/phpmyadmin
    container_name: dev_pma
    links:
      - mysql
    environment:
      PMA_HOST: mysql
      PMA_PORT: 3307
      PMA_ARBITRARY: 1
    restart: always
    ports:
      - 8183:80
  server:
    container_name: server
    build: 
      context: ./BE
      dockerfile: ./Dockerfile.prod
    depends_on:
      - mysql
    environment:
      MYSQL_HOST_IP: mysql
    ports:
      - 4000:4000
    links:
      - mysql
  client:
    container_name: FE
    build: 
      context: ./FE
      dockerfile: ./Dockerfile.prod
    ports:
      - 3000:3000
    environment:
      - CHOKIDAR_USEPOLLING=true
    tty: true
volumes:
  db_data:

项目结构：

实际的 SQL 文件：

-- 主机：本地主机 数据库：待办事项

--服务器版本8.0.18

/*！40101 SET@OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /; /! 40101 SET@OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /; /! 40101 SET@OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /; /! 50503 SET NAMES utf8 /; /! 40103 SET@OLD_TIME_ZONE=@@TIME_ZONE /; /! 40103 SETTIME_ZONE='00:00' /; /! 4SET@OLD_UNIQUE_CHECKS=@UNIQUE_CHECKS，UNIQUE_CHECKS=0 /; /! 40014 SET@OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS，FOREIGN_KEY_CHECKS=0 /; /! 40101 SET@OLD_SQL_MODE=@SQL_MODE，SQL_MODE='NO_AUTO_VALUE_ON_ZERO' /; /! 40111 SET@OLD_SQL_NOTES=@SQL_NOTES，SQL_NOTES=0*/；

DROP TABLE IF EXISTS `todos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `todos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `todotext` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
  `Id` varchar(36) NOT NULL,
  `Email` varchar(200) NOT NULL,
  `Password` binary(60) NOT NULL,
  `ChangedPassword` bit(1) NOT NULL,
  `FirstName` varchar(45) NOT NULL,
  `LastName` varchar(45) NOT NULL,
  `ImageId` varchar(36) DEFAULT NULL,
  `SeqRef` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  UNIQUE KEY `Email_UNIQUE` (`Email`),
  UNIQUE KEY `Id_UNIQUE` (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci KEY_BLOCK_SIZE=2;
/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME _ ZONE = @ OLD _ TIME _ ZONE */；

/*!40101 SET SQL _ MODE = @ OLD _ SQL _ MODE/；/!40014 SET FOREIGN _ KEY _ CHECKS = @ OLD _ FOREIGN _ KEY _ CHECKS/；/!40014 SET UNIQUE _ CHECKS = @ OLD _ UNIQUE _ CHECKS/；/!40101 SET CHARACTER _ SET _ CLIENT = @ OLD _ CHARACTER _ SET _ CLIENT/；/!40101 SET CHARACTER _ SET _ RESULTS = @ OLD _ CHARACTER _ SET _ RESULTS/；/!40101 SET COLLATION _ CONNECTION = @ OLD _ COLLATION _ CONNECTION/；/!40111 SET SQL _ NOTES = @ OLD _ SQL _ NOTES */；

--倾倒于2022-03-16 20:20:30完成

当我运行 docker-compose 时，我看到：

在我的php admin中，我没有看到任何用户或待办事项表：

我错过了什么？

Answer 1

好吧，当你发帖时，找到答案有点不太好，但对于那些有类似问题的人来说：

当您运行docker-composup命令时，数据库配置会被存储并监督重新启动。要做到这一点，我必须：

docker-compose down -v

答案在这里找到

注意@Sebastiaan伦肯斯的答案