B-A数据同步脚本.pdfVIP

1db=`cat/upload/mysqlbackup/sync/B-A/db.txt`

2

3a=`date+%F`

4

5#time=`date+%Y-%m-%d-%H-%M-%S`

6

7if[!-d/upload/mysqlbackup/sync/B-A/$a];then

8

9mkdir/upload/mysqlbackup/sync/B-A/$a

10else

11echo/upload/mysqlbackup/sync/B-A/$a已经存在

12

13fi

14

15cd/upload/mysqlbackup/sync/B-A/$a

16

17

18

19#echo$db

20

21foriin$db

22do

23

24

25

26

27mysqldump-uprodb-h-P3306-

p505801184Aa@$i/upload/mysqlbackup/sync/B-A/$a/$i-$a.sql

28

29cd/upload/mysqlbackup/sync/B-A/$a

30

31#gunzip/upload/mysqlbackup/$a/$i-$a.sql.gz

32

33#gunzip$i-$a.sql.gz

34

35

36done

37

38

39

40

41mysql-uappa-h-pb3fIWIwc1j9^ZhR-D

app/upload/mysqlbackup/sync/B-A/$a/app_b-$a.sql

42

43

44mysql-uassistanta-h-

p%i6k^@61TUh#PQ3k-Dassistant/upload/mysqlbackup/sync/B-A/$a/assistant-$a.sql

45

46mysql-udica-h-pGu^#lxypbh5GXNH7-D

cfyy_dic/upload/mysqlbackup/sync/B-A/$a/cfyy_dic_b-$a.sql

47

48mysql-uesa-h-pn8p9dCp%W0W%e8R9-D

cfyy_es/upload/mysqlbackup/sync/B-A/$a/cfyy_es_b-$a.sql

49

50mysql-uidgena-h-pjTgUa$tMs6qVcWYu-D

cfyy_id_gen/upload/mysqlbackup/sync/B-A/$a/cfyy_id_gen_b-$a.sql

51

52mysql-upaya-h-pX4S!vF@F*v1WvYr8-D

cfyy_pay/upload/mysqlbackup/sync/B-A/$a/cfyy_pay_b-$a.sql

53

54mysql-ubjcfyyfa-h-pG^ozvUAc2fjMZJU8-D

cfyy_pharmacy_p_bjcfyyf/upload/mysqlbackup/sync/B-

A/$a/cfyy_pharmacy_p_bjcfyyf_b-$a.sql

55

56mysql-ubjcfzyf149a-h-

pbYjo*oZ7dwRh6#p5-Dcfyy_pharmacy_p_bjcfzyf_149/upload/mysqlbackup/sync/B-

A/$a/cfyy_pharmacy_p_bjcfzyf_b_149-$a.sql

57

58mysql-ucdcfyy154a-h-pA4Cw#wvAX*jV$g^m

-Dcfyy_pharmacy_p_cdcfyy_154/upload/mysqlbackup/sync/B-

A/$a/cfyy_pharmacy_p_cdcfyy_154_b-$a.sql

59

60mysql-ujx151a-h-pqSrvB!yS8VP79ih%-D

cfyy_pharmacy_p_jx_151/upload/mysqlbackup/sync/B-A/$a/cfyy_pharmac