mysql-example-setup

# Rough steps to set up a mysql instance in docker and load the github enterprise database into
# it for inspection. If you need to actually restore the complete github instance, you shouldn't
# use these steps. Instead, use the official tool: https://github.com/github/backup-utils

source ./mysql_creds.sh

docker pull mysql:5.6
# https://stackoverflow.com/a/45197727
docker network create -d bridge --subnet 172.25.0.0/16 mysql_network
docker run --name gh-enterprise-server --network=mysql_network --ip=172.25.3.3 \
           -e MYSQL_ROOT_PASSWORD="${MYSQL_ROOT_PASSWORD}" -d mysql:5.6
mkdir /docker/mnt
gunzip ./github-enterprise/data/current/mysql.sql.gz
cp ./github-enterprise/data/current/mysql.sql /docker/mnt/
cp ./db_setup.sql /docker/mnt
docker run -v /docker/mount:/mnt -w /mnt -it --network=mysql_network --rm mysql:5.6 \
    bash -c "cat db_setup.sql mysql.sql | mysql -h '172.25.3.3' -u root --password=${MYSQL_ROOT_PASSWORD}"