docker-composeを立ち上げると同時にテーブルを作成する方法

Question

実現したいこと

docker-compose.ymlを立ち上げると同時にmysqlにテーブルを作りたいです
具体的にはcompose upのタイミングでinit.sqlが走ってほしいです

発生している問題・エラーメッセージ

エラーはありませんがいかがログになります

Attaching to english_typing-backend-1, english_typing-db-1
english_typing-db-1       | 2023-07-11 02:15:03+09:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.33-1.el8 started.
english_typing-backend-1  | Server listening on port 8080
english_typing-db-1       | 2023-07-11 02:15:04+09:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
english_typing-db-1       | 2023-07-11 02:15:04+09:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.33-1.el8 started.
english_typing-db-1       | '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
english_typing-db-1       | 2023-07-10T17:15:04.862595Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
english_typing-db-1       | 2023-07-10T17:15:04.869328Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
english_typing-db-1       | 2023-07-10T17:15:04.869368Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.33) starting as process 1
english_typing-db-1       | 2023-07-10T17:15:04.870615Z 0 [Warning] [MY-013242] [Server] --character-set-filesystem: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
english_typing-db-1       | 2023-07-10T17:15:04.883293Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
english_typing-db-1       | 2023-07-10T17:15:05.282887Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
english_typing-db-1       | 2023-07-10T17:15:05.524468Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
english_typing-db-1       | 2023-07-10T17:15:05.524503Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
english_typing-db-1       | 2023-07-10T17:15:05.525807Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
english_typing-db-1       | 2023-07-10T17:15:05.553190Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
english_typing-db-1       | 2023-07-10T17:15:05.553302Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.33'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server - GPL.

該当のソースコード

version: "3.8"
services:
  db:
    image: mysql:8.0
    volumes:
      - db_data:/var/lib/mysql
      # マウントと同時にDB作成
      - ./db/init.sql:/docker-entrypoint-initdb.d/init.sql
      - ./db/my.cnf:/etc/mysql/my.cnf
    restart: always
    platform: linux/arm64/v8
    environment:
      MYSQL_ROOT_PASSWORD: ${MYSQL_ROOT_PASSWORD}
      MYSQL_DATABASE: ${MYSQL_DATABASE}
      MYSQL_USER: ${MYSQL_USER}
      MYSQL_PASSWORD: ${MYSQL_PASSWORD}
      TZ: Asia/Tokyo
    command: --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci
    ports:
      - 3306:3306
  backend:
    build:
      context: ./backend/
      dockerfile: Dockerfile
    volumes:
      - ./backend/src/:/backend/src/
    ports:
      - 8080:8080
    depends_on:
      - db
  frontend:
    build: ./frontend
    volumes:
      - ./frontend:/frontend
    ports:
      - 3000:3000
    depends_on:
      - backend

volumes:
  db_data: {}

-- userテーブル
CREATE TABLE IF NOT EXISTS `user` (
    id INTEGER PRIMARY KEY AUTO_INCREMENT,
    username VARCHAR(50) NOT NULL,
    password_hash VARCHAR NOT NULL ,
    created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

-- genresテーブル
CREATE TABLE IF NOT EXISTS genres (
    id INTEGER PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(50) NOT NULL,
    created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

-- typing_contentsテーブル
CREATE TABLE IF NOT EXISTS typing_contents (
    id INTEGER PRIMARY KEY AUTO_INCREMENT,
    genre_id INTEGER NOT NULL,
    title VARCHAR(50) NOT NULL,
    content TEXT NOT NULL,
    created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    FOREIGN KEY (genre_id) REFERENCES genres(id)
);

-- scoresテーブル
CREATE TABLE IF NOT EXISTS scores (
    id INTEGER PRIMARY KEY AUTO_INCREMENT,
    user_id INTEGER NOT NULL,
    score INTEGER NOT NULL,
    created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    FOREIGN KEY (user_id) REFERENCES `user`(id)
);

-- mistakesテーブル
CREATE TABLE IF NOT EXISTS mistakes (
    id INTEGER PRIMARY KEY AUTO_INCREMENT,
    user_id INTEGER NOT NULL,
    mistake INTEGER NOT NULL,
    created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    FOREIGN KEY (user_id) REFERENCES `user`(id)
);

試したこと

• ここにマウントすると自動で走ると聞きました

- ./db/init.sql:/docker-entrypoint-initdb.d/init.sql

Answer 1

参考）
https://zenn.dev/gki/scraps/4231ff2ed5601c

たぶんですが、これじゃないですかね？ バインドマウントしてるようなので、いったん名前付きvolumeを消す必要があるとか。となるとinit.sqlももう少し手を加える必要がありそうで、そういう用途でdocker-entrypoint-initdb.dを使うのは難しいのかもしれませんが。