How to use multiple databases in one docker container?

General Discussions
#1

I’m using docker-compose file with existing pavel-local image.

version: '3.1'

services:
  mysql:
    image: pavel/pavel-local
    ports:
      - "3306:3306"
    restart: always
    volumes:
      - ./database/users-service:/docker-entrypoint-initdb.d

And I’m trying to create second database using sql file and docker-entrypoint-initdb.d.

./database/users-service/create-db.sql

CREATE DATABASE local;

I am adding sql file with script for creating a new db to docker-entrypoint-initdb.d(container) using volumes. But it deleted sql file from docker-entrypoint-initdb.d(container) which already exist and added a new one. The old file contains information about first database. I read that volumes in docker compose delete and push new files to volume directory. How can I save old info about my first db and add a new one. Maybe without volume and docker-entrypoint-initdb.d?