CN103870363A - Database data remote backup method - Google Patents
Database data remote backup method Download PDFInfo
- Publication number
- CN103870363A CN103870363A CN201410120094.6A CN201410120094A CN103870363A CN 103870363 A CN103870363 A CN 103870363A CN 201410120094 A CN201410120094 A CN 201410120094A CN 103870363 A CN103870363 A CN 103870363A
- Authority
- CN
- China
- Prior art keywords
- backup
- database
- control end
- data
- master control
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a database data remote backup method. A controlled end with a database and a master control end used for data backup are included. A Client / Server mode is adopted for the controlled end and the master control end, and the controlled end is in TCP connection with the master control end through a Socket; the master control end has access to the database of the controlled end according to time periods set through a backup scheduled task, and backup is carried out on designated areas in the database; data are transmitted between the controlled end and the master control end by means of an FTP, and MD5 code verification is conducted after backup is completed; the master control end records the executive condition of the backup scheduled task. Backup periods are divided according to significance of the data, the backup scheduled task is made, the master control end has access to the controlled end automatically to copy the base of the database and carry out backup on the base of the database of the controlled end according to the backup scheduled task, MD5 verification is conducted on the data, accordingly integrity and consistency of the data are guaranteed, workloads of staff are relieved and work efficiency is improved.
Description
Technical field
The present invention relates to the communications field, be specifically related to a kind of database data remote backup method.
Background technology
The information management of State Grid Corporation of China and subordinate subsidiary company thereof, every year, monthly even all can produce mass data every day, comprise operation system data, administrative instrument, financial statement, Audit Report, ideological and political work achievement etc., wherein many data relate to important information, once lose, will suffer heavy losses; If can not in time data be backed up, once system or hard disk corruptions, consequence is hardly imaginable.What data backup at present adopted is portable hard drive copy, according to system importance, backup cycle is divided, there is every day, weekly, monthly, back up even weekly 3 inferiorly, backup instances is numerous and diverse, and adopts the backup of order line, complex operation, easily make mistakes, and need to drop into a large amount of manpowers and time, inefficiency.
Summary of the invention
The technical problem to be solved in the present invention is to provide a kind of database data remote backup method, can solve and instantly adopt portable hard drive copies data database data, complex operation, easily makes mistakes, and need to drop into a large amount of manpowers and time, cause ineffective problem.
The present invention is achieved through the following technical solutions:
A kind of database data remote backup method, comprises the controlled terminal of building database, and for the main control end of Backup Data, described controlled terminal adopts Client/Server pattern with main control end, sets up TCP connection by Socket; Described main control end is accessed the database of controlled terminal according to the time cycle of back-up plan task setting, and the region of specifying in database is backed up; Between described controlled terminal and main control end, adopt ftp file transfer protocol transmission data, and after backup completes, carry out MD5 code check; Described main control end records the implementation status of back-up plan task.
Described controlled terminal is server.
Described main control end is computing machine.
The present invention's advantage is compared with prior art:
One, divide backup cycle according to the importance of data, formulate back-up plan task, main control end copies backup according to back-up plan task automatic access controlled terminal to its database data, and data are carried out to MD5 verification, to guarantee data integrity, consistance, the workload that has reduced staff, has improved work efficiency;
Two, main control end records the implementation status of back-up plan task, is convenient to later stage inquiry and processes.
Embodiment
A kind of database data remote backup method, comprises the server of building database, and for the computing machine of Backup Data, described server adopts Client/Server pattern with computing machine, sets up TCP connection by Socket; Described computing machine is according to the database of the time cycle access services device of back-up plan task setting, and the region of specifying in database is backed up; Between described server and computing machine, adopt ftp file transfer protocol transmission data, and after backup completes, carry out MD5 code check; The implementation status of described computer recording back-up plan task.
Claims (3)
1. a database data remote backup method, comprises the controlled terminal of building database, and for the main control end of Backup Data, it is characterized in that: described controlled terminal and main control end adopt Client/Server pattern, sets up TCP connect by Socket; Described main control end is accessed the database of controlled terminal according to the time cycle of back-up plan task setting, and the region of specifying in database is backed up; Between described controlled terminal and main control end, adopt ftp file transfer protocol transmission data, and after backup completes, carry out MD5 code check; Described main control end records the implementation status of back-up plan task.
2. a kind of database data remote backup method as claimed in claim 1, is characterized in that: described controlled terminal is server.
3. a kind of database data remote backup method as claimed in claim 1, is characterized in that: described main control end is computing machine.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410120094.6A CN103870363A (en) | 2014-03-28 | 2014-03-28 | Database data remote backup method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410120094.6A CN103870363A (en) | 2014-03-28 | 2014-03-28 | Database data remote backup method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103870363A true CN103870363A (en) | 2014-06-18 |
Family
ID=50908922
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410120094.6A Pending CN103870363A (en) | 2014-03-28 | 2014-03-28 | Database data remote backup method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103870363A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104077403A (en) * | 2014-07-04 | 2014-10-01 | 用友软件股份有限公司 | Alcedo database scheduled task processing method and processing device |
| CN104539690A (en) * | 2014-12-24 | 2015-04-22 | 大连理工大学 | Server remote data synchronizing method based on feedback mechanism and MD5 code detection |
| CN107463464A (en) * | 2017-07-20 | 2017-12-12 | 深圳互联先锋科技有限公司 | The method and device of automatically backup data file |
| CN107463465A (en) * | 2017-07-20 | 2017-12-12 | 深圳互联先锋科技有限公司 | The method and device of remote backup database |
| CN108628706A (en) * | 2018-05-02 | 2018-10-09 | 北京新桥信通科技股份有限公司 | Method, apparatus, system and the storage medium of data backup |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1873622A (en) * | 2006-04-20 | 2006-12-06 | 北京艾德斯科技有限公司 | Method and equipment for backing up, replicating and recovering data under environment |
| US20070179999A1 (en) * | 2006-01-27 | 2007-08-02 | Hitachi, Ltd. | Backup system, file server and backup method |
| CN102236588A (en) * | 2010-04-23 | 2011-11-09 | 阿里巴巴集团控股有限公司 | Remote data backup method, equipment and system |
| CN102394923A (en) * | 2011-10-27 | 2012-03-28 | 周诗琦 | Cloud system platform based on n*n display structure |
-
2014
- 2014-03-28 CN CN201410120094.6A patent/CN103870363A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070179999A1 (en) * | 2006-01-27 | 2007-08-02 | Hitachi, Ltd. | Backup system, file server and backup method |
| CN1873622A (en) * | 2006-04-20 | 2006-12-06 | 北京艾德斯科技有限公司 | Method and equipment for backing up, replicating and recovering data under environment |
| CN102236588A (en) * | 2010-04-23 | 2011-11-09 | 阿里巴巴集团控股有限公司 | Remote data backup method, equipment and system |
| CN102394923A (en) * | 2011-10-27 | 2012-03-28 | 周诗琦 | Cloud system platform based on n*n display structure |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104077403A (en) * | 2014-07-04 | 2014-10-01 | 用友软件股份有限公司 | Alcedo database scheduled task processing method and processing device |
| CN104077403B (en) * | 2014-07-04 | 2017-06-30 | 用友网络科技股份有限公司 | For the processing method and processing unit of the plan target of Alcedo databases |
| CN104539690A (en) * | 2014-12-24 | 2015-04-22 | 大连理工大学 | Server remote data synchronizing method based on feedback mechanism and MD5 code detection |
| CN104539690B (en) * | 2014-12-24 | 2018-05-04 | 大连理工大学 | A kind of Server remote method of data synchronization detected based on feedback mechanism and MD5 codes |
| CN107463464A (en) * | 2017-07-20 | 2017-12-12 | 深圳互联先锋科技有限公司 | The method and device of automatically backup data file |
| CN107463465A (en) * | 2017-07-20 | 2017-12-12 | 深圳互联先锋科技有限公司 | The method and device of remote backup database |
| CN108628706A (en) * | 2018-05-02 | 2018-10-09 | 北京新桥信通科技股份有限公司 | Method, apparatus, system and the storage medium of data backup |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103870363A (en) | Database data remote backup method | |
| US11042503B1 (en) | Continuous data protection and restoration | |
| US11860741B2 (en) | Continuous data protection | |
| CN105843707B (en) | Database quick recovery method and equipment | |
| CN103677973A (en) | Distributed multi-task scheduling management system | |
| CN103888530A (en) | Experiment teaching system based on cloud desktop | |
| CN103744724A (en) | Timed task clustering method and device thereof | |
| CN104346454A (en) | Data consistency verification method based on Oracle database | |
| CN104603776A (en) | Archival data storage system | |
| CN104484766A (en) | Enterprise management application system | |
| CN102497404B (en) | Storage backup method based on cloud environment | |
| CN109144785A (en) | Method and apparatus for Backup Data | |
| CN104536965A (en) | System and method for data query and presentation under big data condition | |
| CN105224422A (en) | A kind of data back up method and equipment | |
| CN107798444B (en) | Hot-rolled strip steel MES system parallel debugging data acquisition method | |
| CN104765651A (en) | Data processing method and device | |
| CN107273378B (en) | File storage method and device | |
| CN111932250A (en) | Method for realizing power grid information sharing based on block chain technology | |
| CN105357280A (en) | Hadoop distributed file system (HDFS) based file tracing file transfer protocol (FTP) system | |
| CN104063294B (en) | A kind of linux system backup and restoration methods | |
| CN103973486A (en) | Log management system based on B/S structure | |
| CN103853827A (en) | Database backup method capable of guaranteeing data consistency | |
| CN103942123A (en) | Method and system for achieving cloud disaster recovery backup through reverse data fetching | |
| CN103473654A (en) | Asset data cleaning auxiliary method and system for electric ERP system | |
| CN103235988A (en) | Integrated database supervisory platform, working method thereof, and backup task process management business control method on basis of integrated database supervisory platform |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20140618 |