From fbed4c7738db69c0d6a30c10f6944268ba28ea9e Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期二, 19 一月 2021 14:42:49 +0800
Subject: [PATCH] 本地备份数据库程序
---
BattMonitor_FBS9100S_DataBaseBackUp/.settings/org.eclipse.core.resources.prefs | 1
BattMonitor_FBS9100S_DataBaseBackUp/bin/.gitignore | 2
BattMonitor_FBS9100S_DataBaseBackUp/src/com/version_inf/version_inf.txt | 6 +
BattMonitor_FBS9100S_DataBaseBackUp/bin/com/version_inf/version_inf.txt | 6 +
BattMonitor_FBS9100S_DataBaseBackUp/src/com/backup/DataBaseBackUpThread.java | 10 ++-
BattMonitor_FBS9100S_DataBaseBackUp/bin/com/backup/DataBaseBackUpThread$CompratorByLastModified.class | 0
/dev/null | 112 -------------------------------------
BattMonitor_FBS9100S_DataBaseBackUp/bin/com/backup/HzipSocket.class | 0
BattMonitor_FBS9100S_DataBaseBackUp/src/com/backup/HzipSocket.java | 28 ++++++++-
BattMonitor_FBS9100S_DataBaseBackUp/config.xml | 2
BattMonitor_FBS9100S_DataBaseBackUp/src/com/backup/MyRunTime.java | 2
BattMonitor_FBS9100S_DataBaseBackUp/src/main/main_FBS9100S_DataBaseBackUp.java | 4
BattMonitor_FBS9100S_DataBaseBackUp/bin/com/backup/DataBaseBackUpThread.class | 0
BattMonitor_FBS9100S_DataBaseBackUp/bin/com/backup/MyRunTime.class | 0
BattMonitor_FBS9100S_DataBaseBackUp/bin/main/main_FBS9100S_DataBaseBackUp.class | 0
15 files changed, 46 insertions(+), 127 deletions(-)
diff --git a/BattMonitor_FBS9100S_DataBaseBackUp/.settings/org.eclipse.core.resources.prefs b/BattMonitor_FBS9100S_DataBaseBackUp/.settings/org.eclipse.core.resources.prefs
index 86673f5..4d78260 100644
--- a/BattMonitor_FBS9100S_DataBaseBackUp/.settings/org.eclipse.core.resources.prefs
+++ b/BattMonitor_FBS9100S_DataBaseBackUp/.settings/org.eclipse.core.resources.prefs
@@ -1,3 +1,4 @@
eclipse.preferences.version=1
encoding//src/com/backup/MyRunTime.java=UTF-8
encoding//src/com/backup/ZipUtil.java=UTF-8
+encoding/<project>=GBK
diff --git a/BattMonitor_FBS9100S_DataBaseBackUp/bin/.gitignore b/BattMonitor_FBS9100S_DataBaseBackUp/bin/.gitignore
new file mode 100644
index 0000000..7ee0bfd
--- /dev/null
+++ b/BattMonitor_FBS9100S_DataBaseBackUp/bin/.gitignore
@@ -0,0 +1,2 @@
+/com/
+/main/
diff --git a/BattMonitor_FBS9100S_DataBaseBackUp/bin/com/backup/DataBaseBackUpThread$CompratorByLastModified.class b/BattMonitor_FBS9100S_DataBaseBackUp/bin/com/backup/DataBaseBackUpThread$CompratorByLastModified.class
index 085f5db..6c85429 100644
--- a/BattMonitor_FBS9100S_DataBaseBackUp/bin/com/backup/DataBaseBackUpThread$CompratorByLastModified.class
+++ b/BattMonitor_FBS9100S_DataBaseBackUp/bin/com/backup/DataBaseBackUpThread$CompratorByLastModified.class
Binary files differ
diff --git a/BattMonitor_FBS9100S_DataBaseBackUp/bin/com/backup/DataBaseBackUpThread.class b/BattMonitor_FBS9100S_DataBaseBackUp/bin/com/backup/DataBaseBackUpThread.class
index ed65989..bc4334b 100644
--- a/BattMonitor_FBS9100S_DataBaseBackUp/bin/com/backup/DataBaseBackUpThread.class
+++ b/BattMonitor_FBS9100S_DataBaseBackUp/bin/com/backup/DataBaseBackUpThread.class
Binary files differ
diff --git a/BattMonitor_FBS9100S_DataBaseBackUp/bin/com/backup/HzipSocket.class b/BattMonitor_FBS9100S_DataBaseBackUp/bin/com/backup/HzipSocket.class
index 0a9472b..0ffcdc1 100644
--- a/BattMonitor_FBS9100S_DataBaseBackUp/bin/com/backup/HzipSocket.class
+++ b/BattMonitor_FBS9100S_DataBaseBackUp/bin/com/backup/HzipSocket.class
Binary files differ
diff --git a/BattMonitor_FBS9100S_DataBaseBackUp/bin/com/backup/MyRunTime.class b/BattMonitor_FBS9100S_DataBaseBackUp/bin/com/backup/MyRunTime.class
index 1b41064..a0677d4 100644
--- a/BattMonitor_FBS9100S_DataBaseBackUp/bin/com/backup/MyRunTime.class
+++ b/BattMonitor_FBS9100S_DataBaseBackUp/bin/com/backup/MyRunTime.class
Binary files differ
diff --git a/BattMonitor_FBS9100S_DataBaseBackUp/bin/com/version_inf/version_inf.txt b/BattMonitor_FBS9100S_DataBaseBackUp/bin/com/version_inf/version_inf.txt
index ae26054..25a83d6 100644
--- a/BattMonitor_FBS9100S_DataBaseBackUp/bin/com/version_inf/version_inf.txt
+++ b/BattMonitor_FBS9100S_DataBaseBackUp/bin/com/version_inf/version_inf.txt
@@ -107,5 +107,7 @@
edit at date 2017-05-11 lijun
1.将config.xml文件中的mysql_conn_count_max 的值由300改为3000 --设置数据库最大链接数
-
-
\ No newline at end of file
+
+说明：该备份程序依赖于主程序或者安装目录不设置中文目录;远程备份端口为10100
+V1.201 2020-11-20
+ config.xml文件中的source_sqlserver_ip对应远程数据库备份主机的ip
\ No newline at end of file
diff --git a/BattMonitor_FBS9100S_DataBaseBackUp/bin/main/main_FBS9100S_DataBaseBackUp.class b/BattMonitor_FBS9100S_DataBaseBackUp/bin/main/main_FBS9100S_DataBaseBackUp.class
index 3224fc0..7635714 100644
--- a/BattMonitor_FBS9100S_DataBaseBackUp/bin/main/main_FBS9100S_DataBaseBackUp.class
+++ b/BattMonitor_FBS9100S_DataBaseBackUp/bin/main/main_FBS9100S_DataBaseBackUp.class
Binary files differ
diff --git a/BattMonitor_FBS9100S_DataBaseBackUp/config.xml b/BattMonitor_FBS9100S_DataBaseBackUp/config.xml
index 30dc0e9..23ae635 100644
--- a/BattMonitor_FBS9100S_DataBaseBackUp/config.xml
+++ b/BattMonitor_FBS9100S_DataBaseBackUp/config.xml
@@ -12,7 +12,7 @@
<!--SOURCE_SQLSERVER_TYPE_SYBASE = 1-->
<!--SOURCE_SQLSERVER_TYPE_MSSQLSERVER = 2-->
<source_sqlserver_type>0</source_sqlserver_type>
- <source_sqlserver_ip>127.0.0.1</source_sqlserver_ip>
+ <source_sqlserver_ip>192.168.10.222</source_sqlserver_ip>
<source_sqlserver_usrname>sxfg001</source_sqlserver_usrname>
<source_sqlserver_pwd>sxfg001</source_sqlserver_pwd>
<source_sqlserver_port>5000</source_sqlserver_port>
diff --git a/BattMonitor_FBS9100S_DataBaseBackUp/mysql_backup/INSTANT_BACKUP/2018-12-11_09_51_28/db_battinf/tb_battinf.sql b/BattMonitor_FBS9100S_DataBaseBackUp/mysql_backup/INSTANT_BACKUP/2018-12-11_09_51_28/db_battinf/tb_battinf.sql
deleted file mode 100644
index 3fff28b..0000000
--- a/BattMonitor_FBS9100S_DataBaseBackUp/mysql_backup/INSTANT_BACKUP/2018-12-11_09_51_28/db_battinf/tb_battinf.sql
+++ /dev/null
@@ -1,112 +0,0 @@
--- MySQL dump 10.13 Distrib 5.7.10, for Win64 (x86_64)
---
--- Host: 127.0.0.1 Database: db_battinf
--- ------------------------------------------------------
--- Server version 5.7.10
-
-/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
-/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
-/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
-/*!40101 SET NAMES utf8 */;
-/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
-/*!40103 SET TIME_ZONE='+00:00' */;
-/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
-/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
-/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
-/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
-
---
--- Table structure for table `tb_battinf`
---
-
-DROP TABLE IF EXISTS `tb_battinf`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `tb_battinf` (
- `num` int(11) NOT NULL AUTO_INCREMENT,
- `StationId` varchar(20) NOT NULL DEFAULT '0',
- `StationId_ex` varchar(20) DEFAULT '',
- `StationName` varchar(100) NOT NULL DEFAULT ' ',
- `StationName1` varchar(100) NOT NULL DEFAULT ' ',
- `StationName2` varchar(100) NOT NULL DEFAULT ' ',
- `StationName3` varchar(100) NOT NULL DEFAULT ' ',
- `StationName4` varchar(100) NOT NULL DEFAULT ' ',
- `StationName5` varchar(100) NOT NULL DEFAULT ' ',
- `StationName6` varchar(100) NOT NULL DEFAULT ' ',
- `StationName7` varchar(100) NOT NULL DEFAULT ' ',
- `StationName8` varchar(100) NOT NULL DEFAULT ' ',
- `StationName9` varchar(100) NOT NULL DEFAULT ' ',
- `StationIP` varchar(20) NOT NULL DEFAULT '0',
- `FBSDeviceId` bigint(11) NOT NULL DEFAULT '0',
- `FBSDeviceIp` varchar(50) NOT NULL DEFAULT '192.168.0.88',
- `FBSDeviceName` varchar(100) NOT NULL DEFAULT '0',
- `GroupIndexInFBSDevice` int(11) NOT NULL DEFAULT '0',
- `BattModel` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupId` int(11) NOT NULL DEFAULT '0',
- `BattGroupNum` int(11) NOT NULL DEFAULT '0',
- `BattGroupName` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName1` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName2` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName3` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName4` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName5` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName6` varchar(100) NOT NULL DEFAULT ' ',
- `FloatVolLevel` float NOT NULL DEFAULT '1.12',
- `OfflineVolLevel` float NOT NULL DEFAULT '1.06',
- `BattFloatCurrent` float NOT NULL DEFAULT '0',
- `DeviceId` varchar(20) NOT NULL DEFAULT '0',
- `DeviceName` varchar(100) NOT NULL DEFAULT '0',
- `MonCount` int(11) NOT NULL DEFAULT '0',
- `MonCapStd` float NOT NULL DEFAULT '0',
- `MonVolStd` float NOT NULL DEFAULT '0',
- `MonResStd` float NOT NULL DEFAULT '0',
- `MonSerStd` float NOT NULL DEFAULT '0',
- `MonTmpStd` float NOT NULL DEFAULT '0',
- `MonVolLowToAvg` float NOT NULL DEFAULT '0',
- `MonNum` int(11) NOT NULL DEFAULT '0',
- `BattProducer` varchar(45) NOT NULL DEFAULT '0',
- `BattProductDate` date NOT NULL DEFAULT '2006-07-06',
- `BattInUseDate` date NOT NULL DEFAULT '2006-07-06',
- `BattGuarantDayCount` int(11) NOT NULL DEFAULT '1095',
- `SignalId` varchar(20) NOT NULL DEFAULT '0',
- `CInterFaceId` int(11) NOT NULL DEFAULT '0',
- `SignalName` varchar(50) NOT NULL DEFAULT '0',
- `Load_curr` float NOT NULL DEFAULT '15',
- `disCurrMax` float NOT NULL DEFAULT '0',
- `FbsDeviceIp_YM` varchar(50) NOT NULL DEFAULT '255.255.255.0',
- `FbsDeviceIp_WG` varchar(50) NOT NULL DEFAULT '127.0.0.1',
- `station_phone` varchar(32) DEFAULT '',
- `station_install` tinyint(1) NOT NULL DEFAULT '0',
- `install_user` varchar(64) DEFAULT '',
- PRIMARY KEY (`num`),
- KEY `index_station_id` (`StationId`),
- KEY `index_battgroup_id` (`BattGroupId`),
- KEY `index_station_name` (`StationName`),
- KEY `index_battgroup_name` (`BattGroupName`)
-) ENGINE=InnoDB AUTO_INCREMENT=10522 DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `tb_battinf`
---
-
-LOCK TABLES `tb_battinf` WRITE;
-/*!40000 ALTER TABLE `tb_battinf` DISABLE KEYS */;
-INSERT INTO `tb_battinf` VALUES (10521,'42070469','','婀栧寳鐪�-姝︽眽甯�-瀹為獙瀹ゆ祴璇曟満鎴�-BTS璁惧','婀栧寳鐪�','姝︽眽甯�','瀹為獙瀹ゆ祴璇曟満鎴�','BTS璁惧',' ',' ',' ',' ',' ','192.168.0.5',910000002,'10.143.207.34','BTS',0,'UXL2N-300',1005054,6,'娴嬭瘯鐢垫睜缁�1',' ',' ',' ',' ',' ',' ',53.6,51.5,5,'0','0',24,300,2,2.5,2400,0,0.05,0,'姹ゆ祬','2012-05-04','2012-06-13',1095,'0',0,'0',15,0,'255.255.255.0','127.0.0.1','',1,'');
-/*!40000 ALTER TABLE `tb_battinf` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Dumping routines for database 'db_battinf'
---
-/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
-
-/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
-/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
-/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
-/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
-/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
-/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
-/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-
--- Dump completed on 2018-12-11 9:51:28
diff --git a/BattMonitor_FBS9100S_DataBaseBackUp/mysql_backup/INSTANT_BACKUP/2018-12-11_09_51_46/db_battinf/tb_battinf.sql b/BattMonitor_FBS9100S_DataBaseBackUp/mysql_backup/INSTANT_BACKUP/2018-12-11_09_51_46/db_battinf/tb_battinf.sql
deleted file mode 100644
index 2a998a4..0000000
--- a/BattMonitor_FBS9100S_DataBaseBackUp/mysql_backup/INSTANT_BACKUP/2018-12-11_09_51_46/db_battinf/tb_battinf.sql
+++ /dev/null
@@ -1,112 +0,0 @@
--- MySQL dump 10.13 Distrib 5.7.10, for Win64 (x86_64)
---
--- Host: 127.0.0.1 Database: db_battinf
--- ------------------------------------------------------
--- Server version 5.7.10
-
-/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
-/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
-/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
-/*!40101 SET NAMES utf8 */;
-/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
-/*!40103 SET TIME_ZONE='+00:00' */;
-/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
-/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
-/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
-/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
-
---
--- Table structure for table `tb_battinf`
---
-
-DROP TABLE IF EXISTS `tb_battinf`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `tb_battinf` (
- `num` int(11) NOT NULL AUTO_INCREMENT,
- `StationId` varchar(20) NOT NULL DEFAULT '0',
- `StationId_ex` varchar(20) DEFAULT '',
- `StationName` varchar(100) NOT NULL DEFAULT ' ',
- `StationName1` varchar(100) NOT NULL DEFAULT ' ',
- `StationName2` varchar(100) NOT NULL DEFAULT ' ',
- `StationName3` varchar(100) NOT NULL DEFAULT ' ',
- `StationName4` varchar(100) NOT NULL DEFAULT ' ',
- `StationName5` varchar(100) NOT NULL DEFAULT ' ',
- `StationName6` varchar(100) NOT NULL DEFAULT ' ',
- `StationName7` varchar(100) NOT NULL DEFAULT ' ',
- `StationName8` varchar(100) NOT NULL DEFAULT ' ',
- `StationName9` varchar(100) NOT NULL DEFAULT ' ',
- `StationIP` varchar(20) NOT NULL DEFAULT '0',
- `FBSDeviceId` bigint(11) NOT NULL DEFAULT '0',
- `FBSDeviceIp` varchar(50) NOT NULL DEFAULT '192.168.0.88',
- `FBSDeviceName` varchar(100) NOT NULL DEFAULT '0',
- `GroupIndexInFBSDevice` int(11) NOT NULL DEFAULT '0',
- `BattModel` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupId` int(11) NOT NULL DEFAULT '0',
- `BattGroupNum` int(11) NOT NULL DEFAULT '0',
- `BattGroupName` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName1` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName2` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName3` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName4` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName5` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName6` varchar(100) NOT NULL DEFAULT ' ',
- `FloatVolLevel` float NOT NULL DEFAULT '1.12',
- `OfflineVolLevel` float NOT NULL DEFAULT '1.06',
- `BattFloatCurrent` float NOT NULL DEFAULT '0',
- `DeviceId` varchar(20) NOT NULL DEFAULT '0',
- `DeviceName` varchar(100) NOT NULL DEFAULT '0',
- `MonCount` int(11) NOT NULL DEFAULT '0',
- `MonCapStd` float NOT NULL DEFAULT '0',
- `MonVolStd` float NOT NULL DEFAULT '0',
- `MonResStd` float NOT NULL DEFAULT '0',
- `MonSerStd` float NOT NULL DEFAULT '0',
- `MonTmpStd` float NOT NULL DEFAULT '0',
- `MonVolLowToAvg` float NOT NULL DEFAULT '0',
- `MonNum` int(11) NOT NULL DEFAULT '0',
- `BattProducer` varchar(45) NOT NULL DEFAULT '0',
- `BattProductDate` date NOT NULL DEFAULT '2006-07-06',
- `BattInUseDate` date NOT NULL DEFAULT '2006-07-06',
- `BattGuarantDayCount` int(11) NOT NULL DEFAULT '1095',
- `SignalId` varchar(20) NOT NULL DEFAULT '0',
- `CInterFaceId` int(11) NOT NULL DEFAULT '0',
- `SignalName` varchar(50) NOT NULL DEFAULT '0',
- `Load_curr` float NOT NULL DEFAULT '15',
- `disCurrMax` float NOT NULL DEFAULT '0',
- `FbsDeviceIp_YM` varchar(50) NOT NULL DEFAULT '255.255.255.0',
- `FbsDeviceIp_WG` varchar(50) NOT NULL DEFAULT '127.0.0.1',
- `station_phone` varchar(32) DEFAULT '',
- `station_install` tinyint(1) NOT NULL DEFAULT '0',
- `install_user` varchar(64) DEFAULT '',
- PRIMARY KEY (`num`),
- KEY `index_station_id` (`StationId`),
- KEY `index_battgroup_id` (`BattGroupId`),
- KEY `index_station_name` (`StationName`),
- KEY `index_battgroup_name` (`BattGroupName`)
-) ENGINE=InnoDB AUTO_INCREMENT=10522 DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `tb_battinf`
---
-
-LOCK TABLES `tb_battinf` WRITE;
-/*!40000 ALTER TABLE `tb_battinf` DISABLE KEYS */;
-INSERT INTO `tb_battinf` VALUES (10521,'42070469','','婀栧寳鐪�-姝︽眽甯�-瀹為獙瀹ゆ祴璇曟満鎴�-BTS璁惧','婀栧寳鐪�','姝︽眽甯�','瀹為獙瀹ゆ祴璇曟満鎴�','BTS璁惧',' ',' ',' ',' ',' ','192.168.0.5',910000002,'10.143.207.34','BTS',0,'UXL2N-300',1005054,6,'娴嬭瘯鐢垫睜缁�1',' ',' ',' ',' ',' ',' ',53.6,51.5,5,'0','0',24,300,2,2.5,2400,0,0.05,0,'姹ゆ祬','2012-05-04','2012-06-13',1095,'0',0,'0',15,0,'255.255.255.0','127.0.0.1','',1,'');
-/*!40000 ALTER TABLE `tb_battinf` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Dumping routines for database 'db_battinf'
---
-/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
-
-/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
-/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
-/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
-/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
-/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
-/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
-/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-
--- Dump completed on 2018-12-11 9:51:46
diff --git a/BattMonitor_FBS9100S_DataBaseBackUp/mysql_backup/INSTANT_BACKUP/2018-12-11_09_57_22/db_battinf/tb_battinf.sql b/BattMonitor_FBS9100S_DataBaseBackUp/mysql_backup/INSTANT_BACKUP/2018-12-11_09_57_22/db_battinf/tb_battinf.sql
deleted file mode 100644
index c0def78..0000000
--- a/BattMonitor_FBS9100S_DataBaseBackUp/mysql_backup/INSTANT_BACKUP/2018-12-11_09_57_22/db_battinf/tb_battinf.sql
+++ /dev/null
@@ -1,112 +0,0 @@
--- MySQL dump 10.13 Distrib 5.7.10, for Win64 (x86_64)
---
--- Host: 127.0.0.1 Database: db_battinf
--- ------------------------------------------------------
--- Server version 5.7.10
-
-/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
-/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
-/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
-/*!40101 SET NAMES utf8 */;
-/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
-/*!40103 SET TIME_ZONE='+00:00' */;
-/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
-/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
-/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
-/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
-
---
--- Table structure for table `tb_battinf`
---
-
-DROP TABLE IF EXISTS `tb_battinf`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `tb_battinf` (
- `num` int(11) NOT NULL AUTO_INCREMENT,
- `StationId` varchar(20) NOT NULL DEFAULT '0',
- `StationId_ex` varchar(20) DEFAULT '',
- `StationName` varchar(100) NOT NULL DEFAULT ' ',
- `StationName1` varchar(100) NOT NULL DEFAULT ' ',
- `StationName2` varchar(100) NOT NULL DEFAULT ' ',
- `StationName3` varchar(100) NOT NULL DEFAULT ' ',
- `StationName4` varchar(100) NOT NULL DEFAULT ' ',
- `StationName5` varchar(100) NOT NULL DEFAULT ' ',
- `StationName6` varchar(100) NOT NULL DEFAULT ' ',
- `StationName7` varchar(100) NOT NULL DEFAULT ' ',
- `StationName8` varchar(100) NOT NULL DEFAULT ' ',
- `StationName9` varchar(100) NOT NULL DEFAULT ' ',
- `StationIP` varchar(20) NOT NULL DEFAULT '0',
- `FBSDeviceId` bigint(11) NOT NULL DEFAULT '0',
- `FBSDeviceIp` varchar(50) NOT NULL DEFAULT '192.168.0.88',
- `FBSDeviceName` varchar(100) NOT NULL DEFAULT '0',
- `GroupIndexInFBSDevice` int(11) NOT NULL DEFAULT '0',
- `BattModel` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupId` int(11) NOT NULL DEFAULT '0',
- `BattGroupNum` int(11) NOT NULL DEFAULT '0',
- `BattGroupName` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName1` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName2` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName3` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName4` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName5` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName6` varchar(100) NOT NULL DEFAULT ' ',
- `FloatVolLevel` float NOT NULL DEFAULT '1.12',
- `OfflineVolLevel` float NOT NULL DEFAULT '1.06',
- `BattFloatCurrent` float NOT NULL DEFAULT '0',
- `DeviceId` varchar(20) NOT NULL DEFAULT '0',
- `DeviceName` varchar(100) NOT NULL DEFAULT '0',
- `MonCount` int(11) NOT NULL DEFAULT '0',
- `MonCapStd` float NOT NULL DEFAULT '0',
- `MonVolStd` float NOT NULL DEFAULT '0',
- `MonResStd` float NOT NULL DEFAULT '0',
- `MonSerStd` float NOT NULL DEFAULT '0',
- `MonTmpStd` float NOT NULL DEFAULT '0',
- `MonVolLowToAvg` float NOT NULL DEFAULT '0',
- `MonNum` int(11) NOT NULL DEFAULT '0',
- `BattProducer` varchar(45) NOT NULL DEFAULT '0',
- `BattProductDate` date NOT NULL DEFAULT '2006-07-06',
- `BattInUseDate` date NOT NULL DEFAULT '2006-07-06',
- `BattGuarantDayCount` int(11) NOT NULL DEFAULT '1095',
- `SignalId` varchar(20) NOT NULL DEFAULT '0',
- `CInterFaceId` int(11) NOT NULL DEFAULT '0',
- `SignalName` varchar(50) NOT NULL DEFAULT '0',
- `Load_curr` float NOT NULL DEFAULT '15',
- `disCurrMax` float NOT NULL DEFAULT '0',
- `FbsDeviceIp_YM` varchar(50) NOT NULL DEFAULT '255.255.255.0',
- `FbsDeviceIp_WG` varchar(50) NOT NULL DEFAULT '127.0.0.1',
- `station_phone` varchar(32) DEFAULT '',
- `station_install` tinyint(1) NOT NULL DEFAULT '0',
- `install_user` varchar(64) DEFAULT '',
- PRIMARY KEY (`num`),
- KEY `index_station_id` (`StationId`),
- KEY `index_battgroup_id` (`BattGroupId`),
- KEY `index_station_name` (`StationName`),
- KEY `index_battgroup_name` (`BattGroupName`)
-) ENGINE=InnoDB AUTO_INCREMENT=10522 DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `tb_battinf`
---
-
-LOCK TABLES `tb_battinf` WRITE;
-/*!40000 ALTER TABLE `tb_battinf` DISABLE KEYS */;
-INSERT INTO `tb_battinf` VALUES (10521,'42070469','','婀栧寳鐪�-姝︽眽甯�-瀹為獙瀹ゆ祴璇曟満鎴�-BTS璁惧','婀栧寳鐪�','姝︽眽甯�','瀹為獙瀹ゆ祴璇曟満鎴�','BTS璁惧',' ',' ',' ',' ',' ','192.168.0.5',910000002,'10.143.207.34','BTS',0,'UXL2N-300',1005054,6,'娴嬭瘯鐢垫睜缁�1',' ',' ',' ',' ',' ',' ',53.6,51.5,5,'0','0',24,300,2,2.5,2400,0,0.05,0,'姹ゆ祬','2012-05-04','2012-06-13',1095,'0',0,'0',15,0,'255.255.255.0','127.0.0.1','',1,'');
-/*!40000 ALTER TABLE `tb_battinf` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Dumping routines for database 'db_battinf'
---
-/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
-
-/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
-/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
-/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
-/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
-/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
-/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
-/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-
--- Dump completed on 2018-12-11 9:57:22
diff --git a/BattMonitor_FBS9100S_DataBaseBackUp/mysql_backup/INSTANT_BACKUP/2018-12-11_10_05_03/db_battinf/tb_battinf.sql b/BattMonitor_FBS9100S_DataBaseBackUp/mysql_backup/INSTANT_BACKUP/2018-12-11_10_05_03/db_battinf/tb_battinf.sql
deleted file mode 100644
index 3b9bff4..0000000
--- a/BattMonitor_FBS9100S_DataBaseBackUp/mysql_backup/INSTANT_BACKUP/2018-12-11_10_05_03/db_battinf/tb_battinf.sql
+++ /dev/null
@@ -1,112 +0,0 @@
--- MySQL dump 10.13 Distrib 5.7.10, for Win64 (x86_64)
---
--- Host: 127.0.0.1 Database: db_battinf
--- ------------------------------------------------------
--- Server version 5.7.10
-
-/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
-/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
-/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
-/*!40101 SET NAMES utf8 */;
-/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
-/*!40103 SET TIME_ZONE='+00:00' */;
-/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
-/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
-/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
-/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
-
---
--- Table structure for table `tb_battinf`
---
-
-DROP TABLE IF EXISTS `tb_battinf`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `tb_battinf` (
- `num` int(11) NOT NULL AUTO_INCREMENT,
- `StationId` varchar(20) NOT NULL DEFAULT '0',
- `StationId_ex` varchar(20) DEFAULT '',
- `StationName` varchar(100) NOT NULL DEFAULT ' ',
- `StationName1` varchar(100) NOT NULL DEFAULT ' ',
- `StationName2` varchar(100) NOT NULL DEFAULT ' ',
- `StationName3` varchar(100) NOT NULL DEFAULT ' ',
- `StationName4` varchar(100) NOT NULL DEFAULT ' ',
- `StationName5` varchar(100) NOT NULL DEFAULT ' ',
- `StationName6` varchar(100) NOT NULL DEFAULT ' ',
- `StationName7` varchar(100) NOT NULL DEFAULT ' ',
- `StationName8` varchar(100) NOT NULL DEFAULT ' ',
- `StationName9` varchar(100) NOT NULL DEFAULT ' ',
- `StationIP` varchar(20) NOT NULL DEFAULT '0',
- `FBSDeviceId` bigint(11) NOT NULL DEFAULT '0',
- `FBSDeviceIp` varchar(50) NOT NULL DEFAULT '192.168.0.88',
- `FBSDeviceName` varchar(100) NOT NULL DEFAULT '0',
- `GroupIndexInFBSDevice` int(11) NOT NULL DEFAULT '0',
- `BattModel` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupId` int(11) NOT NULL DEFAULT '0',
- `BattGroupNum` int(11) NOT NULL DEFAULT '0',
- `BattGroupName` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName1` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName2` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName3` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName4` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName5` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName6` varchar(100) NOT NULL DEFAULT ' ',
- `FloatVolLevel` float NOT NULL DEFAULT '1.12',
- `OfflineVolLevel` float NOT NULL DEFAULT '1.06',
- `BattFloatCurrent` float NOT NULL DEFAULT '0',
- `DeviceId` varchar(20) NOT NULL DEFAULT '0',
- `DeviceName` varchar(100) NOT NULL DEFAULT '0',
- `MonCount` int(11) NOT NULL DEFAULT '0',
- `MonCapStd` float NOT NULL DEFAULT '0',
- `MonVolStd` float NOT NULL DEFAULT '0',
- `MonResStd` float NOT NULL DEFAULT '0',
- `MonSerStd` float NOT NULL DEFAULT '0',
- `MonTmpStd` float NOT NULL DEFAULT '0',
- `MonVolLowToAvg` float NOT NULL DEFAULT '0',
- `MonNum` int(11) NOT NULL DEFAULT '0',
- `BattProducer` varchar(45) NOT NULL DEFAULT '0',
- `BattProductDate` date NOT NULL DEFAULT '2006-07-06',
- `BattInUseDate` date NOT NULL DEFAULT '2006-07-06',
- `BattGuarantDayCount` int(11) NOT NULL DEFAULT '1095',
- `SignalId` varchar(20) NOT NULL DEFAULT '0',
- `CInterFaceId` int(11) NOT NULL DEFAULT '0',
- `SignalName` varchar(50) NOT NULL DEFAULT '0',
- `Load_curr` float NOT NULL DEFAULT '15',
- `disCurrMax` float NOT NULL DEFAULT '0',
- `FbsDeviceIp_YM` varchar(50) NOT NULL DEFAULT '255.255.255.0',
- `FbsDeviceIp_WG` varchar(50) NOT NULL DEFAULT '127.0.0.1',
- `station_phone` varchar(32) DEFAULT '',
- `station_install` tinyint(1) NOT NULL DEFAULT '0',
- `install_user` varchar(64) DEFAULT '',
- PRIMARY KEY (`num`),
- KEY `index_station_id` (`StationId`),
- KEY `index_battgroup_id` (`BattGroupId`),
- KEY `index_station_name` (`StationName`),
- KEY `index_battgroup_name` (`BattGroupName`)
-) ENGINE=InnoDB AUTO_INCREMENT=10522 DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `tb_battinf`
---
-
-LOCK TABLES `tb_battinf` WRITE;
-/*!40000 ALTER TABLE `tb_battinf` DISABLE KEYS */;
-INSERT INTO `tb_battinf` VALUES (10521,'42070469','','婀栧寳鐪�-姝︽眽甯�-瀹為獙瀹ゆ祴璇曟満鎴�-BTS璁惧','婀栧寳鐪�','姝︽眽甯�','瀹為獙瀹ゆ祴璇曟満鎴�','BTS璁惧',' ',' ',' ',' ',' ','192.168.0.5',910000002,'10.143.207.34','BTS',0,'UXL2N-300',1005054,6,'娴嬭瘯鐢垫睜缁�1',' ',' ',' ',' ',' ',' ',53.6,51.5,5,'0','0',24,300,2,2.5,2400,0,0.05,0,'姹ゆ祬','2012-05-04','2012-06-13',1095,'0',0,'0',15,0,'255.255.255.0','127.0.0.1','',1,'');
-/*!40000 ALTER TABLE `tb_battinf` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Dumping routines for database 'db_battinf'
---
-/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
-
-/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
-/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
-/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
-/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
-/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
-/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
-/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-
--- Dump completed on 2018-12-11 10:05:03
diff --git a/BattMonitor_FBS9100S_DataBaseBackUp/mysql_backup/INSTANT_BACKUP/2018-12-11_10_05_12/db_battinf/tb_battinf.sql b/BattMonitor_FBS9100S_DataBaseBackUp/mysql_backup/INSTANT_BACKUP/2018-12-11_10_05_12/db_battinf/tb_battinf.sql
deleted file mode 100644
index 3e3bb93..0000000
--- a/BattMonitor_FBS9100S_DataBaseBackUp/mysql_backup/INSTANT_BACKUP/2018-12-11_10_05_12/db_battinf/tb_battinf.sql
+++ /dev/null
@@ -1,112 +0,0 @@
--- MySQL dump 10.13 Distrib 5.7.10, for Win64 (x86_64)
---
--- Host: 127.0.0.1 Database: db_battinf
--- ------------------------------------------------------
--- Server version 5.7.10
-
-/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
-/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
-/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
-/*!40101 SET NAMES utf8 */;
-/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
-/*!40103 SET TIME_ZONE='+00:00' */;
-/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
-/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
-/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
-/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
-
---
--- Table structure for table `tb_battinf`
---
-
-DROP TABLE IF EXISTS `tb_battinf`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `tb_battinf` (
- `num` int(11) NOT NULL AUTO_INCREMENT,
- `StationId` varchar(20) NOT NULL DEFAULT '0',
- `StationId_ex` varchar(20) DEFAULT '',
- `StationName` varchar(100) NOT NULL DEFAULT ' ',
- `StationName1` varchar(100) NOT NULL DEFAULT ' ',
- `StationName2` varchar(100) NOT NULL DEFAULT ' ',
- `StationName3` varchar(100) NOT NULL DEFAULT ' ',
- `StationName4` varchar(100) NOT NULL DEFAULT ' ',
- `StationName5` varchar(100) NOT NULL DEFAULT ' ',
- `StationName6` varchar(100) NOT NULL DEFAULT ' ',
- `StationName7` varchar(100) NOT NULL DEFAULT ' ',
- `StationName8` varchar(100) NOT NULL DEFAULT ' ',
- `StationName9` varchar(100) NOT NULL DEFAULT ' ',
- `StationIP` varchar(20) NOT NULL DEFAULT '0',
- `FBSDeviceId` bigint(11) NOT NULL DEFAULT '0',
- `FBSDeviceIp` varchar(50) NOT NULL DEFAULT '192.168.0.88',
- `FBSDeviceName` varchar(100) NOT NULL DEFAULT '0',
- `GroupIndexInFBSDevice` int(11) NOT NULL DEFAULT '0',
- `BattModel` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupId` int(11) NOT NULL DEFAULT '0',
- `BattGroupNum` int(11) NOT NULL DEFAULT '0',
- `BattGroupName` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName1` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName2` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName3` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName4` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName5` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName6` varchar(100) NOT NULL DEFAULT ' ',
- `FloatVolLevel` float NOT NULL DEFAULT '1.12',
- `OfflineVolLevel` float NOT NULL DEFAULT '1.06',
- `BattFloatCurrent` float NOT NULL DEFAULT '0',
- `DeviceId` varchar(20) NOT NULL DEFAULT '0',
- `DeviceName` varchar(100) NOT NULL DEFAULT '0',
- `MonCount` int(11) NOT NULL DEFAULT '0',
- `MonCapStd` float NOT NULL DEFAULT '0',
- `MonVolStd` float NOT NULL DEFAULT '0',
- `MonResStd` float NOT NULL DEFAULT '0',
- `MonSerStd` float NOT NULL DEFAULT '0',
- `MonTmpStd` float NOT NULL DEFAULT '0',
- `MonVolLowToAvg` float NOT NULL DEFAULT '0',
- `MonNum` int(11) NOT NULL DEFAULT '0',
- `BattProducer` varchar(45) NOT NULL DEFAULT '0',
- `BattProductDate` date NOT NULL DEFAULT '2006-07-06',
- `BattInUseDate` date NOT NULL DEFAULT '2006-07-06',
- `BattGuarantDayCount` int(11) NOT NULL DEFAULT '1095',
- `SignalId` varchar(20) NOT NULL DEFAULT '0',
- `CInterFaceId` int(11) NOT NULL DEFAULT '0',
- `SignalName` varchar(50) NOT NULL DEFAULT '0',
- `Load_curr` float NOT NULL DEFAULT '15',
- `disCurrMax` float NOT NULL DEFAULT '0',
- `FbsDeviceIp_YM` varchar(50) NOT NULL DEFAULT '255.255.255.0',
- `FbsDeviceIp_WG` varchar(50) NOT NULL DEFAULT '127.0.0.1',
- `station_phone` varchar(32) DEFAULT '',
- `station_install` tinyint(1) NOT NULL DEFAULT '0',
- `install_user` varchar(64) DEFAULT '',
- PRIMARY KEY (`num`),
- KEY `index_station_id` (`StationId`),
- KEY `index_battgroup_id` (`BattGroupId`),
- KEY `index_station_name` (`StationName`),
- KEY `index_battgroup_name` (`BattGroupName`)
-) ENGINE=InnoDB AUTO_INCREMENT=10522 DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `tb_battinf`
---
-
-LOCK TABLES `tb_battinf` WRITE;
-/*!40000 ALTER TABLE `tb_battinf` DISABLE KEYS */;
-INSERT INTO `tb_battinf` VALUES (10521,'42070469','','婀栧寳鐪�-姝︽眽甯�-瀹為獙瀹ゆ祴璇曟満鎴�-BTS璁惧','婀栧寳鐪�','姝︽眽甯�','瀹為獙瀹ゆ祴璇曟満鎴�','BTS璁惧',' ',' ',' ',' ',' ','192.168.0.5',910000002,'10.143.207.34','BTS',0,'UXL2N-300',1005054,6,'娴嬭瘯鐢垫睜缁�1',' ',' ',' ',' ',' ',' ',53.6,51.5,5,'0','0',24,300,2,2.5,2400,0,0.05,0,'姹ゆ祬','2012-05-04','2012-06-13',1095,'0',0,'0',15,0,'255.255.255.0','127.0.0.1','',1,'');
-/*!40000 ALTER TABLE `tb_battinf` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Dumping routines for database 'db_battinf'
---
-/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
-
-/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
-/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
-/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
-/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
-/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
-/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
-/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-
--- Dump completed on 2018-12-11 10:05:12
diff --git a/BattMonitor_FBS9100S_DataBaseBackUp/mysql_backup/INSTANT_BACKUP/2018-12-11_10_06_12/db_battinf/tb_battinf.sql b/BattMonitor_FBS9100S_DataBaseBackUp/mysql_backup/INSTANT_BACKUP/2018-12-11_10_06_12/db_battinf/tb_battinf.sql
deleted file mode 100644
index 3d73c53..0000000
--- a/BattMonitor_FBS9100S_DataBaseBackUp/mysql_backup/INSTANT_BACKUP/2018-12-11_10_06_12/db_battinf/tb_battinf.sql
+++ /dev/null
@@ -1,112 +0,0 @@
--- MySQL dump 10.13 Distrib 5.7.10, for Win64 (x86_64)
---
--- Host: 127.0.0.1 Database: db_battinf
--- ------------------------------------------------------
--- Server version 5.7.10
-
-/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
-/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
-/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
-/*!40101 SET NAMES utf8 */;
-/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
-/*!40103 SET TIME_ZONE='+00:00' */;
-/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
-/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
-/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
-/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
-
---
--- Table structure for table `tb_battinf`
---
-
-DROP TABLE IF EXISTS `tb_battinf`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `tb_battinf` (
- `num` int(11) NOT NULL AUTO_INCREMENT,
- `StationId` varchar(20) NOT NULL DEFAULT '0',
- `StationId_ex` varchar(20) DEFAULT '',
- `StationName` varchar(100) NOT NULL DEFAULT ' ',
- `StationName1` varchar(100) NOT NULL DEFAULT ' ',
- `StationName2` varchar(100) NOT NULL DEFAULT ' ',
- `StationName3` varchar(100) NOT NULL DEFAULT ' ',
- `StationName4` varchar(100) NOT NULL DEFAULT ' ',
- `StationName5` varchar(100) NOT NULL DEFAULT ' ',
- `StationName6` varchar(100) NOT NULL DEFAULT ' ',
- `StationName7` varchar(100) NOT NULL DEFAULT ' ',
- `StationName8` varchar(100) NOT NULL DEFAULT ' ',
- `StationName9` varchar(100) NOT NULL DEFAULT ' ',
- `StationIP` varchar(20) NOT NULL DEFAULT '0',
- `FBSDeviceId` bigint(11) NOT NULL DEFAULT '0',
- `FBSDeviceIp` varchar(50) NOT NULL DEFAULT '192.168.0.88',
- `FBSDeviceName` varchar(100) NOT NULL DEFAULT '0',
- `GroupIndexInFBSDevice` int(11) NOT NULL DEFAULT '0',
- `BattModel` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupId` int(11) NOT NULL DEFAULT '0',
- `BattGroupNum` int(11) NOT NULL DEFAULT '0',
- `BattGroupName` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName1` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName2` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName3` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName4` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName5` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName6` varchar(100) NOT NULL DEFAULT ' ',
- `FloatVolLevel` float NOT NULL DEFAULT '1.12',
- `OfflineVolLevel` float NOT NULL DEFAULT '1.06',
- `BattFloatCurrent` float NOT NULL DEFAULT '0',
- `DeviceId` varchar(20) NOT NULL DEFAULT '0',
- `DeviceName` varchar(100) NOT NULL DEFAULT '0',
- `MonCount` int(11) NOT NULL DEFAULT '0',
- `MonCapStd` float NOT NULL DEFAULT '0',
- `MonVolStd` float NOT NULL DEFAULT '0',
- `MonResStd` float NOT NULL DEFAULT '0',
- `MonSerStd` float NOT NULL DEFAULT '0',
- `MonTmpStd` float NOT NULL DEFAULT '0',
- `MonVolLowToAvg` float NOT NULL DEFAULT '0',
- `MonNum` int(11) NOT NULL DEFAULT '0',
- `BattProducer` varchar(45) NOT NULL DEFAULT '0',
- `BattProductDate` date NOT NULL DEFAULT '2006-07-06',
- `BattInUseDate` date NOT NULL DEFAULT '2006-07-06',
- `BattGuarantDayCount` int(11) NOT NULL DEFAULT '1095',
- `SignalId` varchar(20) NOT NULL DEFAULT '0',
- `CInterFaceId` int(11) NOT NULL DEFAULT '0',
- `SignalName` varchar(50) NOT NULL DEFAULT '0',
- `Load_curr` float NOT NULL DEFAULT '15',
- `disCurrMax` float NOT NULL DEFAULT '0',
- `FbsDeviceIp_YM` varchar(50) NOT NULL DEFAULT '255.255.255.0',
- `FbsDeviceIp_WG` varchar(50) NOT NULL DEFAULT '127.0.0.1',
- `station_phone` varchar(32) DEFAULT '',
- `station_install` tinyint(1) NOT NULL DEFAULT '0',
- `install_user` varchar(64) DEFAULT '',
- PRIMARY KEY (`num`),
- KEY `index_station_id` (`StationId`),
- KEY `index_battgroup_id` (`BattGroupId`),
- KEY `index_station_name` (`StationName`),
- KEY `index_battgroup_name` (`BattGroupName`)
-) ENGINE=InnoDB AUTO_INCREMENT=10522 DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `tb_battinf`
---
-
-LOCK TABLES `tb_battinf` WRITE;
-/*!40000 ALTER TABLE `tb_battinf` DISABLE KEYS */;
-INSERT INTO `tb_battinf` VALUES (10521,'42070469','','婀栧寳鐪�-姝︽眽甯�-瀹為獙瀹ゆ祴璇曟満鎴�-BTS璁惧','婀栧寳鐪�','姝︽眽甯�','瀹為獙瀹ゆ祴璇曟満鎴�','BTS璁惧',' ',' ',' ',' ',' ','192.168.0.5',910000002,'10.143.207.34','BTS',0,'UXL2N-300',1005054,6,'娴嬭瘯鐢垫睜缁�1',' ',' ',' ',' ',' ',' ',53.6,51.5,5,'0','0',24,300,2,2.5,2400,0,0.05,0,'姹ゆ祬','2012-05-04','2012-06-13',1095,'0',0,'0',15,0,'255.255.255.0','127.0.0.1','',1,'');
-/*!40000 ALTER TABLE `tb_battinf` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Dumping routines for database 'db_battinf'
---
-/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
-
-/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
-/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
-/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
-/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
-/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
-/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
-/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-
--- Dump completed on 2018-12-11 10:06:12
diff --git a/BattMonitor_FBS9100S_DataBaseBackUp/mysql_backup/INSTANT_BACKUP/2018-12-11_10_06_28/db_battinf/tb_battinf.sql b/BattMonitor_FBS9100S_DataBaseBackUp/mysql_backup/INSTANT_BACKUP/2018-12-11_10_06_28/db_battinf/tb_battinf.sql
deleted file mode 100644
index 5eb67b3..0000000
--- a/BattMonitor_FBS9100S_DataBaseBackUp/mysql_backup/INSTANT_BACKUP/2018-12-11_10_06_28/db_battinf/tb_battinf.sql
+++ /dev/null
@@ -1,112 +0,0 @@
--- MySQL dump 10.13 Distrib 5.7.10, for Win64 (x86_64)
---
--- Host: 127.0.0.1 Database: db_battinf
--- ------------------------------------------------------
--- Server version 5.7.10
-
-/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
-/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
-/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
-/*!40101 SET NAMES utf8 */;
-/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
-/*!40103 SET TIME_ZONE='+00:00' */;
-/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
-/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
-/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
-/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
-
---
--- Table structure for table `tb_battinf`
---
-
-DROP TABLE IF EXISTS `tb_battinf`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `tb_battinf` (
- `num` int(11) NOT NULL AUTO_INCREMENT,
- `StationId` varchar(20) NOT NULL DEFAULT '0',
- `StationId_ex` varchar(20) DEFAULT '',
- `StationName` varchar(100) NOT NULL DEFAULT ' ',
- `StationName1` varchar(100) NOT NULL DEFAULT ' ',
- `StationName2` varchar(100) NOT NULL DEFAULT ' ',
- `StationName3` varchar(100) NOT NULL DEFAULT ' ',
- `StationName4` varchar(100) NOT NULL DEFAULT ' ',
- `StationName5` varchar(100) NOT NULL DEFAULT ' ',
- `StationName6` varchar(100) NOT NULL DEFAULT ' ',
- `StationName7` varchar(100) NOT NULL DEFAULT ' ',
- `StationName8` varchar(100) NOT NULL DEFAULT ' ',
- `StationName9` varchar(100) NOT NULL DEFAULT ' ',
- `StationIP` varchar(20) NOT NULL DEFAULT '0',
- `FBSDeviceId` bigint(11) NOT NULL DEFAULT '0',
- `FBSDeviceIp` varchar(50) NOT NULL DEFAULT '192.168.0.88',
- `FBSDeviceName` varchar(100) NOT NULL DEFAULT '0',
- `GroupIndexInFBSDevice` int(11) NOT NULL DEFAULT '0',
- `BattModel` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupId` int(11) NOT NULL DEFAULT '0',
- `BattGroupNum` int(11) NOT NULL DEFAULT '0',
- `BattGroupName` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName1` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName2` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName3` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName4` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName5` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName6` varchar(100) NOT NULL DEFAULT ' ',
- `FloatVolLevel` float NOT NULL DEFAULT '1.12',
- `OfflineVolLevel` float NOT NULL DEFAULT '1.06',
- `BattFloatCurrent` float NOT NULL DEFAULT '0',
- `DeviceId` varchar(20) NOT NULL DEFAULT '0',
- `DeviceName` varchar(100) NOT NULL DEFAULT '0',
- `MonCount` int(11) NOT NULL DEFAULT '0',
- `MonCapStd` float NOT NULL DEFAULT '0',
- `MonVolStd` float NOT NULL DEFAULT '0',
- `MonResStd` float NOT NULL DEFAULT '0',
- `MonSerStd` float NOT NULL DEFAULT '0',
- `MonTmpStd` float NOT NULL DEFAULT '0',
- `MonVolLowToAvg` float NOT NULL DEFAULT '0',
- `MonNum` int(11) NOT NULL DEFAULT '0',
- `BattProducer` varchar(45) NOT NULL DEFAULT '0',
- `BattProductDate` date NOT NULL DEFAULT '2006-07-06',
- `BattInUseDate` date NOT NULL DEFAULT '2006-07-06',
- `BattGuarantDayCount` int(11) NOT NULL DEFAULT '1095',
- `SignalId` varchar(20) NOT NULL DEFAULT '0',
- `CInterFaceId` int(11) NOT NULL DEFAULT '0',
- `SignalName` varchar(50) NOT NULL DEFAULT '0',
- `Load_curr` float NOT NULL DEFAULT '15',
- `disCurrMax` float NOT NULL DEFAULT '0',
- `FbsDeviceIp_YM` varchar(50) NOT NULL DEFAULT '255.255.255.0',
- `FbsDeviceIp_WG` varchar(50) NOT NULL DEFAULT '127.0.0.1',
- `station_phone` varchar(32) DEFAULT '',
- `station_install` tinyint(1) NOT NULL DEFAULT '0',
- `install_user` varchar(64) DEFAULT '',
- PRIMARY KEY (`num`),
- KEY `index_station_id` (`StationId`),
- KEY `index_battgroup_id` (`BattGroupId`),
- KEY `index_station_name` (`StationName`),
- KEY `index_battgroup_name` (`BattGroupName`)
-) ENGINE=InnoDB AUTO_INCREMENT=10522 DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `tb_battinf`
---
-
-LOCK TABLES `tb_battinf` WRITE;
-/*!40000 ALTER TABLE `tb_battinf` DISABLE KEYS */;
-INSERT INTO `tb_battinf` VALUES (10521,'42070469','','婀栧寳鐪�-姝︽眽甯�-瀹為獙瀹ゆ祴璇曟満鎴�-BTS璁惧','婀栧寳鐪�','姝︽眽甯�','瀹為獙瀹ゆ祴璇曟満鎴�','BTS璁惧',' ',' ',' ',' ',' ','192.168.0.5',910000002,'10.143.207.34','BTS',0,'UXL2N-300',1005054,6,'娴嬭瘯鐢垫睜缁�1',' ',' ',' ',' ',' ',' ',53.6,51.5,5,'0','0',24,300,2,2.5,2400,0,0.05,0,'姹ゆ祬','2012-05-04','2012-06-13',1095,'0',0,'0',15,0,'255.255.255.0','127.0.0.1','',1,'');
-/*!40000 ALTER TABLE `tb_battinf` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Dumping routines for database 'db_battinf'
---
-/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
-
-/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
-/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
-/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
-/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
-/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
-/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
-/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-
--- Dump completed on 2018-12-11 10:06:28
diff --git a/BattMonitor_FBS9100S_DataBaseBackUp/mysql_backup/INSTANT_BACKUP/2018-12-11_10_06_45/db_battinf/tb_battinf.sql b/BattMonitor_FBS9100S_DataBaseBackUp/mysql_backup/INSTANT_BACKUP/2018-12-11_10_06_45/db_battinf/tb_battinf.sql
deleted file mode 100644
index d349cc2..0000000
--- a/BattMonitor_FBS9100S_DataBaseBackUp/mysql_backup/INSTANT_BACKUP/2018-12-11_10_06_45/db_battinf/tb_battinf.sql
+++ /dev/null
@@ -1,112 +0,0 @@
--- MySQL dump 10.13 Distrib 5.7.10, for Win64 (x86_64)
---
--- Host: 127.0.0.1 Database: db_battinf
--- ------------------------------------------------------
--- Server version 5.7.10
-
-/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
-/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
-/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
-/*!40101 SET NAMES utf8 */;
-/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
-/*!40103 SET TIME_ZONE='+00:00' */;
-/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
-/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
-/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
-/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
-
---
--- Table structure for table `tb_battinf`
---
-
-DROP TABLE IF EXISTS `tb_battinf`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `tb_battinf` (
- `num` int(11) NOT NULL AUTO_INCREMENT,
- `StationId` varchar(20) NOT NULL DEFAULT '0',
- `StationId_ex` varchar(20) DEFAULT '',
- `StationName` varchar(100) NOT NULL DEFAULT ' ',
- `StationName1` varchar(100) NOT NULL DEFAULT ' ',
- `StationName2` varchar(100) NOT NULL DEFAULT ' ',
- `StationName3` varchar(100) NOT NULL DEFAULT ' ',
- `StationName4` varchar(100) NOT NULL DEFAULT ' ',
- `StationName5` varchar(100) NOT NULL DEFAULT ' ',
- `StationName6` varchar(100) NOT NULL DEFAULT ' ',
- `StationName7` varchar(100) NOT NULL DEFAULT ' ',
- `StationName8` varchar(100) NOT NULL DEFAULT ' ',
- `StationName9` varchar(100) NOT NULL DEFAULT ' ',
- `StationIP` varchar(20) NOT NULL DEFAULT '0',
- `FBSDeviceId` bigint(11) NOT NULL DEFAULT '0',
- `FBSDeviceIp` varchar(50) NOT NULL DEFAULT '192.168.0.88',
- `FBSDeviceName` varchar(100) NOT NULL DEFAULT '0',
- `GroupIndexInFBSDevice` int(11) NOT NULL DEFAULT '0',
- `BattModel` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupId` int(11) NOT NULL DEFAULT '0',
- `BattGroupNum` int(11) NOT NULL DEFAULT '0',
- `BattGroupName` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName1` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName2` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName3` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName4` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName5` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName6` varchar(100) NOT NULL DEFAULT ' ',
- `FloatVolLevel` float NOT NULL DEFAULT '1.12',
- `OfflineVolLevel` float NOT NULL DEFAULT '1.06',
- `BattFloatCurrent` float NOT NULL DEFAULT '0',
- `DeviceId` varchar(20) NOT NULL DEFAULT '0',
- `DeviceName` varchar(100) NOT NULL DEFAULT '0',
- `MonCount` int(11) NOT NULL DEFAULT '0',
- `MonCapStd` float NOT NULL DEFAULT '0',
- `MonVolStd` float NOT NULL DEFAULT '0',
- `MonResStd` float NOT NULL DEFAULT '0',
- `MonSerStd` float NOT NULL DEFAULT '0',
- `MonTmpStd` float NOT NULL DEFAULT '0',
- `MonVolLowToAvg` float NOT NULL DEFAULT '0',
- `MonNum` int(11) NOT NULL DEFAULT '0',
- `BattProducer` varchar(45) NOT NULL DEFAULT '0',
- `BattProductDate` date NOT NULL DEFAULT '2006-07-06',
- `BattInUseDate` date NOT NULL DEFAULT '2006-07-06',
- `BattGuarantDayCount` int(11) NOT NULL DEFAULT '1095',
- `SignalId` varchar(20) NOT NULL DEFAULT '0',
- `CInterFaceId` int(11) NOT NULL DEFAULT '0',
- `SignalName` varchar(50) NOT NULL DEFAULT '0',
- `Load_curr` float NOT NULL DEFAULT '15',
- `disCurrMax` float NOT NULL DEFAULT '0',
- `FbsDeviceIp_YM` varchar(50) NOT NULL DEFAULT '255.255.255.0',
- `FbsDeviceIp_WG` varchar(50) NOT NULL DEFAULT '127.0.0.1',
- `station_phone` varchar(32) DEFAULT '',
- `station_install` tinyint(1) NOT NULL DEFAULT '0',
- `install_user` varchar(64) DEFAULT '',
- PRIMARY KEY (`num`),
- KEY `index_station_id` (`StationId`),
- KEY `index_battgroup_id` (`BattGroupId`),
- KEY `index_station_name` (`StationName`),
- KEY `index_battgroup_name` (`BattGroupName`)
-) ENGINE=InnoDB AUTO_INCREMENT=10522 DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `tb_battinf`
---
-
-LOCK TABLES `tb_battinf` WRITE;
-/*!40000 ALTER TABLE `tb_battinf` DISABLE KEYS */;
-INSERT INTO `tb_battinf` VALUES (10521,'42070469','','婀栧寳鐪�-姝︽眽甯�-瀹為獙瀹ゆ祴璇曟満鎴�-BTS璁惧','婀栧寳鐪�','姝︽眽甯�','瀹為獙瀹ゆ祴璇曟満鎴�','BTS璁惧',' ',' ',' ',' ',' ','192.168.0.5',910000002,'10.143.207.34','BTS',0,'UXL2N-300',1005054,6,'娴嬭瘯鐢垫睜缁�1',' ',' ',' ',' ',' ',' ',53.6,51.5,5,'0','0',24,300,2,2.5,2400,0,0.05,0,'姹ゆ祬','2012-05-04','2012-06-13',1095,'0',0,'0',15,0,'255.255.255.0','127.0.0.1','',1,'');
-/*!40000 ALTER TABLE `tb_battinf` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Dumping routines for database 'db_battinf'
---
-/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
-
-/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
-/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
-/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
-/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
-/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
-/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
-/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-
--- Dump completed on 2018-12-11 10:06:45
diff --git a/BattMonitor_FBS9100S_DataBaseBackUp/mysql_backup/INSTANT_BACKUP/2018-12-11_10_07_02/db_battinf/tb_battinf.sql b/BattMonitor_FBS9100S_DataBaseBackUp/mysql_backup/INSTANT_BACKUP/2018-12-11_10_07_02/db_battinf/tb_battinf.sql
deleted file mode 100644
index a0cfcda..0000000
--- a/BattMonitor_FBS9100S_DataBaseBackUp/mysql_backup/INSTANT_BACKUP/2018-12-11_10_07_02/db_battinf/tb_battinf.sql
+++ /dev/null
@@ -1,112 +0,0 @@
--- MySQL dump 10.13 Distrib 5.7.10, for Win64 (x86_64)
---
--- Host: 127.0.0.1 Database: db_battinf
--- ------------------------------------------------------
--- Server version 5.7.10
-
-/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
-/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
-/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
-/*!40101 SET NAMES utf8 */;
-/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
-/*!40103 SET TIME_ZONE='+00:00' */;
-/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
-/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
-/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
-/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
-
---
--- Table structure for table `tb_battinf`
---
-
-DROP TABLE IF EXISTS `tb_battinf`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `tb_battinf` (
- `num` int(11) NOT NULL AUTO_INCREMENT,
- `StationId` varchar(20) NOT NULL DEFAULT '0',
- `StationId_ex` varchar(20) DEFAULT '',
- `StationName` varchar(100) NOT NULL DEFAULT ' ',
- `StationName1` varchar(100) NOT NULL DEFAULT ' ',
- `StationName2` varchar(100) NOT NULL DEFAULT ' ',
- `StationName3` varchar(100) NOT NULL DEFAULT ' ',
- `StationName4` varchar(100) NOT NULL DEFAULT ' ',
- `StationName5` varchar(100) NOT NULL DEFAULT ' ',
- `StationName6` varchar(100) NOT NULL DEFAULT ' ',
- `StationName7` varchar(100) NOT NULL DEFAULT ' ',
- `StationName8` varchar(100) NOT NULL DEFAULT ' ',
- `StationName9` varchar(100) NOT NULL DEFAULT ' ',
- `StationIP` varchar(20) NOT NULL DEFAULT '0',
- `FBSDeviceId` bigint(11) NOT NULL DEFAULT '0',
- `FBSDeviceIp` varchar(50) NOT NULL DEFAULT '192.168.0.88',
- `FBSDeviceName` varchar(100) NOT NULL DEFAULT '0',
- `GroupIndexInFBSDevice` int(11) NOT NULL DEFAULT '0',
- `BattModel` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupId` int(11) NOT NULL DEFAULT '0',
- `BattGroupNum` int(11) NOT NULL DEFAULT '0',
- `BattGroupName` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName1` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName2` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName3` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName4` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName5` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName6` varchar(100) NOT NULL DEFAULT ' ',
- `FloatVolLevel` float NOT NULL DEFAULT '1.12',
- `OfflineVolLevel` float NOT NULL DEFAULT '1.06',
- `BattFloatCurrent` float NOT NULL DEFAULT '0',
- `DeviceId` varchar(20) NOT NULL DEFAULT '0',
- `DeviceName` varchar(100) NOT NULL DEFAULT '0',
- `MonCount` int(11) NOT NULL DEFAULT '0',
- `MonCapStd` float NOT NULL DEFAULT '0',
- `MonVolStd` float NOT NULL DEFAULT '0',
- `MonResStd` float NOT NULL DEFAULT '0',
- `MonSerStd` float NOT NULL DEFAULT '0',
- `MonTmpStd` float NOT NULL DEFAULT '0',
- `MonVolLowToAvg` float NOT NULL DEFAULT '0',
- `MonNum` int(11) NOT NULL DEFAULT '0',
- `BattProducer` varchar(45) NOT NULL DEFAULT '0',
- `BattProductDate` date NOT NULL DEFAULT '2006-07-06',
- `BattInUseDate` date NOT NULL DEFAULT '2006-07-06',
- `BattGuarantDayCount` int(11) NOT NULL DEFAULT '1095',
- `SignalId` varchar(20) NOT NULL DEFAULT '0',
- `CInterFaceId` int(11) NOT NULL DEFAULT '0',
- `SignalName` varchar(50) NOT NULL DEFAULT '0',
- `Load_curr` float NOT NULL DEFAULT '15',
- `disCurrMax` float NOT NULL DEFAULT '0',
- `FbsDeviceIp_YM` varchar(50) NOT NULL DEFAULT '255.255.255.0',
- `FbsDeviceIp_WG` varchar(50) NOT NULL DEFAULT '127.0.0.1',
- `station_phone` varchar(32) DEFAULT '',
- `station_install` tinyint(1) NOT NULL DEFAULT '0',
- `install_user` varchar(64) DEFAULT '',
- PRIMARY KEY (`num`),
- KEY `index_station_id` (`StationId`),
- KEY `index_battgroup_id` (`BattGroupId`),
- KEY `index_station_name` (`StationName`),
- KEY `index_battgroup_name` (`BattGroupName`)
-) ENGINE=InnoDB AUTO_INCREMENT=10522 DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `tb_battinf`
---
-
-LOCK TABLES `tb_battinf` WRITE;
-/*!40000 ALTER TABLE `tb_battinf` DISABLE KEYS */;
-INSERT INTO `tb_battinf` VALUES (10521,'42070469','','婀栧寳鐪�-姝︽眽甯�-瀹為獙瀹ゆ祴璇曟満鎴�-BTS璁惧','婀栧寳鐪�','姝︽眽甯�','瀹為獙瀹ゆ祴璇曟満鎴�','BTS璁惧',' ',' ',' ',' ',' ','192.168.0.5',910000002,'10.143.207.34','BTS',0,'UXL2N-300',1005054,6,'娴嬭瘯鐢垫睜缁�1',' ',' ',' ',' ',' ',' ',53.6,51.5,5,'0','0',24,300,2,2.5,2400,0,0.05,0,'姹ゆ祬','2012-05-04','2012-06-13',1095,'0',0,'0',15,0,'255.255.255.0','127.0.0.1','',1,'');
-/*!40000 ALTER TABLE `tb_battinf` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Dumping routines for database 'db_battinf'
---
-/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
-
-/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
-/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
-/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
-/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
-/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
-/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
-/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-
--- Dump completed on 2018-12-11 10:07:02
diff --git a/BattMonitor_FBS9100S_DataBaseBackUp/mysql_backup/INSTANT_BACKUP/2018-12-11_10_07_09/db_battinf/tb_battinf.sql b/BattMonitor_FBS9100S_DataBaseBackUp/mysql_backup/INSTANT_BACKUP/2018-12-11_10_07_09/db_battinf/tb_battinf.sql
deleted file mode 100644
index 21409b5..0000000
--- a/BattMonitor_FBS9100S_DataBaseBackUp/mysql_backup/INSTANT_BACKUP/2018-12-11_10_07_09/db_battinf/tb_battinf.sql
+++ /dev/null
@@ -1,112 +0,0 @@
--- MySQL dump 10.13 Distrib 5.7.10, for Win64 (x86_64)
---
--- Host: 127.0.0.1 Database: db_battinf
--- ------------------------------------------------------
--- Server version 5.7.10
-
-/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
-/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
-/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
-/*!40101 SET NAMES utf8 */;
-/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
-/*!40103 SET TIME_ZONE='+00:00' */;
-/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
-/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
-/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
-/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
-
---
--- Table structure for table `tb_battinf`
---
-
-DROP TABLE IF EXISTS `tb_battinf`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `tb_battinf` (
- `num` int(11) NOT NULL AUTO_INCREMENT,
- `StationId` varchar(20) NOT NULL DEFAULT '0',
- `StationId_ex` varchar(20) DEFAULT '',
- `StationName` varchar(100) NOT NULL DEFAULT ' ',
- `StationName1` varchar(100) NOT NULL DEFAULT ' ',
- `StationName2` varchar(100) NOT NULL DEFAULT ' ',
- `StationName3` varchar(100) NOT NULL DEFAULT ' ',
- `StationName4` varchar(100) NOT NULL DEFAULT ' ',
- `StationName5` varchar(100) NOT NULL DEFAULT ' ',
- `StationName6` varchar(100) NOT NULL DEFAULT ' ',
- `StationName7` varchar(100) NOT NULL DEFAULT ' ',
- `StationName8` varchar(100) NOT NULL DEFAULT ' ',
- `StationName9` varchar(100) NOT NULL DEFAULT ' ',
- `StationIP` varchar(20) NOT NULL DEFAULT '0',
- `FBSDeviceId` bigint(11) NOT NULL DEFAULT '0',
- `FBSDeviceIp` varchar(50) NOT NULL DEFAULT '192.168.0.88',
- `FBSDeviceName` varchar(100) NOT NULL DEFAULT '0',
- `GroupIndexInFBSDevice` int(11) NOT NULL DEFAULT '0',
- `BattModel` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupId` int(11) NOT NULL DEFAULT '0',
- `BattGroupNum` int(11) NOT NULL DEFAULT '0',
- `BattGroupName` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName1` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName2` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName3` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName4` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName5` varchar(100) NOT NULL DEFAULT ' ',
- `BattGroupName6` varchar(100) NOT NULL DEFAULT ' ',
- `FloatVolLevel` float NOT NULL DEFAULT '1.12',
- `OfflineVolLevel` float NOT NULL DEFAULT '1.06',
- `BattFloatCurrent` float NOT NULL DEFAULT '0',
- `DeviceId` varchar(20) NOT NULL DEFAULT '0',
- `DeviceName` varchar(100) NOT NULL DEFAULT '0',
- `MonCount` int(11) NOT NULL DEFAULT '0',
- `MonCapStd` float NOT NULL DEFAULT '0',
- `MonVolStd` float NOT NULL DEFAULT '0',
- `MonResStd` float NOT NULL DEFAULT '0',
- `MonSerStd` float NOT NULL DEFAULT '0',
- `MonTmpStd` float NOT NULL DEFAULT '0',
- `MonVolLowToAvg` float NOT NULL DEFAULT '0',
- `MonNum` int(11) NOT NULL DEFAULT '0',
- `BattProducer` varchar(45) NOT NULL DEFAULT '0',
- `BattProductDate` date NOT NULL DEFAULT '2006-07-06',
- `BattInUseDate` date NOT NULL DEFAULT '2006-07-06',
- `BattGuarantDayCount` int(11) NOT NULL DEFAULT '1095',
- `SignalId` varchar(20) NOT NULL DEFAULT '0',
- `CInterFaceId` int(11) NOT NULL DEFAULT '0',
- `SignalName` varchar(50) NOT NULL DEFAULT '0',
- `Load_curr` float NOT NULL DEFAULT '15',
- `disCurrMax` float NOT NULL DEFAULT '0',
- `FbsDeviceIp_YM` varchar(50) NOT NULL DEFAULT '255.255.255.0',
- `FbsDeviceIp_WG` varchar(50) NOT NULL DEFAULT '127.0.0.1',
- `station_phone` varchar(32) DEFAULT '',
- `station_install` tinyint(1) NOT NULL DEFAULT '0',
- `install_user` varchar(64) DEFAULT '',
- PRIMARY KEY (`num`),
- KEY `index_station_id` (`StationId`),
- KEY `index_battgroup_id` (`BattGroupId`),
- KEY `index_station_name` (`StationName`),
- KEY `index_battgroup_name` (`BattGroupName`)
-) ENGINE=InnoDB AUTO_INCREMENT=10522 DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `tb_battinf`
---
-
-LOCK TABLES `tb_battinf` WRITE;
-/*!40000 ALTER TABLE `tb_battinf` DISABLE KEYS */;
-INSERT INTO `tb_battinf` VALUES (10521,'42070469','','婀栧寳鐪�-姝︽眽甯�-瀹為獙瀹ゆ祴璇曟満鎴�-BTS璁惧','婀栧寳鐪�','姝︽眽甯�','瀹為獙瀹ゆ祴璇曟満鎴�','BTS璁惧',' ',' ',' ',' ',' ','192.168.0.5',910000002,'10.143.207.34','BTS',0,'UXL2N-300',1005054,6,'娴嬭瘯鐢垫睜缁�1',' ',' ',' ',' ',' ',' ',53.6,51.5,5,'0','0',24,300,2,2.5,2400,0,0.05,0,'姹ゆ祬','2012-05-04','2012-06-13',1095,'0',0,'0',15,0,'255.255.255.0','127.0.0.1','',1,'');
-/*!40000 ALTER TABLE `tb_battinf` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Dumping routines for database 'db_battinf'
---
-/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
-
-/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
-/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
-/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
-/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
-/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
-/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
-/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-
--- Dump completed on 2018-12-11 10:07:09
diff --git a/BattMonitor_FBS9100S_DataBaseBackUp/src/com/backup/DataBaseBackUpThread.java b/BattMonitor_FBS9100S_DataBaseBackUp/src/com/backup/DataBaseBackUpThread.java
index d50b838..cec058d 100644
--- a/BattMonitor_FBS9100S_DataBaseBackUp/src/com/backup/DataBaseBackUpThread.java
+++ b/BattMonitor_FBS9100S_DataBaseBackUp/src/com/backup/DataBaseBackUpThread.java
@@ -10,6 +10,7 @@
import java.util.regex.Pattern;
import com.base.Com;
+import com.config.AppConfig;
import com.sql.MysqlConnPool;
import main.main_FBS9100S_DataBaseBackUp;
@@ -24,9 +25,12 @@
private MysqlConnPool pool;
private String savePath = System.getProperty("user.dir")+ File.separator+"mysql_backup"; //备份数据库的根目录
private MyRunTime runtime = null;
+ private AppConfig appcfg;
- public DataBaseBackUpThread(MysqlConnPool conn_pool){
+ public DataBaseBackUpThread(MysqlConnPool conn_pool,AppConfig appcfg){
this.pool = conn_pool;
+ this.appcfg = appcfg;
+
this.runtime = new MyRunTime(this.pool);
DataBaseBackUpThread_SQL.createBackupTable(pool); //初始化数据库表
@@ -55,7 +59,7 @@
//System.out.println();
//12点59分开始备份所有的数据库
- if(countTimeLong(nowTime, normTime)<30 && countTimeLong(lastRecodTime, nowTime) >= 7*24*60*60) {
+ if(countTimeLong(nowTime, normTime)<30 || countTimeLong(lastRecodTime, nowTime) >= 7*24*60*60) {
System.out.println("开始备份所有的数据库"+Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
this.list = DataBaseBackUpThread_SQL.searchAllDataBaseAndTable(pool);
String path = savePath+File.separator+REGULAR_BACKUP_PATHNAME;
@@ -78,7 +82,7 @@
File zipFile = zipUtil.createZip(zipName, new File(path)); //压缩数据库文件
- HzipSocket SocketClient = new HzipSocket();
+ HzipSocket SocketClient = new HzipSocket(appcfg);
SocketClient.init(zipName); //发送数据库备份文件到远程服务器
System.out.println("远程备份数据库完成" + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
if(zipFile.exists() && zipFile.length() > 1*1024 && new File(path).exists()) {
diff --git a/BattMonitor_FBS9100S_DataBaseBackUp/src/com/backup/HzipSocket.java b/BattMonitor_FBS9100S_DataBaseBackUp/src/com/backup/HzipSocket.java
index 7e41409..677ad62 100644
--- a/BattMonitor_FBS9100S_DataBaseBackUp/src/com/backup/HzipSocket.java
+++ b/BattMonitor_FBS9100S_DataBaseBackUp/src/com/backup/HzipSocket.java
@@ -5,26 +5,45 @@
import java.io.IOException;
import java.io.OutputStream;
import java.net.Socket;
+import java.util.Date;
import java.util.zip.ZipEntry;
import java.util.zip.ZipOutputStream;
+import com.base.Com;
+import com.config.AppConfig;
+
public class HzipSocket{
- public static String targetip = "118.89.139.230"; //目标ip地址
+ //public static String targetip = "118.89.139.230"; //目标ip地址
//public static String targetip = "192.168.7.123"; //目标ip地址
public static int targetport = 10100; //目标端口号
+ private AppConfig cfg;
+
+ public HzipSocket(AppConfig cfg) {
+ this.cfg = cfg;
+ //System.err.println(cfg.getSourceSQLServerIp()+"########");
+ }
public void init(String filepath) {
+ Socket s = null;
try {
- Socket s = new Socket(targetip,10100);
+ s = new Socket(cfg.getSourceSQLServerIp(),10100);
//要发送出去的文件夹.请注意在不同操作系统上,表示方法可能不一样。
File file =new File(filepath);
OutputStream os=s.getOutputStream();
ZipOutputStream gout=new ZipOutputStream(os);
byte[] b=new byte[1024];
zipEntry(file, gout,b);
- s.close();
} catch (IOException e) {
e.printStackTrace();
+ System.out.println(cfg.getSourceSQLServerIp()+"远程备份数据库失败"+Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
+ } finally {
+ if(null != s) {
+ try {
+ s.close();
+ } catch (IOException e) {
+ e.printStackTrace();
+ }
+ }
}
}
@@ -83,7 +102,8 @@
public static void main(String[] args) {
- HzipSocket h = new HzipSocket();
+ AppConfig cfg = new AppConfig();
+ HzipSocket h = new HzipSocket(cfg);
h.init("d:/temp");
}
}
diff --git a/BattMonitor_FBS9100S_DataBaseBackUp/src/com/backup/MyRunTime.java b/BattMonitor_FBS9100S_DataBaseBackUp/src/com/backup/MyRunTime.java
index ee53074..024e2f2 100644
--- a/BattMonitor_FBS9100S_DataBaseBackUp/src/com/backup/MyRunTime.java
+++ b/BattMonitor_FBS9100S_DataBaseBackUp/src/com/backup/MyRunTime.java
@@ -43,7 +43,7 @@
}else{
//鏍规嵁涓荤▼搴忓湪娉ㄥ唽琛ㄤ腑鐨勫弬鏁拌幏鍙杕ysql鐨勫畨瑁呯洰褰�
dbpath = getMySQLPathFromReg();
- //System.out.println(dbpath);
+ System.out.println(dbpath);
if(dbpath != null && dbpath.length()>0){
file = new File(dbpath);
if(file.exists()){
diff --git a/BattMonitor_FBS9100S_DataBaseBackUp/src/com/version_inf/version_inf.txt b/BattMonitor_FBS9100S_DataBaseBackUp/src/com/version_inf/version_inf.txt
index ae26054..25a83d6 100644
--- a/BattMonitor_FBS9100S_DataBaseBackUp/src/com/version_inf/version_inf.txt
+++ b/BattMonitor_FBS9100S_DataBaseBackUp/src/com/version_inf/version_inf.txt
@@ -107,5 +107,7 @@
edit at date 2017-05-11 lijun
1.将config.xml文件中的mysql_conn_count_max 的值由300改为3000 --设置数据库最大链接数
-
-
\ No newline at end of file
+
+说明：该备份程序依赖于主程序或者安装目录不设置中文目录;远程备份端口为10100
+V1.201 2020-11-20
+ config.xml文件中的source_sqlserver_ip对应远程数据库备份主机的ip
\ No newline at end of file
diff --git a/BattMonitor_FBS9100S_DataBaseBackUp/src/main/main_FBS9100S_DataBaseBackUp.java b/BattMonitor_FBS9100S_DataBaseBackUp/src/main/main_FBS9100S_DataBaseBackUp.java
index b764479..7a61c4c 100644
--- a/BattMonitor_FBS9100S_DataBaseBackUp/src/main/main_FBS9100S_DataBaseBackUp.java
+++ b/BattMonitor_FBS9100S_DataBaseBackUp/src/main/main_FBS9100S_DataBaseBackUp.java
@@ -22,7 +22,7 @@
/**************************************************************************/
/**************************************************************************/
public final static boolean app_debug = false;
- public final static float m_VersionNum = (float) 1.101;
+ public final static float m_VersionNum = (float) 1.201;
public final static String m_Version = "Welcome To Use FBS9100S_DataBaseBackUp V" + m_VersionNum + " RC_20170505";
/**************************************************************************/
/**************************************************************************/
@@ -119,7 +119,7 @@
/*********************************************************************************/
/*********************************************************************************/
//启动数据库备份的线程
- DataBaseBackUpThread thread = new DataBaseBackUpThread(GB_MysqlConnPool);
+ DataBaseBackUpThread thread = new DataBaseBackUpThread(GB_MysqlConnPool,m_AppConfig);
thread.start();
}
--
Gitblit v1.9.1