dockerのmysqlからmysqldumpとデータリストアが出来るシェル

mysqldump_and_restore_for_docker.sh

#!/bin/sh

#
# database dump & restore for docker mysql
#

ACTION=$1

help() {
  cat << EOS
usage: $0 dump
       $0 restore
EOS
  exit 1
}

check() {
  if [ -z "$(docker ps -f name=dbcontainer -q)" ]; then
    echo "[skip] dbcontainer is not running"
    exit 0
  fi
}

restore() {
  echo "data restore start"

  for file in data/*.sql
  do
      echo "$file"
      docker exec -i dbcontainer sh -c "MYSQL_PWD=password mysql -u testuser testdb" < "$file"
  done

  if [ $? != 0 ]; then
      echo "data restore failed"
      exit 1
  fi
  echo "data restore end"
}

dump() {
  echo "mysqldump start"
  docker exec -i dbcontainer sh -c "(echo 'show tables' | MYSQL_PWD=password mysql -u testuser testdb | sed -e '1d' > /bkup/all_tables.txt;)"
  docker exec -i dbcontainer sh -c "(while read line; do echo \$line; MYSQL_PWD=password mysqldump -u testuser testdb \$line --opt | sed '/^-- Dump completed on/d' > /bkup/\$line.sql; done < /bkup/all_tables.txt;)"

  if [ $? != 0 ]; then
      echo "mysqldump failed"
      exit 1
  fi
  echo "mysqldump end"
}

case "$ACTION" in
  dump) check && dump;;
  restore) check && restore;;
  *) help;;
esac

exit 0

コンテナ名 = dbcontainer

ローカルの./dataディレクトリとコンテナ内の/bkupディレクトリはvolumesでマウント済みであること。