Êþº¾ 4D com/sql/MysqlDBBackUp_Thread java/lang/Thread m_conn_pool Lcom/sql/MysqlConnPool; db_path Ljava/lang/String; back_up_day I m_latest_backup_time Ljava/util/Date; mSqlConnPort <init> 0(Lcom/config/AppConfig;Lcom/sql/MysqlConnPool;)V Code
|
()V
|
java/util/Date
|
"
|
|
$ & % com/config/AppConfig ' ( getAutoSqlDbBackUpDayInterval ()I
|
* , + com/sql/MysqlConnPool - ( getSqlConnPort / com/sql/Sql_Mysql
|
* 1 2 3 getConn ()Ljava/sql/Connection;
|
. 5 6 (Ljava/sql/Connection;)V 8 &select @@basedir as basePath from dual
|
. : ; < sqlMysqlQuery ((Ljava/lang/String;)Ljava/sql/ResultSet; > @ ? java/sql/ResultSet A B next ()Z > D E F getString (I)Ljava/lang/String; H :
|
J L K java/lang/String M N indexOf (Ljava/lang/String;)I
|
J P Q R substring (II)Ljava/lang/String; T 6SELECT SqlDB_BackUpTime FROM `db_app_sys`.`tb_app_sys` > V W X getTimestamp (I)Ljava/sql/Timestamp;
|
Z \ [ java/sql/SQLException ] printStackTrace
|
. _ ` close_con LineNumberTable LocalVariableTable this Lcom/sql/MysqlDBBackUp_Thread; cfg Lcom/config/AppConfig; con_pool sql Lcom/sql/Sql_Mysql; res Ljava/sql/ResultSet; e Ljava/sql/SQLException; StackMapTable p java/lang/Throwable run s u t java/lang/System v w out Ljava/io/PrintStream; y java/lang/StringBuilder
|
{ | } getName ()Ljava/lang/String;
|
J valueOf &(Ljava/lang/Object;)Ljava/lang/String;
|
x (Ljava/lang/String;)V # - MysqlDBBackUp_Thread Started ...
|
x append -(Ljava/lang/String;)Ljava/lang/StringBuilder;
|
x } toString
|
java/io/PrintStream println è
|
sleep (J)V
|
B getSqlDB_BackUpManual_EN
|
\ java/lang/InterruptedException Q
|
¡ ¢ £ getTime ()J Q § * - MysqlDBBackUp_Thread backup all dbs at © yyyy-MM-dd HH:mm:ss
|
« ¬ com/base/Com ® ¯ getDateTimeFormat 6(Ljava/util/Date;Ljava/lang/String;)Ljava/lang/String;
|
± ²
|
doDbBackUp
|
´ µ updateBackupInf
|
· \ ¸ java/lang/Exception db_backup_manual_en Z n h Ljava/lang/InterruptedException; dt dt_s J Ljava/lang/Exception; Ã ;SELECT SqlDB_BackUpManual_EN FROM `db_app_sys`.`tb_app_sys` > Å Æ Ç
|
getBoolean (I)Z en Ê 8UPDATE `db_app_sys`.`tb_app_sys` SET SqlDB_BackUpTime=' Ì ', Î SqlDB_BackUpManual_EN=false
|
. Ð Ñ sqlMysqlExecute Ó all_backup_ Õ yyyy-MM-dd+HH_mm_ss × Ù Ø java/io/File Ú separator Ü bin Þ mysqldump -P
|
x à á (I)Ljava/lang/StringBuilder; ã ' -uroot -plmx8688139 --all-databases > å &echo popstar hello
|
ç é è java/lang/Runtime ê ë
|
getRuntime ()Ljava/lang/Runtime; í cmd
|
ç ï ð ñ exec '(Ljava/lang/String;)Ljava/lang/Process; ó java/io/InputStreamReader
|
õ ÷ ö java/lang/Process ø ù getErrorStream ()Ljava/io/InputStream;
|
ò û ü (Ljava/io/InputStream;)V þ java/io/BufferedReader
|
ý (Ljava/io/Reader;)V java/io/OutputStreamWriter
|
õ getOutputStream ()Ljava/io/OutputStream;
|
|
(Ljava/io/OutputStream;)V java/io/BufferedWriter
|
(Ljava/io/Writer;)V
|
write
|
newLine del *.bksql rename .bksql
|
! " flush
|
$ % close
|
$
|
ý( ) } readLine
|
õ+ , destroy
|
ý$
|
ò$
|
0 \1 java/io/IOException ps Ljava/lang/Process; tmp_filename cmd_str isr Ljava/io/InputStreamReader; br Ljava/io/BufferedReader; osw Ljava/io/OutputStreamWriter; bw Ljava/io/BufferedWriter; target_filename line e2 Ljava/io/IOException;
|
SourceFile MysqlDBBackUp_Thread.java !
|
|
à ½*· *µ *µ * µ *» Y· µ *ºµ !*+¶ #µ *,µ **´ ¶ )µ !» .Y*´ ¶ 0· 4N-7¶ 9:¹ = #*¹ C µ *´ *´ G¶ I`¶ OW-S¶ 9:¹ = )*¹ U µ § :¶ Y-¶ ^§ :-¶ ^¿-¶ ^± N ¡ Z N ¨ ¯ a f ' / 4 ? " N $ V % ` & l ' * + , . £ / ¨ 1 ¯ 0 ± 1 µ 2 ¸ 1 ¼ 3 b > ½ c d ½ e f ½ g N o h i V H j k £ l m n 4 ÿ $ * . > ÿ $ * . ZM o q Ø Æ² r» xY*¶ z¸ ~·
¶ ¶ ¶ <=§ `>§ ¸ *· < § :¶ ¡ÿá § :» Y· N-¶ *´ ¶ e m7 ¤m*´
§ *´ ¡ÿ² r» xY*¶ z¸ ~· ¦¶ » Y· ¨¸ ª¶ ¶ ¶ *· °*· ³§ÿaL+¶ ¶§ÿY ( 7 : » ¾ · a j 8 < = # > ( @ . A 3 B 7 C : E < G A > J K N L Q O Y P k Q z R } = V W ° V ³ X · Y » Z ¿ [ à : b R Æ c d ¹ º h »
|
% % ¼
|
< l ½ Y $ ¾ k ¿ À ¿ l Á n ( ý ü Q ú +ú ÿ 5 · B ø G<» .Y*´ ¶ 0· 4M,¶ 9N-¹ = #-¹ Ä <§ N-¶ Y,¶ ^§ :,¶ ^¿,¶ ^¬ ) , Z 1 8 a 6 c d f g ! h ) j - k 1 m 8 l : m > n A m E o b 4 G c d E È º 6 h i j k - l m n ÿ , . ZK o µ ï S» .Y*´ ¶ 0· 4L+» xYÉ· » Y· ¨¸ ª¶ ˶ Ͷ ¶ ¶ ϧ M,¶ Y+¶ ^§ N+¶ ^-¿+¶ ^± 8 ; Z @ G a 6 u w y - z 5 w 8 { < | @ ~ G } H ~ L N ~ R b S c d D h i < l m n ÿ ; . ZK o ² ³
|
i» xYÒ· » Y· Ô¸ ª¶ ¶ M» xY*´ ¸ ~· ² Ö¶ Û¶ ² Ö¶ ݶ *´ !¶ ßⶠ*´ ¶ ² Ö¶ ,¶ ä¶ ¶ N¸ æì¶ îL» òY+¶ ô· ú:» ýY· ÿ:»Y+¶·:» Y· :-¶¶» xY· *´ ¶ ² Ö¶ ¶ ¶ ¶¶» xYÒ· » Y· Ô¸ ª¶ ¶ :» xY· *´ ¶ ² Ö¶ ,¶ ¶ ¶ ¶ ¶ ¶¶¶ ¶#¶&: § ² r ¶ ¶'Y: Çÿð+¶*¶-¶.§ M,¶/± `c0 a ~ ; L ] b f o | ¥ ª Ï Ô ñ % * / 4 9 ¡< £? ¤G £R ¦V §[ ¨` ©d «h b p i c d o ô23 D4 f ú5 | ä67 Ù89 Ì:; Á<= ñ o> < $? d @A n 6 ÿ?
|
õ J J ò ý J J ÿ 0 B C
|
