Destroy, re-initialize and seed a mysql database in docker container

gistfile1.txt

#!/bin/sh

# check if there is a running db instance
running_db_instance=`docker ps | grep weaveposbackend_db | wc -l`

if [ $running_db_instance -gt "0" ]
then
    instance_name=`docker ps | grep weaveposbackend_db | awk '{print $12}'`

    echo "Stopping db instance $instance_name"
    docker stop $instance_name
fi

# delete old db files
echo "Removing old data files"
rm -rf volumes/mysql

# create new data folder
echo "Creating new data directory"
mkdir -p volumes/mysql

# start docker db instance
echo "Starting docker db"
docker-compose up -d db

# wait for db instance to boot
sleep 10

# create table structure & insert seed data
echo "Creating table structure and seeding database"
docker-compose run web /usr/src/app/resetdb.sh