mysql导入创建

#!/bin/bash
cd /home/xxxx/database
MYSQL_USER="root"
MYSQL_PASSWORD="xxxxxx"
arrays=(
  #cloud_aliyun
  cloud_certificate
  cloud_clazz
  cloud_course
  cloud_exam
  cloud_live
  cloud_log
  cloud_new_message
  cloud_plan
  cloud_point
  cloud_portal
  cloud_research
  cloud_rule
  cloud_statistics
  cloud_study
  cloud_system
  cloud_trainning_project
  xxl_job_nacos
  xxl_job
  )

for MYSQL_DATABASE in "${arrays[@]}"
do

  mysql  -u $MYSQL_USER -p$MYSQL_PASSWORD -e "CREATE DATABASE IF NOT EXISTS $MYSQL_DATABASE CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;"
  echo "Database $MYSQL_DATABASE created successfully."

  echo "$MYSQL_DATABASE import sql file start ..."
  mysql -u $MYSQL_USER -p$MYSQL_PASSWORD $MYSQL_DATABASE < $MYSQL_DATABASE.sql

  echo "$MYSQL_DATABASE import sql file end ..."
done

无敌私服命令

#!/bin/bash

#  commons pom jar
# cd /d/gitlab/repo/
cd /d/jdk-maven/maven/apache-maven-3.8.8/repo1/
REPO_URL=http://10.195.238.102:8081/repository/maven-central-learning


# fulan pom jar
# cd /d/gitlab/repo1/
# REPO_URL=http://10.195.238.102:8081/repository/allianz-learning-host

USERNAME=admin
PASSWORD=admin123
find . -type f -not -path './mavenimport\.sh*' -not -path '*/\.*' -not -path '*/\^archetype\-catalog\.xml*' -not -path '*/\^maven\-metadata\-local*\.xml' -not -path '*/\^maven\-metadata\-deployment*\.xml' | sed "s|^\./||" | xargs -I '{}' curl -u "$USERNAME:$PASSWORD" -X PUT -v -T {} ${REPO_URL}/{} ;