So I found a past post that looked like my question too but its for Oracle. Below is the link to the past post.
Requirement is to have a docker image that a dev can pull and when spun up, it should have certain PDBs ready and users created. I found a way to do this by mounting a custom_script that runs at startup. Like so…
docker run --name DM -p 1523:1521 -e ORACLE_SID=DM -e ORACLE_PDB=DM1 -e ORACLE_PWD=Xyz1234 -e ORACLE_MEM=4000 -v /home/oracle/scripts:/opt/oracle/scripts/startup --shm-size=1g -d oracle/database:19.3.0-ee
But I’ll have to supply the custom_script to the dev and instruct on where to save it…
What I’m looking to do it to incorporate that into the image itself so I don’t have to supply the file separately. By modifying my dockerfile so it picks up the script and incorporates it into the image built. I don’t want to use the add changes and commit (create new image) route. Below is for mysql and I’m looking for an Oracle equivalent
FROM mysql
ADD sqldump.sql /docker-entrypoint-initdb.d/
ENV MYSQL_ROOT_PASSWORD yourpassword
thank you