MySQL Bulk build library Guide data script

Database Name list into a file

# Cat 00db.txtinformation_schemadb_app_cmsdb_eopdb_leader_cmsdb_leader_comment

Mysqldump out of the SQL data into a file inside

# cat 00dbsql.txt-rw-r--r--1 root root 970701283 may 03:39 information_schema-2017-05-16-033001.sql-rw-r--r--1 roo T root 32156 May 03:39 db_app_cms-2017-05-16-033001.sql-rw-r--r--1 root root 169522095206 * * 05:50 db_eop-2 017-05-16-033001.sql-rw-r--r--1 root root 99699 may 05:50 db_leader_cms-2017-05-16-033001.sql-rw-r--r--1 root Root 256290013 May 05:51 Db_leader_comment-2017-05-16-033001.sql

Bulk build library and import data scripts

# cat 00createdb.sh#!/bin/bashfor i in  ' Cat 00db.txt '          do                 for j in  ' cat /data/backup/00dbsql.txt | awk -f  '   '   ' {print $9} '   '                  do                    if [[  $j  == * "$i" * ]];                  then    mysql - uroot -proot -s  /data/mysql_data/sock/my3306.sock  -e  "create  database  $i; "                          mysql -uroot -proot -s /data/mysql_data/sock/my3306.sock  $i   <  $j                         echo  $i           fi                 Done                done

Execute script

#nohup 00createdb.sh &

MySQL Bulk build library Guide data script