1、目录结构
-rw-r--r-- 1 root root 350 Jan 23 09:51 Dockerfile
-rw-r--r-- 1 root root 365 Jan 23 09:38 initdb.sh
drwxr-xr-x 2 root root 4096 Jan 23 09:47 sql
2、initdb.sh
#!/bin/bash
mysql -uroot -p$MYSQL_ROOT_PASSWORD <<EOF
source /usr/local/sql/a.sql
source /usr/local/sql/b.sql
source /usr/local/sql/c.sql
source /usr/local/sql/d.sql
source /usr/local/sql/e.sql
source /usr/local/sql/f.sql
source /usr/local/sql/h.sql
source /usr/local/sql/i.sql
source /usr/local/sql/f.sql
3、Dockerfile
#基础镜像
FROM 172.16.74.168/common/mysql:5.6
#作者
MAINTAINER hzb@qq.com
#COPY sql到镜像
COPY ./sql /usr/local/sql
#将初始化脚本放入/docker-entrypoint-initdb.d/目录下,容器会自动执行这个shell
COPY ./initdb.sh /docker-entrypoint-initdb.d/
#给initdb.sh执行权限
RUN chmod a+x /docker-entrypoint-initdb.d/initdb.sh