备份数据的时候将数据库备份文件压缩后远程备份

whyclj

2019-07-26 79004d812d6fbaceab22f64a2776cbc831ba416c

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
Êþº¾4
O
com/backup/DataBaseBackUpThread
java/lang/Thread
REGULAR_BACKUP_MAXCOUNT

I
 ConstantValue
INSTANT_BACKUP_MAXCOUNT

REGULAR_BACKUP_PATHNAME
Ljava/lang/String;
REGULAR_BACKUP
INSTANT_BACKUP_PATHNAME
INSTANT_BACKUP
list
Ljava/util/List;
    Signature
,Ljava/util/List<Lcom/backup/DatabaseTable;>;
pool
Lcom/sql/MysqlConnPool;
savePath
runtime
Lcom/backup/MyRunTime;
<init>
(Lcom/sql/MysqlConnPool;)V
Code
 
()V"
java/util/ArrayList
!    
%'
java/lang/StringBuilder)
user.dir
+-,
java/lang/System./
getProperty
&(Ljava/lang/String;)Ljava/lang/String;
132
java/lang/String45
valueOf
&(Ljava/lang/Object;)Ljava/lang/String;
&78
(Ljava/lang/String;)V    :<;
java/io/File=
    separator
&?@A
append
-(Ljava/lang/String;)Ljava/lang/StringBuilder;C
mysql_backup
&EFG
toString
()Ljava/lang/String;    
I    
K    
MO
com/backup/MyRunTime
NQ
SUT
#com/backup/DataBaseBackUpThread_SQLV
createBackupTable
SXYZ
searchAllDataBaseAndTable
)(Lcom/sql/MysqlConnPool;)Ljava/util/List;
S\]^
inseartBackupTable
*(Lcom/sql/MysqlConnPool;Ljava/util/List;)V
LineNumberTable
LocalVariableTable
this
!Lcom/backup/DataBaseBackUpThread;
    conn_pool
run    +fgh
out
Ljava/io/PrintStream;

jkG
getNamem
" - DataBaseBackUpThread  start at o
java/util/Date
nr
yyyy-MM-dd HH:mm:ss
tvu
com/base/Comwx
getDateTimeFormat
6(Ljava/util/Date;Ljava/lang/String;)Ljava/lang/String;
z|{
java/io/PrintStream}8
println
n€
(III)V

‚ƒ„
createNomalDate
"(Ljava/util/Date;)Ljava/util/Date;

†‡ˆ
 countTimeLong
#(Ljava/util/Date;Ljava/util/Date;)J    :€Ž
开始备份所有的数据库

‘’
deleteFileRoot
(Ljava/lang/String;I)V”
yyyy-MM-dd_HH_mm_ss–˜—
java/util/List™š
get
(I)Ljava/lang/Object;œ
com/backup/DatabaseTable
›žŸG
getDatabase_name
S¡¢£
 isSpecialChar
(Ljava/lang/String;)Z
›¥¦G
 getTable_name

