#!/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
扫一扫
1432
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
