Skip to content

Latest commit

 

History

History
47 lines (39 loc) · 942 Bytes

README.md

File metadata and controls

47 lines (39 loc) · 942 Bytes
Raw

Clean mysql dump and docker image for it

Aim: Build a mysql container with all data that we need

Documenting what I did:

Generate the dump

Take a database dump and clean it to remove all personal data:

  1. import the database dump:
mysql -u USER -p 4training < mysql-dump.sql`
  1. Run cleanup.sql:
mysql -u USER -p 4training < cleanup.sql`
  1. Export the new dump:
mysqldump -u USER -p 4training > dump.sql`

Build

docker build -t 4training/mysql .

Test the docker image

Run the image locally:

docker run -d -p 1234:3306 4training/mysql

Connect to it (important: you need to have -h 127.0.0.1, otherwise mysql may connect to your local mysql server if you have one running)

mysql -h 127.0.0.1 -P 1234 -u root -p

Push to docker hub

Login (finding out the currently logged in user: docker info):

docker login

Push to docker hub:

docker push 4training/mysql