Docker Virtual Machine + MySQL

gistfile1.markdown

Docker + MySQL

Install Docker

• https://docs.docker.com/engine/installation/windows/

Docker Initialization (Windows)

• Run Docker Quickstart Terminal to initialize Docker
• All Docker commands must be run from this shell

Start a mysql instance

docker run -p 3306:3306 --name mysql-docker -e MYSQL_ALLOW_EMPTY_PASSWORD=yes -e MYSQL_DATABASE=lportal -d mysql:5.5 --character-set-server=utf8

Note: You can install other versions too:

mysql:5.5  
mysql:5.6  
mysql:5.7  

Get IP

docker-machine ip default

Portal-ext

jdbc.default.url=jdbc:mysql://{docker ip address}/lportal?characterEncoding=UTF-8&dontTrackOpenResources=true&holdResultsOpenOverStatementClose=true&useFastDateParsing=false&useUnicode=true
jdbc.default.username=root

Dump database

docker exec -i mysql-docker /bin/bash -c "mysqldump lportal > lportal.sql"
docker cp mysql-docker:/lportal.sql {your local folder}/

Stop and Remove

docker stop mysql-docker
docker rm mysql-docker

Import

• Start new instance (see above)

• Importing the database:

docker cp {your local folder}/lportal.sql mysql-docker:/lportal.sql docker exec -i mysql-docker /bin/bash -c "mysql lportal -uroot < lportal.sql" docker exec -i mysql-docker /bin/bash -c "mysql_upgrade --force" ```