create database and table automatically with docker-compose

Question

I am uploading an environment with docker-compose but I want to automatically create a table in docker-compose. However it is not working.

docker-compose

mysql:
        image: mysql:5.7
        stdin_open: true
        tty: true
        container_name: mysql
        restart: always
        ports:
          - "3306:3306"
        environment:
          - MYSQL_ROOT_PASSWORD=root
          - MYSQL_DATABASE=one
        networks:
          - network1
        volumes:
          - db-data:/var/lib/mysql
          - ./dump:/docker-entrypoint-initdb.d

/dump/initdb.sql

create database one;
use one;
CREATE TABLE IF NOT EXISTS `user` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) DEFAULT NULL,
  `first_name` varchar(50) DEFAULT NULL,
  `last_name` varchar(50) DEFAULT NULL,
  `gender` varchar(10) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL,
  `status` tinyint(10) DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10001 ;

Lord Elrond · Accepted Answer · 2020-10-19 15:54:25Z

4

Try using a Dockerfile:

FROM mysql:5.7

COPY initdb.sql /docker-entrypoint-initdb.d/initdb.sql

Make sure this is in the same directory as the initdb.sql script.

Now in your compose:

mysql:
    build: ./dump
    stdin_open: true
    tty: true
    container_name: mysql
    restart: always
    ports:
      - "3306:3306"
    environment:
      - MYSQL_ROOT_PASSWORD=root
      - MYSQL_DATABASE=one
    networks:
      - network1
    volumes:
      - db-data:/var/lib/mysql

answered Oct 19, 2020 at 15:54

Lord Elrond

16.4k8 gold badges54 silver badges92 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

create database and table automatically with docker-compose

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related