#!/bin/bash
filename=mvDorisTable.txt
while IFS=‘;’ read -r database table;
do
echo $database
echo t a b l e k e y = table key= tablekey=(mysqldump -uroot -h XXX.31 -P 8130 -pDoris12345 --no-tablespaces --databases $database --tables t a b l e − − n o − d a t a ∣ g r e p − v ′ / ∗ ! ′ ∣ g r e p ′ D U P L I C A T E K E Y ′ ∣ s e d ′ s / D U P L I C A T E K E Y / / ′ ∣ s e d ′ s / ( / / ′ ∣ s e d ′ s / ) / / ′ ) c r e a t e t a b l e = table --no-data | grep -v '/*!' | grep 'DUPLICATE KEY' | sed 's/DUPLICATE KEY//' | sed 's/(//' | sed 's/)//') create_table= table−−no−data∣grep−v′/∗!′∣grep′DUPLICATEKEY′∣sed′s/DUPLICATEKEY//′∣sed′s/(//′∣sed′s/)//′)createtable=(mysqldump -uroot -h XXX.31 -P 8130 -pDoris12345 --no-tablespaces --databases $database --tables KaTeX parse error: Undefined control sequence: \- at position 28: …ata | grep -v "\̲-̲\-" | grep -v "…key text/$key varchar(255)/"| sed ‘s/ text/ string/’)
mysql -uadmin -h XXX.64 -P 9030 -pDoris12345 -e “use $database; $create_table”
done < $filename
