pt-archive
#archiver命令的安装路径
BASE_PATH=/usr/local/bin
定义 pt-archiver 参数变量
SOURCE_HOST=“”
SOURCE_PORT=“”
SOURCE_USER=“”
SOURCE_PASSWORD=“”
SOURCE_DATABASE=“”
SOURCE_CHARSET=“utf8”
SOURCE_PATH=“”
SOURCE_LOG_PATH=“”
#接受外部参数
START_DATE=$1
END_DATE=$2
获取当前系统时间
CURRENT_TIME= ( d a t e + " C U R R E N T D A T E = (date +"%Y-%m-%d %H:%M:%S") CURRENT_DATE= (date+"CURRENTDATE=(date +“%Y-%m-%d”)
定义日志文件路径 "数据库名+日期"作为日志文件名
LOG_FILE= S O U R C E L O G P A T H " a r c h i v e r − SOURCE_LOG_PATH"archiver- SOURCELOGPATH"archiver−SOURCE_DATABASE-$(date +“%Y-%m-%d_%H-%M-%S”).log"
每处理 $PROGRESS 行数据时输出进度报告
PROGRESS=10000
每个事务中处理的最大行数，用于控制事务的大小
TXN_SIZE=1000
每个查询中返回的记录数的限制
LIMIT=1000
归档间隔时间
INTERVAL_DAY=365
if [ ! -d
S
O
U
R
C
E
P
A
T
H
SOURCE_PATH
SOURCEPATHCURRENT_DATE ];then
mkdir
S
O
U
R
C
E
P
A
T
H
SOURCE_PATH
SOURCEPATHCURRENT_DATE
else
echo “文件夹已经存在”
fi
echo “开始归档” >>
L
O
G
F
I
L
E
e
c
h
o
"
LOG_FILE echo "
LOGFILEecho"LOG_FILE" >> $LOG_FILE
echo “###############################################################” >> $LOG_FILE
开始备份 master表
echo “by_operation_master 开始备份: $START_DATE - $END_DATE " >>
L
O
G
F
I
L
E
C
O
M
M
O
N
M
A
S
T
E
R
=
"
LOG_FILE COMMON_MASTER="
LOGFILECOMMONMASTER="BASE_PATH/pt-archiver --source h=
S
O
U
R
C
E
H
O
S
T
,
P
=
SOURCE_HOST,P=
SOURCEHOST,P=SOURCE_PORT,u=
S
O
U
R
C
E
U
S
E
R
,
p
=
SOURCE_USER,p=
SOURCEUSER,p=SOURCE_PASSWORD,D=
S
O
U
R
C
E
D
A
T
A
B
A
S
E
,
t
=
b
y
o
p
e
r
a
t
i
o
n
m
a
s
t
e
r
−
−
w
h
e
r
e
s
¨
c
h
e
d
u
l
e
d
d
a
t
e
t
i
m
e
b
e
t
w
e
e
n
′
SOURCE_DATABASE,t=by_operation_master --where \"scheduled_date_time between '
SOURCEDATABASE,t=byoperationmaster−−wheres¨cheduleddatetimebetween′START_DATE’ and 'KaTeX parse error: Expected group as argument to '\"' at position 12: END_DATE'\" ̲--charset=SOURCE_CHARSET --no-delete --statistics --progress=
P
R
O
G
R
E
S
S
−
−
l
i
m
i
t
=
PROGRESS --limit=
PROGRESS−−limit=LIMIT --txn-size=KaTeX parse error: Expected group as argument to '\"' at end of input: …SIZE --file=\"SOURCE_PATH
C
U
R
R
E
N
T
D
A
T
E
/
CURRENT_DATE/
CURRENTDATE/START_DATE-$END_DATE-by_operation_master.txt”"
echo “归档命令： $COMMON_MASTER” >> $LOG_FILE
echo -e “\n” >> $LOG_FILE
echo “归档执行中,请稍等…” >> $LOG_FILE
执行归档命令
eval $COMMON_MASTER >> $LOG_FILE
echo “表名: by_operation_master $START_DATE - $END_DATE 归档完成” >> $LOG_FILE
echo -e “\n\n\n” >> $LOG_FILE
echo “###############################################################” >> $LOG_FILE
echo “###############################################################” >> $LOG_FILE
开始备份 by_operation_patient
echo “by_operation_patient 开始备份: $START_DATE - $END_DATE " >>
L
O
G
F
I
L
E
C
O
M
M
O
N
M
A
S
T
E
R
=
"
LOG_FILE COMMON_MASTER="
LOGFILECOMMONMASTER="BASE_PATH/pt-archiver --source h=
S
O
U
R
C
E
H
O
S
T
,
P
=
SOURCE_HOST,P=
SOURCEHOST,P=SOURCE_PORT,u=
S
O
U
R
C
E
U
S
E
R
,
p
=
SOURCE_USER,p=
SOURCEUSER,p=SOURCE_PASSWORD,D=
S
O
U
R
C
E
D
A
T
A
B
A
S
E
,
t
=
b
y
o
p
e
r
a
t
i
o
n
p
a
t
i
e
n
t
−
−
w
h
e
r
e
o
¨
p
e
r
a
t
i
o
n
i
d
i
n
(
s
e
l
e
c
t
o
p
e
r
a
t
i
o
n
i
d
f
r
o
m
b
y
o
p
e
r
a
t
i
o
n
m
a
s
t
e
r
w
h
e
r
e
s
c
h
e
d
u
l
e
d
d
a
t
e
t
i
m
e
b
e
t
w
e
e
n
′
SOURCE_DATABASE,t=by_operation_patient --where \"operation_id in (select operation_id from by_operation_master where scheduled_date_time between '
SOURCEDATABASE,t=byoperationpatient−−whereo¨perationidin(selectoperationidfrombyoperationmasterwherescheduleddatetimebetween′START_DATE’ and 'KaTeX parse error: Expected group as argument to '\"' at position 13: END_DATE')\" ̲--charset=SOURCE_CHARSET --no-delete --statistics --progress=
P
R
O
G
R
E
S
S
−
−
l
i
m
i
t
=
PROGRESS --limit=
PROGRESS−−limit=LIMIT --txn-size=KaTeX parse error: Expected group as argument to '\"' at end of input: …SIZE --file=\"SOURCE_PATH
C
U
R
R
E
N
T
D
A
T
E
/
CURRENT_DATE/
CURRENTDATE/START_DATE-$END_DATE-by_operation_patient.txt”"
echo “归档命令： $COMMON_MASTER” >> $LOG_FILE
echo -e “\n” >> $LOG_FILE
echo “归档执行中,请稍等…” >> $LOG_FILE
执行归档命令
eval $COMMON_MASTER >> $LOG_FILE
echo “表名: by_operation_patient $START_DATE - $END_DATE 归档完成” >> $LOG_FILE
echo -e “\n\n\n” >> $LOG_FILE
echo “###############################################################” >> $LOG_FILE
echo “###############################################################” >> $LOG_FILE
开始备份 by_operation_staff
echo “by_operation_staff 开始备份: $START_DATE - $END_DATE " >>
L
O
G
F
I
L
E
C
O
M
M
O
N
M
A
S
T
E
R
=
"
LOG_FILE COMMON_MASTER="
LOGFILECOMMONMASTER="BASE_PATH/pt-archiver --source h=
S
O
U
R
C
E
H
O
S
T
,
P
=
SOURCE_HOST,P=
SOURCEHOST,P=SOURCE_PORT,u=
S
O
U
R
C
E
U
S
E
R
,
p
=
SOURCE_USER,p=
SOURCEUSER,p=SOURCE_PASSWORD,D=
S
O
U
R
C
E
D
A
T
A
B
A
S
E
,
t
=
b
y
o
p
e
r
a
t
i
o
n
s
t
a
f
f
−
−
w
h
e
r
e
o
¨
p
e
r
a
t
i
o
n
i
d
i
n
(
s
e
l
e
c
t
o
p
e
r
a
t
i
o
n
i
d
f
r
o
m
b
y
o
p
e
r
a
t
i
o
n
m
a
s
t
e
r
w
h
e
r
e
s
c
h
e
d
u
l
e
d
d
a
t
e
t
i
m
e
b
e
t
w
e
e
n
′
SOURCE_DATABASE,t=by_operation_staff --where \"operation_id in (select operation_id from by_operation_master where scheduled_date_time between '
SOURCEDATABASE,t=byoperationstaff−−whereo¨perationidin(selectoperationidfrombyoperationmasterwherescheduleddatetimebetween′START_DATE’ and 'KaTeX parse error: Expected group as argument to '\"' at position 13: END_DATE')\" ̲--charset=SOURCE_CHARSET --no-delete --statistics --progress=
P
R
O
G
R
E
S
S
−
−
l
i
m
i
t
=
PROGRESS --limit=
PROGRESS−−limit=LIMIT --txn-size=KaTeX parse error: Expected group as argument to '\"' at end of input: …SIZE --file=\"SOURCE_PATH
C
U
R
R
E
N
T
D
A
T
E
/
CURRENT_DATE/
CURRENTDATE/START_DATE-$END_DATE-by_operation_staff.txt”"
echo “归档命令： $COMMON_MASTER” >> $LOG_FILE
echo -e “\n” >> $LOG_FILE
echo “归档执行中,请稍等…” >> $LOG_FILE
执行归档命令
eval $COMMON_MASTER >> $LOG_FILE
echo “表名: by_operation_staff $START_DATE - $END_DATE 归档完成” >> $LOG_FILE
echo -e “\n\n\n” >> $LOG_FILE
echo “###############################################################” >> $LOG_FILE
echo “###############################################################” >> $LOG_FILE
开始备份 by_operation_name
echo “by_operation_name 开始备份: $START_DATE - $END_DATE " >>
L
O
G
F
I
L
E
C
O
M
M
O
N
M
A
S
T
E
R
=
"
LOG_FILE COMMON_MASTER="
LOGFILECOMMONMASTER="BASE_PATH/pt-archiver --source h=
S
O
U
R
C
E
H
O
S
T
,
P
=
SOURCE_HOST,P=
SOURCEHOST,P=SOURCE_PORT,u=
S
O
U
R
C
E
U
S
E
R
,
p
=
SOURCE_USER,p=
SOURCEUSER,p=SOURCE_PASSWORD,D=
S
O
U
R
C
E
D
A
T
A
B
A
S
E
,
t
=
b
y
o
p
e
r
a
t
i
o
n
n
a
m
e
−
−
w
h
e
r
e
o
¨
p
e
r
a
t
i
o
n
i
d
i
n
(
s
e
l
e
c
t
o
p
e
r
a
t
i
o
n
i
d
f
r
o
m
b
y
o
p
e
r
a
t
i
o
n
m
a
s
t
e
r
w
h
e
r
e
s
c
h
e
d
u
l
e
d
d
a
t
e
t
i
m
e
b
e
t
w
e
e
n
′
SOURCE_DATABASE,t=by_operation_name --where \"operation_id in (select operation_id from by_operation_master where scheduled_date_time between '
SOURCEDATABASE,t=byoperationname−−whereo¨perationidin(selectoperationidfrombyoperationmasterwherescheduleddatetimebetween′START_DATE’ and 'KaTeX parse error: Expected group as argument to '\"' at position 13: END_DATE')\" ̲--charset=SOURCE_CHARSET --no-delete --statistics --progress=
P
R
O
G
R
E
S
S
−
−
l
i
m
i
t
=
PROGRESS --limit=
PROGRESS−−limit=LIMIT --txn-size=KaTeX parse error: Expected group as argument to '\"' at end of input: …SIZE --file=\"SOURCE_PATH
C
U
R
R
E
N
T
D
A
T
E
/
CURRENT_DATE/
CURRENTDATE/START_DATE-$END_DATE-by_operation_name.txt”"
echo “归档命令： $COMMON_MASTER” >> $LOG_FILE
echo -e “\n” >> $LOG_FILE
echo “归档执行中,请稍等…” >> $LOG_FILE
执行归档命令
eval $COMMON_MASTER >> $LOG_FILE
echo “表名: by_operation_name $START_DATE - $END_DATE 归档完成” >> $LOG_FILE
echo -e “\n\n\n” >> $LOG_FILE
echo “###############################################################” >> $LOG_FILE
echo “###############################################################” >> $LOG_FILE
开始备份 by_operation_nursing_event
echo “by_operation_nursing_event 开始备份: $START_DATE - $END_DATE " >>
L
O
G
F
I
L
E
C
O
M
M
O
N
M
A
S
T
E
R
=
"
LOG_FILE COMMON_MASTER="
LOGFILECOMMONMASTER="BASE_PATH/pt-archiver --source h=
S
O
U
R
C
E
H
O
S
T
,
P
=
SOURCE_HOST,P=
SOURCEHOST,P=SOURCE_PORT,u=
S
O
U
R
C
E
U
S
E
R
,
p
=
SOURCE_USER,p=
SOURCEUSER,p=SOURCE_PASSWORD,D=
S
O
U
R
C
E
D
A
T
A
B
A
S
E
,
t
=
b
y
o
p
e
r
a
t
i
o
n
n
u
r
s
i
n
g
e
v
e
n
t
−
−
w
h
e
r
e
o
¨
p
e
r
a
t
i
o
n
i
d
i
n
(
s
e
l
e
c
t
o
p
e
r
a
t
i
o
n
i
d
f
r
o
m
b
y
o
p
e
r
a
t
i
o
n
m
a
s
t
e
r
w
h
e
r
e
s
c
h
e
d
u
l
e
d
d
a
t
e
t
i
m
e
b
e
t
w
e
e
n
′
SOURCE_DATABASE,t=by_operation_nursing_event --where \"operation_id in (select operation_id from by_operation_master where scheduled_date_time between '
SOURCEDATABASE,t=byoperationnursingevent−−whereo¨perationidin(selectoperationidfrombyoperationmasterwherescheduleddatetimebetween′START_DATE’ and 'KaTeX parse error: Expected group as argument to '\"' at position 13: END_DATE')\" ̲--charset=SOURCE_CHARSET --no-delete --statistics --progress=
P
R
O
G
R
E
S
S
−
−
l
i
m
i
t
=
PROGRESS --limit=
PROGRESS−−limit=LIMIT --txn-size=KaTeX parse error: Expected group as argument to '\"' at end of input: …SIZE --file=\"SOURCE_PATH
C
U
R
R
E
N
T
D
A
T
E
/
CURRENT_DATE/
CURRENTDATE/START_DATE-$END_DATE-by_operation_nursing_event.txt”"
echo “归档命令： $COMMON_MASTER” >> $LOG_FILE
echo -e “\n” >> $LOG_FILE
echo “归档执行中,请稍等…” >> $LOG_FILE
执行归档命令
eval $COMMON_MASTER >> $LOG_FILE
echo “表名: by_operation_nursing_event $START_DATE - $END_DATE 归档完成” >> $LOG_FILE
echo -e “\n\n\n” >> $LOG_FILE
echo “###############################################################” >> $LOG_FILE
echo “###############################################################” >> $LOG_FILE
开始备份 by_record
echo “by_record 开始备份: $START_DATE - $END_DATE " >>
L
O
G
F
I
L
E
C
O
M
M
O
N
M
A
S
T
E
R
=
"
LOG_FILE COMMON_MASTER="
LOGFILECOMMONMASTER="BASE_PATH/pt-archiver --source h=
S
O
U
R
C
E
H
O
S
T
,
P
=
SOURCE_HOST,P=
SOURCEHOST,P=SOURCE_PORT,u=
S
O
U
R
C
E
U
S
E
R
,
p
=
SOURCE_USER,p=
SOURCEUSER,p=SOURCE_PASSWORD,D=
S
O
U
R
C
E
D
A
T
A
B
A
S
E
,
t
=
b
y
r
e
c
o
r
d
−
−
w
h
e
r
e
o
¨
p
e
r
a
t
i
o
n
i
d
i
n
(
s
e
l
e
c
t
o
p
e
r
a
t
i
o
n
i
d
f
r
o
m
b
y
o
p
e
r
a
t
i
o
n
m
a
s
t
e
r
w
h
e
r
e
s
c
h
e
d
u
l
e
d
d
a
t
e
t
i
m
e
b
e
t
w
e
e
n
′
SOURCE_DATABASE,t=by_record --where \"operation_id in (select operation_id from by_operation_master where scheduled_date_time between '
SOURCEDATABASE,t=byrecord−−whereo¨perationidin(selectoperationidfrombyoperationmasterwherescheduleddatetimebetween′START_DATE’ and 'KaTeX parse error: Expected group as argument to '\"' at position 13: END_DATE')\" ̲--charset=SOURCE_CHARSET --no-delete --statistics --progress=
P
R
O
G
R
E
S
S
−
−
l
i
m
i
t
=
PROGRESS --limit=
PROGRESS−−limit=LIMIT --txn-size=KaTeX parse error: Expected group as argument to '\"' at end of input: …SIZE --file=\"SOURCE_PATH
C
U
R
R
E
N
T
D
A
T
E
/
CURRENT_DATE/
CURRENTDATE/START_DATE-$END_DATE-by_record.txt”"
echo “归档命令： $COMMON_MASTER” >> $LOG_FILE
echo -e “\n” >> $LOG_FILE
echo “归档执行中,请稍等…” >> $LOG_FILE
执行归档命令
eval $COMMON_MASTER >> $LOG_FILE
echo “表名: by_record $START_DATE - $END_DATE 归档完成” >> $LOG_FILE
echo -e “\n\n\n” >> $LOG_FILE
echo “###############################################################” >> $LOG_FILE
echo “###############################################################” >> $LOG_FILE
开始备份 by_record_detail
echo “by_record_detail 开始备份: $START_DATE - $END_DATE " >>
L
O
G
F
I
L
E
C
O
M
M
O
N
M
A
S
T
E
R
=
"
LOG_FILE COMMON_MASTER="
LOGFILECOMMONMASTER="BASE_PATH/pt-archiver --source h=
S
O
U
R
C
E
H
O
S
T
,
P
=
SOURCE_HOST,P=
SOURCEHOST,P=SOURCE_PORT,u=
S
O
U
R
C
E
U
S
E
R
,
p
=
SOURCE_USER,p=
SOURCEUSER,p=SOURCE_PASSWORD,D=
S
O
U
R
C
E
D
A
T
A
B
A
S
E
,
t
=
b
y
r
e
c
o
r
d
d
e
t
a
i
l
−
−
w
h
e
r
e
r
¨
e
c
o
r
d
i
d
i
n
(
s
e
l
e
c
t
r
e
c
o
r
d
i
d
f
r
o
m
b
y
r
e
c
o
r
d
w
h
e
r
e
o
p
e
r
a
t
i
o
n
i
d
i
n
(
s
e
l
e
c
t
o
p
e
r
a
t
i
o
n
i
d
f
r
o
m
b
y
o
p
e
r
a
t
i
o
n
m
a
s
t
e
r
w
h
e
r
e
s
c
h
e
d
u
l
e
d
d
a
t
e
t
i
m
e
b
e
t
w
e
e
n
′
SOURCE_DATABASE,t=by_record_detail --where \"record_id in (select record_id from by_record where operation_id in (select operation_id from by_operation_master where scheduled_date_time between '
SOURCEDATABASE,t=byrecorddetail−−wherer¨ecordidin(selectrecordidfrombyrecordwhereoperationidin(selectoperationidfrombyoperationmasterwherescheduleddatetimebetween′START_DATE’ and 'KaTeX parse error: Expected group as argument to '\"' at position 14: END_DATE'))\" ̲--charset=SOURCE_CHARSET --no-delete --statistics --progress=
P
R
O
G
R
E
S
S
−
−
l
i
m
i
t
=
PROGRESS --limit=
PROGRESS−−limit=LIMIT --txn-size=KaTeX parse error: Expected group as argument to '\"' at end of input: …SIZE --file=\"SOURCE_PATH
C
U
R
R
E
N
T
D
A
T
E
/
CURRENT_DATE/
CURRENTDATE/START_DATE-$END_DATE-by_record_detail.txt”"
echo “归档命令： $COMMON_MASTER” >> $LOG_FILE
echo -e “\n” >> $LOG_FILE
echo “归档执行中,请稍等…” >> $LOG_FILE
执行归档命令
eval $COMMON_MASTER >> $LOG_FILE
echo “表名: by_record_detail $START_DATE - $END_DATE 归档完成” >> $LOG_FILE
echo -e “\n\n\n” >> $LOG_FILE
echo “###############################################################” >> $LOG_FILE
echo “###############################################################” >> $LOG_FILE
开始备份 by_surgical_incision
echo “by_surgical_incision 开始备份: $START_DATE - $END_DATE " >>
L
O
G
F
I
L
E
C
O
M
M
O
N
M
A
S
T
E
R
=
"
LOG_FILE COMMON_MASTER="
LOGFILECOMMONMASTER="BASE_PATH/pt-archiver --source h=
S
O
U
R
C
E
H
O
S
T
,
P
=
SOURCE_HOST,P=
SOURCEHOST,P=SOURCE_PORT,u=
S
O
U
R
C
E
U
S
E
R
,
p
=
SOURCE_USER,p=
SOURCEUSER,p=SOURCE_PASSWORD,D=
S
O
U
R
C
E
D
A
T
A
B
A
S
E
,
t
=
b
y
s
u
r
g
i
c
a
l
i
n
c
i
s
i
o
n
−
−
w
h
e
r
e
o
¨
p
e
r
a
t
i
o
n
i
d
i
n
(
s
e
l
e
c
t
o
p
e
r
a
t
i
o
n
i
d
f
r
o
m
b
y
o
p
e
r
a
t
i
o
n
m
a
s
t
e
r
w
h
e
r
e
s
c
h
e
d
u
l
e
d
d
a
t
e
t
i
m
e
b
e
t
w
e
e
n
′
SOURCE_DATABASE,t=by_surgical_incision --where \"operation_id in (select operation_id from by_operation_master where scheduled_date_time between '
SOURCEDATABASE,t=bysurgicalincision−−whereo¨perationidin(selectoperationidfrombyoperationmasterwherescheduleddatetimebetween′START_DATE’ and 'KaTeX parse error: Expected group as argument to '\"' at position 13: END_DATE')\" ̲--charset=SOURCE_CHARSET --no-delete --statistics --progress=
P
R
O
G
R
E
S
S
−
−
l
i
m
i
t
=
PROGRESS --limit=
PROGRESS−−limit=LIMIT --txn-size=KaTeX parse error: Expected group as argument to '\"' at end of input: …SIZE --file=\"SOURCE_PATH
C
U
R
R
E
N
T
D
A
T
E
/
CURRENT_DATE/
CURRENTDATE/START_DATE-$END_DATE-by_surgical_incision.txt”"
echo “归档命令： $COMMON_MASTER” >> $LOG_FILE
echo -e “\n” >> $LOG_FILE
echo “归档执行中,请稍等…” >> $LOG_FILE
执行归档命令
eval $COMMON_MASTER >> $LOG_FILE
echo “表名: by_surgical_incision $START_DATE - $END_DATE 归档完成” >> $LOG_FILE
echo -e “\n\n\n” >> $LOG_FILE
echo “###############################################################” >> $LOG_FILE
echo “###############################################################” >> $LOG_FILE
开始备份 by_incision_instrument
echo “by_incision_instrument 开始备份: $START_DATE - $END_DATE " >>
L
O
G
F
I
L
E
C
O
M
M
O
N
M
A
S
T
E
R
=
"
LOG_FILE COMMON_MASTER="
LOGFILECOMMONMASTER="BASE_PATH/pt-archiver --source h=
S
O
U
R
C
E
H
O
S
T
,
P
=
SOURCE_HOST,P=
SOURCEHOST,P=SOURCE_PORT,u=
S
O
U
R
C
E
U
S
E
R
,
p
=
SOURCE_USER,p=
SOURCEUSER,p=SOURCE_PASSWORD,D=
S
O
U
R
C
E
D
A
T
A
B
A
S
E
,
t
=
b
y
i
n
c
i
s
i
o
n
i
n
s
t
r
u
m
e
n
t
−
−
w
h
e
r
e
i
¨
n
c
i
s
i
o
n
i
d
i
n
(
s
e
l
e
c
t
i
n
c
i
s
i
o
n
i
d
f
r
o
m
b
y
s
u
r
g
i
c
a
l
i
n
c
i
s
i
o
n
w
h
e
r
e
o
p
e
r
a
t
i
o
n
i
d
i
n
(
s
e
l
e
c
t
o
p
e
r
a
t
i
o
n
i
d
f
r
o
m
b
y
o
p
e
r
a
t
i
o
n
m
a
s
t
e
r
w
h
e
r
e
s
c
h
e
d
u
l
e
d
d
a
t
e
t
i
m
e
b
e
t
w
e
e
n
′
SOURCE_DATABASE,t=by_incision_instrument --where \"incision_id in (select incision_id from by_surgical_incision where operation_id in (select operation_id from by_operation_master where scheduled_date_time between '
SOURCEDATABASE,t=byincisioninstrument−−wherei¨ncisionidin(selectincisionidfrombysurgicalincisionwhereoperationidin(selectoperationidfrombyoperationmasterwherescheduleddatetimebetween′START_DATE’ and 'KaTeX parse error: Expected group as argument to '\"' at position 14: END_DATE'))\" ̲--charset=SOURCE_CHARSET --no-delete --statistics --progress=
P
R
O
G
R
E
S
S
−
−
l
i
m
i
t
=
PROGRESS --limit=
PROGRESS−−limit=LIMIT --txn-size=KaTeX parse error: Expected group as argument to '\"' at end of input: …SIZE --file=\"SOURCE_PATH
C
U
R
R
E
N
T
D
A
T
E
/
CURRENT_DATE/
CURRENTDATE/START_DATE-$END_DATE-by_incision_instrument.txt”"
echo “归档命令： $COMMON_MASTER” >> $LOG_FILE
echo -e “\n” >> $LOG_FILE
echo “归档执行中,请稍等…” >> $LOG_FILE
执行归档命令
eval $COMMON_MASTER >> $LOG_FILE
echo “表名: by_incision_instrument $START_DATE - $END_DATE 归档完成” >> $LOG_FILE
echo -e “\n\n\n” >> $LOG_FILE
echo “###############################################################” >> $LOG_FILE
echo “###############################################################” >> $LOG_FILE
开始备份 by_incision_check_record
echo “by_incision_check_record 开始备份: $START_DATE - $END_DATE " >>
L
O
G
F
I
L
E
C
O
M
M
O
N
M
A
S
T
E
R
=
"
LOG_FILE COMMON_MASTER="
LOGFILECOMMONMASTER="BASE_PATH/pt-archiver --source h=
S
O
U
R
C
E
H
O
S
T
,
P
=
SOURCE_HOST,P=
SOURCEHOST,P=SOURCE_PORT,u=
S
O
U
R
C
E
U
S
E
R
,
p
=
SOURCE_USER,p=
SOURCEUSER,p=SOURCE_PASSWORD,D=
S
O
U
R
C
E
D
A
T
A
B
A
S
E
,
t
=
b
y
i
n
c
i
s
i
o
n
c
h
e
c
k
r
e
c
o
r
d
−
−
w
h
e
r
e
i
¨
n
c
i
s
i
o
n
i
d
i
n
(
s
e
l
e
c
t
i
n
c
i
s
i
o
n
i
d
f
r
o
m
b
y
s
u
r
g
i
c
a
l
i
n
c
i
s
i
o
n
w
h
e
r
e
o
p
e
r
a
t
i
o
n
i
d
i
n
(
s
e
l
e
c
t
o
p
e
r
a
t
i
o
n
i
d
f
r
o
m
b
y
o
p
e
r
a
t
i
o
n
m
a
s
t
e
r
w
h
e
r
e
s
c
h
e
d
u
l
e
d
d
a
t
e
t
i
m
e
b
e
t
w
e
e
n
′
SOURCE_DATABASE,t=by_incision_check_record --where \"incision_id in (select incision_id from by_surgical_incision where operation_id in (select operation_id from by_operation_master where scheduled_date_time between '
SOURCEDATABASE,t=byincisioncheckrecord−−wherei¨ncisionidin(selectincisionidfrombysurgicalincisionwhereoperationidin(selectoperationidfrombyoperationmasterwherescheduleddatetimebetween′START_DATE’ and 'KaTeX parse error: Expected group as argument to '\"' at position 14: END_DATE'))\" ̲--charset=SOURCE_CHARSET --no-delete --statistics --progress=
P
R
O
G
R
E
S
S
−
−
l
i
m
i
t
=
PROGRESS --limit=
PROGRESS−−limit=LIMIT --txn-size=KaTeX parse error: Expected group as argument to '\"' at end of input: …SIZE --file=\"SOURCE_PATH
C
U
R
R
E
N
T
D
A
T
E
/
CURRENT_DATE/
CURRENTDATE/START_DATE-$END_DATE-by_incision_check_record.txt”"
echo “归档命令： $COMMON_MASTER” >> $LOG_FILE
echo -e “\n” >> $LOG_FILE
echo “归档执行中,请稍等…” >> $LOG_FILE
执行归档命令
eval $COMMON_MASTER >> $LOG_FILE
echo “表名: by_incision_check_record $START_DATE - $END_DATE 归档完成” >> $LOG_FILE
echo -e “\n\n\n” >> $LOG_FILE
echo “###############################################################” >> $LOG_FILE
echo “###############################################################” >> $LOG_FILE
开始备份 by_incision_check_detail
echo “by_incision_check_detail 开始备份: $START_DATE - $END_DATE " >>
L
O
G
F
I
L
E
C
O
M
M
O
N
M
A
S
T
E
R
=
"
LOG_FILE COMMON_MASTER="
LOGFILECOMMONMASTER="BASE_PATH/pt-archiver --source h=
S
O
U
R
C
E
H
O
S
T
,
P
=
SOURCE_HOST,P=
SOURCEHOST,P=SOURCE_PORT,u=
S
O
U
R
C
E
U
S
E
R
,
p
=
SOURCE_USER,p=
SOURCEUSER,p=SOURCE_PASSWORD,D=
S
O
U
R
C
E
D
A
T
A
B
A
S
E
,
t
=
b
y
i
n
c
i
s
i
o
n
c
h
e
c
k
d
e
t
a
i
l
−
−
w
h
e
r
e
c
¨
h
e
c
k
r
e
c
o
r
d
i
d
i
n
(
s
e
l
e
c
t
c
h
e
c
k
r
e
c
o
r
d
i
d
f
r
o
m
b
y
i
n
c
i
s
i
o
n
c
h
e
c
k
r
e
c
o
r
d
w
h
e
r
e
i
n
c
i
s
i
o
n
i
d
i
n
(
s
e
l
e
c
t
i
n
c
i
s
i
o
n
i
d
f
r
o
m
b
y
s
u
r
g
i
c
a
l
i
n
c
i
s
i
o
n
w
h
e
r
e
o
p
e
r
a
t
i
o
n
i
d
i
n
(
s
e
l
e
c
t
o
p
e
r
a
t
i
o
n
i
d
f
r
o
m
b
y
o
p
e
r
a
t
i
o
n
m
a
s
t
e
r
w
h
e
r
e
s
c
h
e
d
u
l
e
d
d
a
t
e
t
i
m
e
b
e
t
w
e
e
n
′
SOURCE_DATABASE,t=by_incision_check_detail --where \"check_record_id in (select check_record_id from by_incision_check_record where incision_id in (select incision_id from by_surgical_incision where operation_id in (select operation_id from by_operation_master where scheduled_date_time between '
SOURCEDATABASE,t=byincisioncheckdetail−−wherec¨heckrecordidin(selectcheckrecordidfrombyincisioncheckrecordwhereincisionidin(selectincisionidfrombysurgicalincisionwhereoperationidin(selectoperationidfrombyoperationmasterwherescheduleddatetimebetween′START_DATE’ and 'KaTeX parse error: Expected group as argument to '\"' at position 15: END_DATE')))\" ̲--charset=SOURCE_CHARSET --no-delete --statistics --progress=
P
R
O
G
R
E
S
S
−
−
l
i
m
i
t
=
PROGRESS --limit=
PROGRESS−−limit=LIMIT --txn-size=KaTeX parse error: Expected group as argument to '\"' at end of input: …SIZE --file=\"SOURCE_PATH
C
U
R
R
E
N
T
D
A
T
E
/
CURRENT_DATE/
CURRENTDATE/START_DATE-$END_DATE-by_incision_check_detail.txt”"
echo “归档命令： $COMMON_MASTER” >> $LOG_FILE
echo -e “\n” >> $LOG_FILE
echo “归档执行中,请稍等…” >> $LOG_FILE
执行归档命令
eval $COMMON_MASTER >> $LOG_FILE
echo “表名: by_incision_check_detail $START_DATE - $END_DATE 归档完成” >> $LOG_FILE
echo -e “\n\n\n” >> $LOG_FILE
echo “###############################################################” >> $LOG_FILE
echo “###############################################################” >> $LOG_FILE
开始备份 by_operation_remark
echo “by_operation_remark 开始备份: $START_DATE - $END_DATE " >>
L
O
G
F
I
L
E
C
O
M
M
O
N
M
A
S
T
E
R
=
"
LOG_FILE COMMON_MASTER="
LOGFILECOMMONMASTER="BASE_PATH/pt-archiver --source h=
S
O
U
R
C
E
H
O
S
T
,
P
=
SOURCE_HOST,P=
SOURCEHOST,P=SOURCE_PORT,u=
S
O
U
R
C
E
U
S
E
R
,
p
=
SOURCE_USER,p=
SOURCEUSER,p=SOURCE_PASSWORD,D=
S
O
U
R
C
E
D
A
T
A
B
A
S
E
,
t
=
b
y
o
p
e
r
a
t
i
o
n
r
e
m
a
r
k
−
−
w
h
e
r
e
i
¨
n
c
i
s
i
o
n
i
d
i
n
(
s
e
l
e
c
t
i
n
c
i
s
i
o
n
i
d
f
r
o
m
b
y
s
u
r
g
i
c
a
l
i
n
c
i
s
i
o
n
w
h
e
r
e
o
p
e
r
a
t
i
o
n
i
d
i
n
(
s
e
l
e
c
t
o
p
e
r
a
t
i
o
n
i
d
f
r
o
m
b
y
o
p
e
r
a
t
i
o
n
m
a
s
t
e
r
w
h
e
r
e
s
c
h
e
d
u
l
e
d
d
a
t
e
t
i
m
e
b
e
t
w
e
e
n
′
SOURCE_DATABASE,t=by_operation_remark --where \"incision_id in (select incision_id from by_surgical_incision where operation_id in (select operation_id from by_operation_master where scheduled_date_time between '
SOURCEDATABASE,t=byoperationremark−−wherei¨ncisionidin(selectincisionidfrombysurgicalincisionwhereoperationidin(selectoperationidfrombyoperationmasterwherescheduleddatetimebetween′START_DATE’ and 'KaTeX parse error: Expected group as argument to '\"' at position 14: END_DATE'))\" ̲--charset=SOURCE_CHARSET --no-delete --statistics --progress=
P
R
O
G
R
E
S
S
−
−
l
i
m
i
t
=
PROGRESS --limit=
PROGRESS−−limit=LIMIT --txn-size=KaTeX parse error: Expected group as argument to '\"' at end of input: …SIZE --file=\"SOURCE_PATH
C
U
R
R
E
N
T
D
A
T
E
/
CURRENT_DATE/
CURRENTDATE/START_DATE-$END_DATE-by_operation_remark.txt”"
echo “归档命令： $COMMON_MASTER” >> $LOG_FILE
echo -e “\n” >> $LOG_FILE
echo “归档执行中,请稍等…” >> $LOG_FILE
执行归档命令
eval $COMMON_MASTER >> $LOG_FILE
echo “表名: by_operation_remark $START_DATE - $END_DATE 归档完成” >> $LOG_FILE
echo -e “\n\n\n” >> $LOG_FILE
echo “###############################################################” >> $LOG_FILE
echo “###############################################################” >> $LOG_FILE
开始备份 by_sign_record
echo “by_sign_record 开始备份: $START_DATE - $END_DATE " >>
L
O
G
F
I
L
E
C
O
M
M
O
N
M
A
S
T
E
R
=
"
LOG_FILE COMMON_MASTER="
LOGFILECOMMONMASTER="BASE_PATH/pt-archiver --source h=
S
O
U
R
C
E
H
O
S
T
,
P
=
SOURCE_HOST,P=
SOURCEHOST,P=SOURCE_PORT,u=
S
O
U
R
C
E
U
S
E
R
,
p
=
SOURCE_USER,p=
SOURCEUSER,p=SOURCE_PASSWORD,D=
S
O
U
R
C
E
D
A
T
A
B
A
S
E
,
t
=
b
y
s
i
g
n
r
e
c
o
r
d
−
−
w
h
e
r
e
b
¨
u
s
i
n
e
s
s
i
d
i
n
(
s
e
l
e
c
t
r
e
c
o
r
d
i
d
f
r
o
m
b
y
r
e
c
o
r
d
w
h
e
r
e
o
p
e
r
a
t
i
o
n
i
d
i
n
(
s
e
l
e
c
t
o
p
e
r
a
t
i
o
n
i
d
f
r
o
m
b
y
o
p
e
r
a
t
i
o
n
m
a
s
t
e
r
w
h
e
r
e
s
c
h
e
d
u
l
e
d
d
a
t
e
t
i
m
e
b
e
t
w
e
e
n
′
SOURCE_DATABASE,t=by_sign_record --where \"business_id in (select record_id from by_record where operation_id in (select operation_id from by_operation_master where scheduled_date_time between '
SOURCEDATABASE,t=bysignrecord−−whereb¨usinessidin(selectrecordidfrombyrecordwhereoperationidin(selectoperationidfrombyoperationmasterwherescheduleddatetimebetween′START_DATE’ and ‘
E
N
D
D
A
T
E
′
)
U
N
I
O
N
s
e
l
e
c
t
i
n
c
i
s
i
o
n
i
d
f
r
o
m
b
y
s
u
r
g
i
c
a
l
i
n
c
i
s
i
o
n
w
h
e
r
e
o
p
e
r
a
t
i
o
n
i
d
i
n
(
s
e
l
e
c
t
o
p
e
r
a
t
i
o
n
i
d
f
r
o
m
b
y
o
p
e
r
a
t
i
o
n
m
a
s
t
e
r
w
h
e
r
e
s
c
h
e
d
u
l
e
d
d
a
t
e
t
i
m
e
b
e
t
w
e
e
n
′
END_DATE') UNION select incision_id from by_surgical_incision where operation_id in (select operation_id from by_operation_master where scheduled_date_time between '
ENDDATE′)UNIONselectincisionidfrombysurgicalincisionwhereoperationidin(selectoperationidfrombyoperationmasterwherescheduleddatetimebetween′START_DATE’ and ‘
E
N
D
D
A
T
E
′
)
U
N
I
O
N
s
e
l
e
c
t
c
h
e
c
k
r
e
c
o
r
d
i
d
f
r
o
m
b
y
i
n
c
i
s
i
o
n
c
h
e
c
k
r
e
c
o
r
d
w
h
e
r
e
i
n
c
i
s
i
o
n
i
d
i
n
(
s
e
l
e
c
t
i
n
c
i
s
i
o
n
i
d
f
r
o
m
b
y
s
u
r
g
i
c
a
l
i
n
c
i
s
i
o
n
w
h
e
r
e
o
p
e
r
a
t
i
o
n
i
d
i
n
(
s
e
l
e
c
t
o
p
e
r
a
t
i
o
n
i
d
f
r
o
m
b
y
o
p
e
r
a
t
i
o
n
m
a
s
t
e
r
w
h
e
r
e
s
c
h
e
d
u
l
e
d
d
a
t
e
t
i
m
e
b
e
t
w
e
e
n
′
END_DATE') UNION select check_record_id from by_incision_check_record where incision_id in (select incision_id from by_surgical_incision where operation_id in (select operation_id from by_operation_master where scheduled_date_time between '
ENDDATE′)UNIONselectcheckrecordidfrombyincisioncheckrecordwhereincisionidin(selectincisionidfrombysurgicalincisionwhereoperationidin(selectoperationidfrombyoperationmasterwherescheduleddatetimebetween′START_DATE’ and 'KaTeX parse error: Expected group as argument to '\"' at position 15: END_DATE')))\" ̲--charset=SOURCE_CHARSET --no-delete --statistics --progress=
P
R
O
G
R
E
S
S
−
−
l
i
m
i
t
=
PROGRESS --limit=
PROGRESS−−limit=LIMIT --txn-size=KaTeX parse error: Expected group as argument to '\"' at end of input: …SIZE --file=\"SOURCE_PATH
C
U
R
R
E
N
T
D
A
T
E
/
CURRENT_DATE/
CURRENTDATE/START_DATE-$END_DATE-by_sign_record.txt”"
echo “归档命令： $COMMON_MASTER” >> $LOG_FILE
echo -e “\n” >> $LOG_FILE
echo “归档执行中,请稍等…” >> $LOG_FILE
执行归档命令
eval $COMMON_MASTER >> $LOG_FILE
echo “表名: by_sign_record $START_DATE - $END_DATE 归档完成” >> $LOG_FILE
echo -e “\n\n\n” >> $LOG_FILE
echo “###############################################################” >> $LOG_FILE
echo “###############################################################” >> $LOG_FILE
开始备份 by_ca_sign_record
echo “by_ca_sign_record 开始备份: $START_DATE - $END_DATE " >>
L
O
G
F
I
L
E
C
O
M
M
O
N
M
A
S
T
E
R
=
"
LOG_FILE COMMON_MASTER="
LOGFILECOMMONMASTER="BASE_PATH/pt-archiver --source h=
S
O
U
R
C
E
H
O
S
T
,
P
=
SOURCE_HOST,P=
SOURCEHOST,P=SOURCE_PORT,u=
S
O
U
R
C
E
U
S
E
R
,
p
=
SOURCE_USER,p=
SOURCEUSER,p=SOURCE_PASSWORD,D=
S
O
U
R
C
E
D
A
T
A
B
A
S
E
,
t
=
b
y
c
a
s
i
g
n
r
e
c
o
r
d
−
−
w
h
e
r
e
s
¨
i
g
n
r
e
c
o
r
d
i
d
i
n
(
s
e
l
e
c
t
s
i
g
n
r
e
c
o
r
d
i
d
f
r
o
m
b
y
s
i
g
n
r
e
c
o
r
d
w
h
e
r
e
b
u
s
i
n
e
s
s
i
d
i
n
(
s
e
l
e
c
t
r
e
c
o
r
d
i
d
f
r
o
m
b
y
r
e
c
o
r
d
w
h
e
r
e
o
p
e
r
a
t
i
o
n
i
d
i
n
(
s
e
l
e
c
t
o
p
e
r
a
t
i
o
n
i
d
f
r
o
m
b
y
o
p
e
r
a
t
i
o
n
m
a
s
t
e
r
w
h
e
r
e
s
c
h
e
d
u
l
e
d
d
a
t
e
t
i
m
e
b
e
t
w
e
e
n
′
SOURCE_DATABASE,t=by_ca_sign_record --where \"sign_record_id in (select sign_record_id from by_sign_record where business_id in (select record_id from by_record where operation_id in (select operation_id from by_operation_master where scheduled_date_time between '
SOURCEDATABASE,t=bycasignrecord−−wheres¨ignrecordidin(selectsignrecordidfrombysignrecordwherebusinessidin(selectrecordidfrombyrecordwhereoperationidin(selectoperationidfrombyoperationmasterwherescheduleddatetimebetween′START_DATE’ and ‘
E
N
D
D
A
T
E
′
)
U
N
I
O
N
s
e
l
e
c
t
i
n
c
i
s
i
o
n
i
d
f
r
o
m
b
y
s
u
r
g
i
c
a
l
i
n
c
i
s
i
o
n
w
h
e
r
e
o
p
e
r
a
t
i
o
n
i
d
i
n
(
s
e
l
e
c
t
o
p
e
r
a
t
i
o
n
i
d
f
r
o
m
b
y
o
p
e
r
a
t
i
o
n
m
a
s
t
e
r
w
h
e
r
e
s
c
h
e
d
u
l
e
d
d
a
t
e
t
i
m
e
b
e
t
w
e
e
n
′
END_DATE') UNION select incision_id from by_surgical_incision where operation_id in (select operation_id from by_operation_master where scheduled_date_time between '
ENDDATE′)UNIONselectincisionidfrombysurgicalincisionwhereoperationidin(selectoperationidfrombyoperationmasterwherescheduleddatetimebetween′START_DATE’ and ‘
E
N
D
D
A
T
E
′
)
U
N
I
O
N
s
e
l
e
c
t
c
h
e
c
k
r
e
c
o
r
d
i
d
f
r
o
m
b
y
i
n
c
i
s
i
o
n
c
h
e
c
k
r
e
c
o
r
d
w
h
e
r
e
i
n
c
i
s
i
o
n
i
d
i
n
(
s
e
l
e
c
t
i
n
c
i
s
i
o
n
i
d
f
r
o
m
b
y
s
u
r
g
i
c
a
l
i
n
c
i
s
i
o
n
w
h
e
r
e
o
p
e
r
a
t
i
o
n
i
d
i
n
(
s
e
l
e
c
t
o
p
e
r
a
t
i
o
n
i
d
f
r
o
m
b
y
o
p
e
r
a
t
i
o
n
m
a
s
t
e
r
w
h
e
r
e
s
c
h
e
d
u
l
e
d
d
a
t
e
t
i
m
e
b
e
t
w
e
e
n
′
END_DATE') UNION select check_record_id from by_incision_check_record where incision_id in (select incision_id from by_surgical_incision where operation_id in (select operation_id from by_operation_master where scheduled_date_time between '
ENDDATE′)UNIONselectcheckrecordidfrombyincisioncheckrecordwhereincisionidin(selectincisionidfrombysurgicalincisionwhereoperationidin(selectoperationidfrombyoperationmasterwherescheduleddatetimebetween′START_DATE’ and 'KaTeX parse error: Expected group as argument to '\"' at position 16: END_DATE'))))\" ̲--charset=SOURCE_CHARSET --no-delete --statistics --progress=
P
R
O
G
R
E
S
S
−
−
l
i
m
i
t
=
PROGRESS --limit=
PROGRESS−−limit=LIMIT --txn-size=KaTeX parse error: Expected group as argument to '\"' at end of input: …SIZE --file=\"SOURCE_PATH
C
U
R
R
E
N
T
D
A
T
E
/
CURRENT_DATE/
CURRENTDATE/START_DATE-$END_DATE-by_ca_sign_record.txt”"
echo “归档命令： $COMMON_MASTER” >> $LOG_FILE
echo -e “\n” >> $LOG_FILE
echo “归档执行中,请稍等…” >> $LOG_FILE
执行归档命令
eval $COMMON_MASTER >> $LOG_FILE
echo “表名: by_ca_sign_record $START_DATE - $END_DATE 归档完成” >> $LOG_FILE
echo -e “\n\n\n” >> $LOG_FILE
echo “###############################################################” >> $LOG_FILE
echo “###############################################################” >> $LOG_FILE
开始备份 by_archived_record_log
echo “by_archived_record_log 开始备份: $START_DATE - $END_DATE " >>
L
O
G
F
I
L
E
C
O
M
M
O
N
M
A
S
T
E
R
=
"
LOG_FILE COMMON_MASTER="
LOGFILECOMMONMASTER="BASE_PATH/pt-archiver --source h=
S
O
U
R
C
E
H
O
S
T
,
P
=
SOURCE_HOST,P=
SOURCEHOST,P=SOURCE_PORT,u=
S
O
U
R
C
E
U
S
E
R
,
p
=
SOURCE_USER,p=
SOURCEUSER,p=SOURCE_PASSWORD,D=
S
O
U
R
C
E
D
A
T
A
B
A
S
E
,
t
=
b
y
a
r
c
h
i
v
e
d
r
e
c
o
r
d
l
o
g
−
−
w
h
e
r
e
a
¨
r
c
h
i
v
e
d
r
e
c
o
r
d
i
d
i
n
(
s
e
l
e
c
t
r
e
c
o
r
d
i
d
f
r
o
m
b
y
r
e
c
o
r
d
w
h
e
r
e
o
p
e
r
a
t
i
o
n
i
d
i
n
(
s
e
l
e
c
t
o
p
e
r
a
t
i
o
n
i
d
f
r
o
m
b
y
o
p
e
r
a
t
i
o
n
m
a
s
t
e
r
w
h
e
r
e
s
c
h
e
d
u
l
e
d
d
a
t
e
t
i
m
e
b
e
t
w
e
e
n
′
SOURCE_DATABASE,t=by_archived_record_log --where \"archived_record_id in (select record_id from by_record where operation_id in (select operation_id from by_operation_master where scheduled_date_time between '
SOURCEDATABASE,t=byarchivedrecordlog−−wherea¨rchivedrecordidin(selectrecordidfrombyrecordwhereoperationidin(selectoperationidfrombyoperationmasterwherescheduleddatetimebetween′START_DATE’ and ‘
E
N
D
D
A
T
E
′
)
U
N
I
O
N
s
e
l
e
c
t
o
p
e
r
a
t
i
o
n
i
d
f
r
o
m
b
y
o
p
e
r
a
t
i
o
n
m
a
s
t
e
r
w
h
e
r
e
s
c
h
e
d
u
l
e
d
d
a
t
e
t
i
m
e
b
e
t
w
e
e
n
′
END_DATE') UNION select operation_id from by_operation_master where scheduled_date_time between '
ENDDATE′)UNIONselectoperationidfrombyoperationmasterwherescheduleddatetimebetween′START_DATE’ and 'KaTeX parse error: Expected group as argument to '\"' at position 13: END_DATE')\" ̲--charset=SOURCE_CHARSET --no-delete --statistics --progress=
P
R
O
G
R
E
S
S
−
−
l
i
m
i
t
=
PROGRESS --limit=
PROGRESS−−limit=LIMIT --txn-size=KaTeX parse error: Expected group as argument to '\"' at end of input: …SIZE --file=\"SOURCE_PATH
C
U
R
R
E
N
T
D
A
T
E
/
CURRENT_DATE/
CURRENTDATE/START_DATE-$END_DATE-by_archived_record_log.txt”"
echo “归档命令： $COMMON_MASTER” >> $LOG_FILE
echo -e “\n” >> $LOG_FILE
echo “归档执行中,请稍等…” >> $LOG_FILE
执行归档命令
eval $COMMON_MASTER >> $LOG_FILE
echo “表名: by_archived_record_log $START_DATE - $END_DATE 归档完成” >> $LOG_FILE
echo -e “\n\n\n” >> $LOG_FILE
echo “###############################################################” >> $LOG_FILE
echo “开始压缩” >> $LOG_FILE
#COMMON_TRA="tar -czf
S
T
A
R
T
D
A
T
E
−
START_DATE-
STARTDATE−END_DATE.tar.gz $CURRENT_DATE "
COMMON_TRA="pwd "
#eval $COMMON_TRA >> $LOG_FILE
echo “压缩完成” >> $LOG_FILE