Skip to content

Instantly share code, notes, and snippets.

View InvisibleKind's full-sized avatar

Viktor Livakivskyi InvisibleKind

  • Leonberg, Germany
View GitHub Profile
@InvisibleKind
InvisibleKind / drop.sql
Last active April 1, 2016 16:54
Drop all db tables
SET SESSION group_concat_max_len = 1000000;
SELECT GROUP_CONCAT(r1.query SEPARATOR "\n") AS copy_and_paste FROM (SELECT concat("DROP TABLE IF EXISTS ", table_name, ";") AS query FROM information_schema.tables WHERE table_schema = "my-db-name") AS r1;
@InvisibleKind
InvisibleKind / ec2-startup.sh
Created March 20, 2017 16:01 — forked from ReedD/ec2-startup.sh
User data for EC2 to set up Docker and Compose (Fig) for ec2-user
#!/bin/sh
export PATH=/usr/local/bin:$PATH;
yum update
yum install docker -y
service docker start
# Docker login notes:
# - For no email, just put one blank space.
# - Also the private repo protocol and version are needed for docker
# to properly setup the .dockercfg file to work with compose