docker.readme.txt

//clean all
docker rm $(docker ps -a -q)
docker rmi $(docker images -q)
sudo service docker stop
sudo rm -rf /var/lib/docker/*
sudo service docker start

//

sudo docker exec -i -t [NAME/ID] /bin/bash

docker attach --sig-proxy=false  [NAME/ID]

// postgres on docker
> docker rm some-postgres && docker run --name some-postgres -p 5432:5432  -e POSTGRES_PASSWORD=mysecretpassword  postgres
> psql -h localhost -p 5432 -U postgres -W postgres

// mysql on docker
> docker stop some-mysql && docker rm some-mysql && docker run -p 3306:3306 --name some-mysql -e MYSQL_ROOT_PASSWORD=my-secret-pw -e MYSQL_DATABASE=db -e MYSQL_PASSWORD=pwd -e MYSQL_USER=dbuser -d mysql:latest
//local client
> mysql -u dbuser -h 127.0.0.1 -p db
//docket client
> docker run -v `pwd`:/home -it --link some-mysql:mysql --rm mysql sh -c 'exec mysql -h"$MYSQL_PORT_3306_TCP_ADDR" -P"$MYSQL_PORT_3306_TCP_PORT" -u"$MYSQL_ENV_MYSQL_USER" --password="$MYSQL_ENV_MYSQL_PASSWORD" "$MYSQL_ENV_MYSQL_DATABASE" < /home/SCRIPT.sql'

// memcached on docker
> docker stop some-memcached && docker rm some-memcached && docker run -p 11211:11211 --name some-memcache -d memcached:latest




//mysql. START. WAIT. INIT.
docker stop some-mysql; docker rm some-mysql; docker run -p 3306:3306 --name some-mysql -e MYSQL_ROOT_PASSWORD=my-secret-pw -e MYSQL_DATABASE=developer -e MYSQL_PASSWORD=developer -e MYSQL_USER=developer -d mysql:latest
#wait
echo "SHOW DATABASES;" > ping.sql
printf "wait mysql start ."
status=1
while [[ status -ne 0 ]]; do
  sleep 1
  docker run -v `pwd`:/home -it --link some-mysql:mysql --rm mysql:latest sh -c 'exec mysql -h"$MYSQL_PORT_3306_TCP_ADDR" -P"$MYSQL_PORT_3306_TCP_PORT" -u"$MYSQL_ENV_MYSQL_USER" --password="$MYSQL_ENV_MYSQL_PASSWORD" "$MYSQL_ENV_MYSQL_DATABASE" < /home/ping.sql > /dev/null 2>&1'
  status=$?
  printf "."
done
printf " started\n"
#init
docker run -v `pwd`:/home -it --link some-mysql:mysql --rm mysql:latest sh -c 'exec mysql -h"$MYSQL_PORT_3306_TCP_ADDR" -P"$MYSQL_PORT_3306_TCP_PORT" -u"$MYSQL_ENV_MYSQL_USER" --password="$MYSQL_ENV_MYSQL_PASSWORD" "$MYSQL_ENV_MYSQL_DATABASE" < /home/tables_init.sql'


//node
docker run -it --rm --name my-running-script-prepare -v "$PWD":/usr/src/app -w /usr/src/app node:5-wheezy npm install