¨©8
craeteFileRoot
N«¬­
exec
9(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Z–¯°±
size
()I³
com/backup/ZipUtil
²¶
.zip
:7
²¹º»
    createZip
0(Ljava/lang/String;Ljava/io/File;)Ljava/io/File;½
com/backup/HzipSocket
¼
¼ÀÁ8
initÃ
远程备份数据库完成
:ÅÆÇ
exists
()Z
:ÉÊË
length
()J

ÏÐÑ
    deleteDir
(Ljava/io/File;)Z
SÓÔZ
searAllTableState
›Ö×Ø

setBack_en
(I)V
SÚÛÜ
UpdateDataBaseState
4(Lcom/sql/MysqlConnPool;Lcom/backup/DatabaseTable;)VÞ
开始备份
&à@á
(I)Ljava/lang/StringBuilder;ã
 个表    at 
ô

çèé
sleep
(J)V
ëíì
java/lang/Exceptionî 
printStackTrace
 lastRecodTime
Ljava/util/Date;
normTime
nowTime
path

i
table
Lcom/backup/DatabaseTable;
rootPath
zipUtil
Lcom/backup/ZipUtil;
zipName
zipFile
Ljava/io/File;
SocketClient
Lcom/backup/HzipSocket;
root
count
flag

Z

e
Ljava/lang/Exception;
 StackMapTable


yyyy-MM-dd
    
     10:36:30
t


 
getDateTimeFromStr
6(Ljava/lang/String;Ljava/lang/String;)Ljava/util/Date;
time
time_str
n

Ë
getTime




java/lang/Math


abs
(J)Jè
start
end
:

Ç
mkdirs
filepath

f
:
#
$
%
    listFiles
()[Ljava/io/File;
'
7com/backup/DataBaseBackUpThread$CompratorByLastModified

&

*
,
+
java/util/Arrays
-
.
sort
,([Ljava/lang/Object;Ljava/util/Comparator;)V
filePath
    filecount
file
files
[Ljava/io/File;
3
main
([Ljava/lang/String;)V
8
d:/aaaa
args
[Ljava/lang/String;
:
<
=Ç
isDirectory
:
?
@
()[Ljava/lang/String;
:
B
C
#(Ljava/io/File;Ljava/lang/String;)V
:
E
FÇ
delete
dir
children
success
:

SourceFile
DataBaseBackUpThread.java
InnerClasses
CompratorByLastModified!

    


 



¿g*·*»!Y·#µ$*»&Y(¸*¸0·6²9¶>B¶>¶DµH*
µJ*+µL*»NY*´L·PµJ*´L¸R**´L¸Wµ$*´L*´$¸[±_*
05:I P"[$f(`gabgc

d 
—²e»&Y*¶i¸0·6l¶>»nY·pq¸s¶>¶D¶y»nYз~L
M
N»nY·pN-¸M*-,¶…‰”œ
¹*+-¶…‹”›
¬²e»&Y·6»nY·pq¸s¶>¶D¶y**´L¸Wµ$»&Y*´H¸0·6²9¶> ¶>¶D:¸»&Y¸0·6²9¶>-“¸s¶>¶D:6§‹*´$¹•À›:¶¸ šm¶¤¸ ™§_»&Y¸0·6²9¶>*´$¹•À›¶¶>¶D:¸§*´J*´$¹•À›¶*´$¹•À›¶¤¶ªW„
*´$¹®
¡ÿm-L*´L*´$¸[»²Y·´:»&Y¸0·6µ¶>¶D:»:Y··¸¸:»¼Y·¾:¶¿²e»&Y·6»nY·pq¸s¶>¶D¶y¶Ä™+¶È̔ž»:Y··¶Ä™»:Y··¸ÎW**´L¸Òµ$*´$¹®
ž
d»&Y*´H¸0·6²9¶>¶>¶D:»&Y¸0·6²9¶>-“¸s¶>¶D:66§†*´$¹•À›:¶¸ šh¶¤¸ ™§Z
¸„
»&Y¸0·6²9¶>¶¶>¶D:        ¸§*´J¶¶¤    ¶ª6
 
™¶Õ*´L¸Ù„
*´$¹®
¡ÿrž‡»²Y·´:»&Y¸0·6µ¶>¶D:»:Y··¸¸:        ¶Ä™+    ¶È̔ž»:Y··¶Ä™»:Y··¸ÎW²e»&YÝ·6¶ßâ¶>-“¸s¶>¶D¶yä¸æ§ü²:¶ê§ü¨
<Šë_î;/+081:2<5D6I:c;„<=­>³?Ó@ÙAéBÿC
E
-F
2G
^@
oI
qJ
|L
…M
›N
«Q
´R
»S
ÜT
ÿUZ[#\A]a^d_j`zab“dšef¼gÁjÖlÛnáoê_ûst    uv/wRx_z„}Š~”3`è—ab8_ïð
:]ñð<[òð­
_ó֙ôéuõö
-1÷
…‡øù
›qú
«aûü
´XýþA
Cÿa
#ód
 
g”ôzpõö¼.÷    Ö



    {øùeú/Uûü    


 þ<nnnýœ1
ü(›ú[ùªÿ]
nnn11

ü(›úVÿq

nnn11
²1:ÿ$
nnnHë    ƒ„
Z"»&Y*
¸s¸0·6
¶>¶DL+q¸

°_
‰‹`"
ð


‡ˆ
O,¶
+¶
e¸

m­_
•` ab
ð

ð    ©8
d»:Y*··L+¶Äš+¶
W±_œ    ž `
      
!ü


ü:    ‘’
ÍE»:Y*··M,¶Ä™7,¶
"N-»
&Y·
(¸
)-¾¡!žd6§-2¸ÎW„
-¾¡ÿñ±_&    ¨    ©ª« ¬*®2¯:®D³`4E
/E
0
    <
1ü/
2
3/ô
þ2:
4

ù    
5
6
7
    
7¸±_
¹º`
    
9
:
ÐÑ
¬4*¶
;™+*¶
>L=§»:Y*+2·
A¸Î>š¬„
+¾¡ÿå*¶
D¬_"ÒÓÕÖ ×$Ø&Õ/Ý`*4
Gü#
H
:
!ô 
I

ý
J
ù
K
L
M


&

N