Not able to read file on volume

Docker Hub
1

I am using a base docker image of Ubuntu 18.04 plus MySQL (have tried with MariaDb as well)

I created a local folder ‘SQL’ in my home directory
Copied my xyz.SQL file into this folder.
I ran 'chmod 777 sql ’ command on this folder to give full permissions to all

I created a volume in docker-compose using ‘Volume’ command
then I ran command ‘docker-compose up’

I see the database created using ‘docker exec -it my_container bin/bash’
but not tables in database even after creating volumes

I ran below commands to create volume seperately
''docker volume create [OPTIONS] [VOLUME]
docker run --volume,type=bind,source=/path_in,dest=/container_path"

but it was creating folders only

Database is created when base image of mysql is build
Under mysql image there is pre-defined variable which is ‘MYSQL-DATABASE’ : my_db_name

Screenshot%20from%202019-10-22%2010-53-48
Screenshot from 2019-10-22 10-53-48.png1920×1080 384 KB

I expect this .SQL file to be sourced and create schema and some initial data. Instructions for the same are in my dockerfile.(attached below)

I am unable to source my ‘.SQL’ file. Although I believe the database is accessible as such.

What am I doing wrong?

2

I would be easier to answer your question if you show us your compose file (and please format it as preformatted text so the indentation is visible).

3

version: ‘3.3’
services:
server:
build:
context: server
dockerfile: Dockerfile
environment:
- NODE_ENV=development
ports:
- 4000:4000
links:
- db
restart: always
depends_on:
- db #it needs to be start first

web:
build:
context: client
dockerfile: Dockerfile
environment:
- NODE_ENV=production
restart: always
depends_on:
- db #it needs to be start second
command: npm start
ports:
- 3000:3000
links:
- db
volumes:
- .:/app

db:
image: mysql:5.7
build:
context: mysql
dockerfile: Dockerfile

ports:
    - 3306
restart: always
expose:
    - 3306 
environment:
    MYSQL_USER: root
    MYSQL_ROOT_PASSWORD: root  
    MYSQL_PASSWORD: root
    MYSQL_DATABASE: owaIPFS
#command: source owaIPFS.sql
volumes:
     - db-data:/var/lib/mysql

volumes:
db-data: {}