Docker mysql export bash script tool

docker-db-export.sh

#!/usr/bin/env bash

# Backup usage
#
# ./docker-db-export.sh backup my-project-folder-name_db_1
#
# output to : ./my-project-folder-name_db_1.sql

# Restore usage
#
# ./docker-db-export.sh restore my-project-folder-name_db_1 my-project-folder-name_db_1.sql

TYPE="$1";
CONTAINER_NAME="$2";
MYSQL_FILENAME="$3";
DB_NAME="wordpress";

if [[ $TYPE == 'backup' ]]; then
  echo "Backuping $CONTAINER_NAME";
  docker exec $CONTAINER_NAME /usr/bin/mysqldump -u root --password=root $DB_NAME > $CONTAINER_NAME.sql;
elif [[ $TYPE == 'restore' ]]; then
  echo "Restoring $CONTAINER_NAME";
  cat $MYSQL_FILENAME | docker exec -i $CONTAINER_NAME /usr/bin/mysql -u root --password=root $DB_NAME;
fi