Skip to content

Instantly share code, notes, and snippets.

@krichardsson
Last active September 25, 2015 01:30
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save krichardsson/41e125a267624d589613 to your computer and use it in GitHub Desktop.
Save krichardsson/41e125a267624d589613 to your computer and use it in GitHub Desktop.
Populate mysql docker container from sql file
# Create a mysql container
docker run --name myDb -e MYSQL_DATABASE=db-name -e MYSQL_ROOT_PASSWORD=topsecret -p 3306:3306 -d mysql
# Populate it
docker run --rm -it --link myDb:mysql -v ${PWD}:/dump mysql sh -c 'exec mysql -h"$MYSQL_PORT_3306_TCP_ADDR" -P"$MYSQL_PORT_3306_TCP_PORT" -uroot -p"$MYSQL_ENV_MYSQL_ROOT_PASSWORD" --database="$MYSQL_ENV_MYSQL_DATABASE" < /dump/my-dump.sql'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment