CN106569920A - Database backup method and device - Google Patents
Database backup method and device Download PDFInfo
- Publication number
- CN106569920A CN106569920A CN201610988896.8A CN201610988896A CN106569920A CN 106569920 A CN106569920 A CN 106569920A CN 201610988896 A CN201610988896 A CN 201610988896A CN 106569920 A CN106569920 A CN 106569920A
- Authority
- CN
- China
- Prior art keywords
- backup
- configuration information
- data base
- configuration
- file destination
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 63
- 238000001514 detection method Methods 0.000 claims abstract description 21
- 230000014759 maintenance of location Effects 0.000 claims description 29
- 238000013515 script Methods 0.000 claims description 19
- 238000012360 testing method Methods 0.000 claims description 8
- GOLXNESZZPUPJE-UHFFFAOYSA-N spiromesifen Chemical compound CC1=CC(C)=CC(C)=C1C(C(O1)=O)=C(OC(=O)CC(C)(C)C)C11CCCC1 GOLXNESZZPUPJE-UHFFFAOYSA-N 0.000 claims description 6
- 230000000737 periodic effect Effects 0.000 abstract description 2
- 238000010586 diagram Methods 0.000 description 11
- 230000015654 memory Effects 0.000 description 8
- 230000008569 process Effects 0.000 description 8
- 230000000694 effects Effects 0.000 description 5
- 238000004891 communication Methods 0.000 description 4
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 230000009471 action Effects 0.000 description 2
- 230000006399 behavior Effects 0.000 description 2
- 230000008878 coupling Effects 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 230000006872 improvement Effects 0.000 description 2
- 230000003993 interaction Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000004899 motility Effects 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- 241000208340 Araliaceae Species 0.000 description 1
- 235000005035 Panax pseudoginseng ssp. pseudoginseng Nutrition 0.000 description 1
- 235000003140 Panax quinquefolius Nutrition 0.000 description 1
- 230000006978 adaptation Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 230000001419 dependent effect Effects 0.000 description 1
- 235000008434 ginseng Nutrition 0.000 description 1
- 238000009434 installation Methods 0.000 description 1
- 239000000203 mixture Substances 0.000 description 1
- 210000003205 muscle Anatomy 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 238000011897 real-time detection Methods 0.000 description 1
- 238000011084 recovery Methods 0.000 description 1
- 230000009467 reduction Effects 0.000 description 1
- 230000004044 response Effects 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1446—Point-in-time backing up or restoration of persistent data
- G06F11/1458—Management of the backup or restore process
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
- G06F2201/80—Database-specific techniques
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Quality & Reliability (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a database backup method and device. The method comprises: configuration information uploaded by the client is received, wherein the configuration information is used for indicating a backup operation on a database of a server; a backup command for indicating a backup operation on a database is added to a target file based on the received configuration information, wherein the target file is used for setting a command of periodic execution; whether predetermined execution time for executing the backup command added to the target file is reached is detected; and after detection of reaching of the predetermined execution time, the backup command in the target file are executed to carry out the backup operation on the database. Therefore, technical problems that the manpower cost is high, the usage flexibility is poor, and the operation can not be carried out conveniently because of the manual way of database backup in the prior art can be solved.
Description
Technical field
The present invention relates to database field, in particular to a kind of database backup method and device.
Background technology
In the related, DB Backup mainly by DBA (Database Administrator, data base administrator,
Referring to the general designation of the relevant staff for being engaged in management and safeguarding data base management system (DBMS)) immediate operand is according to library management
Software, carries out manual configuration and completes backup, the backup and recovery of above-mentioned technical proposal not only data base to server-side database
DBA is highly relied on, and human cost is higher, using underaction, lack the customizability of the concrete business of adaptation, operation inconvenience
It is prompt.
For the problems referred to above, effective solution is not yet proposed at present.
The content of the invention
A kind of database backup method and device are embodiments provided, at least to solve in correlation technique due to adopting
The human cost that caused with the mode of manual backup data base is high, using underaction, operation not enough easily technical problem.
A kind of one side according to embodiments of the present invention, there is provided database backup method, including：Receive in client
The configuration information of biography, wherein, configuration information is used to indicate to carry out backup operation to the data base on server；According to what is received
Configuration information, adds for indicating to carry out data base the backup command of backup operation in file destination, wherein, file destination
For arranging the order being periodically performed；Detect whether to reach and perform the predetermined of the backup command being added in file destination
The execution time；After detection reaches the predetermined execution time, the backup command in performance objective file, to carry out to data base
Backup operation.
Another aspect according to embodiments of the present invention, additionally provides a kind of DB Backup device, including：Receiving unit,
For receiving the configuration information of client upload, wherein, configuration information is used to indicate to back up the data base on server
Operation；Adding device, it is standby for indicating to carry out data base for according to the configuration information that receives, adding in file destination
The backup command of part operation, wherein, file destination is used to arrange the order being periodically performed；First detector unit, for examining
Whether survey reaches the predetermined execution time for performing the backup command being added in file destination；Backup units, in detection
After reaching the predetermined execution time, the backup command in performance objective file, to carry out backup operation to data base.
In embodiments of the present invention, by the way of automatically backup data storehouse, by being received in client on the server
The configuration information of biography, wherein, configuration information is used to indicate to carry out backup operation to the data base on server；According to what is received
Configuration information, adds for indicating to carry out data base the backup command of backup operation in file destination, wherein, file destination
For arranging the order being periodically performed；Detect whether to reach and perform the predetermined of the backup command being added in file destination
The execution time；After detection reaches the predetermined execution time, the backup command in performance objective file, to carry out to data base
Backup operation, as file destination is the clothes for arranging the order being periodically performed, therefore after the predetermined execution time is reached
Business device will automatically in performance objective file above-mentioned backup command, reached the purpose in automatically backup data storehouse, so as to realize
Reduction human cost, improves the technique effect of the motility and convenient degree for using, and then solves in correlation technique due to adopting
The human cost that caused with the mode of manual backup data base is high, using underaction, operation not enough easily technical problem.
Description of the drawings
Accompanying drawing described herein is used for providing a further understanding of the present invention, constitutes the part of the application, this
Bright schematic description and description does not constitute inappropriate limitation of the present invention for explaining the present invention.In the accompanying drawings：
Fig. 1 is the schematic diagram of the hardware environment of database backup method according to embodiments of the present invention；
Fig. 2 is the flow chart of a kind of optional database backup method according to embodiments of the present invention；
Fig. 3 (a) is a kind of schematic diagram for optionally unsuccessfully being alerted to DB Backup according to embodiments of the present invention；
Fig. 3 (b) is the signal optionally unsuccessfully alerted to DB Backup by another kind according to embodiments of the present invention
Figure；
Fig. 4 is the Organization Chart of a kind of optional database backup system according to embodiments of the present invention；
Fig. 5 is a kind of schematic diagram for optionally realizing DB Backup according to embodiments of the present invention；
Fig. 6 is the schematic diagram of a kind of optional DB Backup device according to embodiments of the present invention；
Fig. 7 is the schematic diagram of a kind of optional DB Backup device according to embodiments of the present invention；
Fig. 8 is the schematic diagram of a kind of optional DB Backup device according to embodiments of the present invention；
Fig. 9 is the schematic diagram of a kind of optional DB Backup device according to embodiments of the present invention；
Figure 10 is the schematic diagram of a kind of optional DB Backup device according to embodiments of the present invention；
Figure 11 is the schematic diagram of a kind of optional DB Backup device according to embodiments of the present invention；And
Figure 12 is a kind of structured flowchart of terminal according to embodiments of the present invention.
Specific embodiment
In order that those skilled in the art more fully understand the present invention program, below in conjunction with the embodiment of the present invention
Accompanying drawing, is clearly and completely described to the technical scheme in the embodiment of the present invention, it is clear that described embodiment is only
The embodiment of a part of the invention, rather than the embodiment of whole.Based on the embodiment in the present invention, ordinary skill people
The every other embodiment obtained under the premise of creative work is not made by member, should all belong to the model of present invention protection
Enclose.
It should be noted that description and claims of this specification and the term " first " in above-mentioned accompanying drawing, "
Two " it is etc. for distinguishing similar object, without for describing specific order or precedence.It should be appreciated that so using
Data can exchange in the appropriate case, so as to embodiments of the invention described herein can with except here diagram or
Order beyond those of description is implemented.Additionally, term " comprising " and " having " and their any deformation, it is intended that cover
Lid is non-exclusive to be included, and for example, process, method, system, product or the equipment for containing series of steps or unit is not necessarily limited to
Those steps clearly listed or unit, but may include clearly not list or for these processes, method, product
Or intrinsic other steps of equipment or unit.
First, the part noun for occurring during being described to the embodiment of the present invention or term are applied to as follows
Explain：
DBA：I.e. Database Administrator, data base administrator, are to be engaged in management and safeguard data base administration
The general designation of the relevant staff of system (DBMS).
RTX：It is enterprise-level real-time communication platform, is devoted to improving work efficiency, reduces linking up the software of cost.
Embodiment 1
According to embodiments of the present invention, there is provided a kind of embodiment of the method for DB Backup.
Alternatively, in the present embodiment, above-mentioned database backup method can apply to as shown in Figure 1 by server
102 and the hardware environment that constituted of terminal 104 in.As shown in figure 1, server 102 is attached with terminal 104 by network,
Above-mentioned network is included but is not limited to：Wide area network, Metropolitan Area Network (MAN) or LAN, terminal 104 are not limited to PC, mobile phone, panel computer
Deng.The database backup method of the embodiment of the present invention can be performed by server 102, it is also possible to performed by terminal 104, also
Can be by the 104 common execution of server 102 and terminal.Wherein, terminal 104 performs the DB Backup side of the embodiment of the present invention
Method can also be performing by client mounted thereto.
Fig. 2 is the flow chart of a kind of optional database backup method according to embodiments of the present invention, as shown in Fig. 2 should
Method may comprise steps of：
Step S202, receives the configuration information of client upload, wherein, configuration information is used to indicate to the number on server
Backup operation is carried out according to storehouse；
Step S204, according to the configuration information for receiving, add in file destination for indicate data base is carried out it is standby
The backup command of part operation, wherein, file destination is used to arrange the order being periodically performed；
Step S206, detects whether to reach the predetermined execution time for performing the backup command being added in file destination；
Step S208, after detection reaches the predetermined execution time, the backup command in performance objective file, with logarithm
Backup operation is carried out according to storehouse.
By above-mentioned steps S202 to step S208, after passing through page configuration configuration information in client,
The configuration information of client upload is received on server, wherein, configuration information is used to indicate to carry out the data base on server
Backup operation；According to the configuration information for receiving, add in file destination for indicating to carry out backup operation to data base
Backup command, wherein, file destination is used to arrange the order being periodically performed；Detect whether that reaching execution has been added to target
The predetermined execution time of the backup command in file；After detection reaches the predetermined execution time, in performance objective file
Backup command, to carry out backup operation to data base, can solve in correlation technique due to using manual backup data base's
Human cost that mode is caused is high, using underaction, operation not enough easily technical problem, and then reach saving manpower into
This, improves flexibility ratio, the technique effect of the convenience of operation for using.
In the technical scheme that step S202 is provided, during enforcement, user is first configured to by configuring the page in client
Indicate to carry out certain data base on server the configuration information of backup operation, afterwards, these configuration informations are uploaded by client
To server, server is being received after the configuration information of client upload, performs related Database Backup operations.
It should be noted that in the present invention, the backup management of data base can be held by the exploitation of data base and management personnel
OK, during enforcement, only need simply to be configured on the heart (such as above-mentioned client) in the backup, it is intended that related backup parameter, this
Sample, server at the appointed time will the corresponding data bases of automated back-up.
In the technical scheme that step S204 is provided, during enforcement, a time file can be designed (such as in server end
Crontab files), and as file destination, by taking crontab files as an example, as crontab files are for arranging week
The order that phase property is performed, therefore, server is after the configuration information for receiving, based on the configuration information, literary to crontab
Add in part for indicating to carry out data base the script file (i.e. backup command) of backup operation, and specify backup cycle and standby
Part time etc., so, specified BACKUP TIME is reached every time, server all can be backed up to data base automatically, so as to overcome
The defect of manually Backup Data is needed in correlation technique.
In the technical scheme that step S206 is provided, during enforcement, system can be added so that whether real-time detection reaches execution
The predetermined execution time (specifying the BACKUP TIME in backup cycle) of the backup command in file destination
In the technical scheme that step S208 is provided, during enforcement, in the case of being to be in testing result, crontab is performed
Backup command in file, to carry out backup operation to data base；In the case where testing result is no, any backup is not performed
Operation, i.e. do not perform the backup command in crontab files, any backup operation is not carried out to data base.
As a kind of optional embodiment, after step S202, i.e. receive the configuration of client upload on the server
After information, said method can also include：
Step S210, according to the configuration information for receiving, sets the predetermined execution of the backup command in performance objective file
Time.
It should be noted that the above-mentioned predetermined execution time can be periodic, specifically, during which can be each cycle
The specified time.For example, when backing up to data base A, a Database Backup operations can be performed daily, i.e. backup cycle sets
For 24 hours, and in each backup cycle, random time can be specified to be BACKUP TIME, for example, BACKUP TIME is set to daily
4AM。
By the embodiment of the present invention, the demand of User Defined DB Backup time can be met.
Used as a kind of optional embodiment, file destination can include：Crontab time files.Crontab time files
As crontab files, this document is a time file, can be used for arranging the order being periodically performed.So, will hold
After the script file of row Database Backup operations adds into this document, server can be according to during the predetermined execution for pre-establishing
Between, periodically back up corresponding data base.
As a kind of optional embodiment, storehouse configuration information of the configuration information at least including data base, wherein, in server
Before the upper configuration information for receiving client upload, said method can also include：Step S212, client pass through page configuration
Above-mentioned configuration information, the step can include：
Step S214, the configuration parameter of client receiving user's input, wherein, configuration parameter includes at least one of
Storehouse configuration parameter：Backup cycle, BACKUP TIME back up retention time；
Step S216, client configure outbound configuration information on the page according to storehouse configuration parameter.
As the data structure of data base mainly has 2, respectively：Tables of data in data base itself and data base, because
This, when backup configuration is carried out to data, at least needs to carry out storehouse configuration, in addition to this it is possible to carry out table configuration.Wherein,
When only carrying out storehouse configuration, give tacit consent to the tables of data in the data base and be required for backup；When carrying out storehouse configuration and table configuration simultaneously, then only
The tables of data (tables of data of table configuration has been carried out) of the needs configuration in data base is backed up.
It should be noted that backup cycle is referred to every how long backing up a data base；BACKUP TIME refers to standby at each
In part cycle, specifically in which time point backup database；Backup retention time refers to addition to standby in above-mentioned file destination
Retention time of part order in the file destination.For example, for certain data base, can set as follows：Backup cycle
For one day, BACKUP TIME was 4AM, and backup retention time is 3 months, and so, within 3 months effect duration, server just can be every
This time of it 4AM performs backup operation to above-mentioned data base, and in other times, is then not carried out corresponding data base standby
Part operation.
Specifically, data base administrator, in configuration database backup information, is operated in units of data base,
Configure the information such as the account number main frame of each data base.And storehouse configuration is the definition to database backup information, mainly belonged to by 3
Property composition, be respectively：Backup cycle, that is, the gap periods for backing up；BACKUP TIME, that is, the concrete time backed up；When backup retains
Between, that is, represent that backup can be automatically deleted more than retention time.
Used as a kind of optional embodiment, configuration information is also configured including the table of the tables of data of the needs backup in data base
Information, wherein, after step S216, i.e. after client configures outbound configuration information according to configuration parameter on the page,
Said method can also include：
Step S218, client configure the tables of data for needing backup on the page according to table configuration parameter in configuration parameter
Table configuration information, wherein, table configuration parameter includes at least one of：Affiliated data base, data table name, backup requirements confirm
Parameter.
Due to may be simultaneously present multiple database tables in a data base, and for specific user, which may be only
Certain or some tables of data being concerned about in the data base, rather than total data table, in this case, to data base
Backup when carrying out relevant configuration, it is allowed to user needs to configure the tables of data of oneself wanting to configure according to oneself, increased number
According to the motility of library backup.
In embodiments of the present invention, take two major parts (that is, the data base's sheet in the data structure to data base
Tables of data in body and data base) mode that all configured, i.e. storehouse configuration had both been carried out, table configuration had been carried out again, wherein, storehouse is matched somebody with somebody
Put process similar with the storehouse configuration in above-described embodiment, will not be described here, and table configuration is specific as follows：Configuring data base
After information (i.e. storehouse configuration is completed), the management personnel of data base can carry out tables of data configuration to the data base, can configure correspondence number
According to the tables of data for needing to be backed up in storehouse.Wherein, table need in being arranged for controlling for data base back up tables of data, this or
Person these tables of data are mainly made up of 3 attributes, are respectively：Affiliated data base, which configures the numerical value of corresponding data base with storehouse
Mark；The title of tables of data in data table name, i.e. data base；Whether backup is needed, i.e., for indicating whether the table needs to carry out
Backup.
By the embodiment of the present invention, the demand of the tables of data of needs backup in User Defined data base can be met.
As a kind of optional embodiment, after step s 204, i.e. according to the configuration information for receiving, to target
After adding in file for indicating to carry out the backup command of backup operation to data base, said method can also include：
Step S220, detects whether to reach the backup retention time for deleting the backup command being added in file destination；
Step S222, after detection reaches backup retention time, deletes backup command, to forbid from file destination
Continuation carries out backup operation to data base.
That is, when implementing, server is being added to certain number in file destination according to the configuration information of client upload
According to after the backup command backed up by storehouse, can be with after backup retention time be reached, by above-mentioned backup command from above-mentioned target
Delete in file, as such, it is possible to so that data base (backs up retention time) in effective time just performs corresponding data base
Backup operation.For example, for data base A, user actually wants to carry out within the October-three months December of certain year standby
Part, and after this year December, the data base is no longer backed up, so, used above-mentioned technical proposal can reach the year in the time
After December, the relevant backup script of the data base is deleted from file destination.
By the embodiment of the present invention, the demand of the backup retention time of User Defined data base can be met.
As a kind of optional embodiment, after step S208, i.e. the backup command in performance objective file, with
After backup operation is carried out to data base, said method can also include：
Step S224, the state for detecting backup script file and/or the return value for performing backup command；
Step S226, according to testing result, judges data base's whether backup failure；
Step S228, after DB Backup failure is judged, then calls remote alarm interface to be reported to the police, to notify user
DB Backup fails.
That is, implement when, can only by detection backup script file (i.e. the corresponding script of backup command) state,
Or only by the return value of detection backup command, or while detect backup script file (the i.e. corresponding foot of backup command
This) state and backup command return value judging data base's whether backup failure.Wherein, if backing up successfully, do not appoint
Manage where；If backup failure, alerted.Specifically, in backup failure, corresponding remote alarm interface can be called, with logical
Know customer data base backup failure.Alarm notification can include various ways, this is no longer going to repeat them, wherein Fig. 3 (a) and figure
It is for reference that 3 (b) respectively illustrates two kinds of type of alarms, i.e. can RTX and mail notification related personnel after backup failure.
The present invention is elaborated with a specific embodiment below：
As DB Backup had both needed the support of specific data structure, the support of specific flow process is needed again.Wherein, data
Structure is used to define the relevant configuration information for indicating to carry out backup operation, and flow process is used for the control flow for defining whole backup procedure
And interaction flow.Realization to data structure and flow process and backup below is illustrated respectively：
One data structure
Data structure mainly includes 2, and storehouse configuration and table are configured, and are described below respectively：
(1) storehouse configuration
Data base administrator is operated in units of data base when configuring to DB Backup, configuration
The information such as the account number main frame of each data base.Storehouse configuration is the definition to database backup information, mainly by 3 set of properties
Into being respectively：Backup cycle, that is, the gap periods for backing up；BACKUP TIME, that is, the concrete time backed up；Backup retention time, i.e.,
Represent that backup can be automatically deleted more than retention time.
(2) table configuration
After the storehouse configuration information for configuring data base, the management personnel of data base can carry out tables of data to the data base
Relevant configuration, that is, need the tables of data for being backed up in configuring correspondence database.Table needs standby in being arranged for controlling for data base
The tables of data of part, is mainly made up of 3 attributes, is respectively：Affiliated data base, i.e., configure the numerical value mark of corresponding data base with storehouse
Know；The title of tables of data in data table name, i.e. data base；Whether backup is needed, i.e., for indicating it is standby whether the table needs to carry out
Part.
Two control flows
Entirely the configuration process of DB Backup by two data structures defined above (i.e. storehouse configuration and table are configured) is
Basis, is related to two modules of backstage server (i.e. server) and TV clients, and the interaction between each module is as shown in Figure 4.
Whole flow process is comprised the steps of：1) when the management personnel of data base have configured backup database by webpage with confidence
Breath；2) back up background server (referred to as server) and receive related configuration information, and according to the configuration information behaviour for receiving
Make crontab files (i.e. file destination), add the sentence in automatically backup data storehouse in crontab files according to configuration information
(i.e. backup command)；3) the relevant backup order when the scheduled backup time is reached in execution crontab files, with to response
Data base is backed up；If 4) backup failure, the management personnel of RTX and/or mail notification Relational database；5) here mistake
In journey, TV clients can be normally interacted with data base by CGI.
Three backups are realized
When data base of the server on to server carries out backup operation, according to user configured storehouse configuration information and table
Configuration information, the backup command provided with reference to data base realize backup purpose.In order to ensure the safety of system, the present invention is adopted
The shell scripts (i.e. backup command) for backing up and the shell feet for being automatically deleted backup are automatically added in crontab tasks
This, and at the appointed time perform automatically the backup command that is added in crontab files to realize backing up.Specific implementation is such as
Under：
1) management personnel of data base are by configuring the configuration backed up by the good tables of data in data base of page configuration
After information, server can create shell script files according to the configuration information, and shell script files and data base correspond,
Act as backing up the specified tables of data of specified database, service is written into after the completion of shell script files are created
In the crontab files of device, and take the parameter such as execution time and execution cycle.
2) ultimate principle that time-out backup is deleted is to create shell scripts, is act as each in traversal backup file
Individual crontab files, obtain its creation time, and calculate the difference of the creation time and current time, if the difference exceedes matching somebody with somebody
The backup file put answers retention time (backing up retention time), then delete this document.Shell scripts need to provide two parameters,
One is backup folder path, and two is backup file retention time.After the completion of the configuration of storehouse, system will be automatically created according to configuration
Shell is simultaneously periodically executed in adding it to crontab files.
3) after backup command is performed, backup script can check backup command return value and backup file statuss, if finding
Backup failure, then call relative alarm interface, notifies creator and management personnel's DB Backup of backup failure data base
Failure, alarm is as shown in Fig. 3 (a) and Fig. 3 (b).
By the embodiment of the present invention, based on table configuration and storehouse configuration, there is provided a kind of DB Backup of Self management
Point-solution；According to configuration information, using crontab+shell files, automated back-up and backup file management are realized
Solution, as shown in Figure 5；During backup failure, by RTX and/or mail automatic alarm.
It should be noted that for aforesaid each method embodiment, in order to be briefly described, therefore which is all expressed as a series of
Combination of actions, but those skilled in the art should know, the present invention do not limited by described sequence of movement because
According to the present invention, some steps can adopt other orders or while carry out.Secondly, those skilled in the art should also know
Know, embodiment described in this description belongs to preferred embodiment, involved action and module are not necessarily of the invention
It is necessary.
Through the above description of the embodiments, those skilled in the art is can be understood that according to above-mentioned enforcement
The method of example can add the mode of required general hardware platform to realize by software, naturally it is also possible to by hardware, but a lot
In the case of the former be more preferably embodiment.Based on such understanding, technical scheme is substantially in other words to existing
The part that technology contributes can be embodied in the form of software product, and the computer software product is stored in a storage
In medium (such as ROM/RAM, magnetic disc, CD), use including some instructions so that a station terminal equipment (can be mobile phone, calculate
Machine, server, or network equipment etc.) method that performs each embodiment of the invention.
Embodiment 2
According to embodiments of the present invention, additionally provide a kind of DB Backup for implementing above-mentioned database backup method to fill
Put.Fig. 6 is the schematic diagram of a kind of optional DB Backup device according to embodiments of the present invention, as shown in fig. 6, the device can
To include：Receiving unit 602, for receiving the configuration information of client upload, wherein, configuration information is used to indicate to server
On data base carry out backup operation；Adding device 604, for according to the configuration information for receiving, adding in file destination
For indicating to carry out data base the backup command of backup operation, wherein, file destination is used to arrange the life being periodically performed
Order；First detector unit 606, for detecting whether reaching the predetermined execution for performing the backup command being added in file destination
Time；Backup units 608, after reaching the predetermined execution time in detection, the backup command in performance objective file, with
Backup operation is carried out to data base.
It should be noted that the receiving unit 602 in the embodiment can be used for performing the step in the embodiment of the present application 1
S202, the adding device 604 in the embodiment can be used for performing step S204 in the embodiment of the present application 1, in the embodiment
Detector unit 606 can be used for perform the embodiment of the present application 1 in step S206, the backup units 608 in the embodiment can
For performing step S208 in the embodiment of the present application 1.
Herein it should be noted that said units are identical with example and application scenarios that the step of correspondence is realized, but not
It is limited to 1 disclosure of that of above-described embodiment.It should be noted that said units as device a part may operate in as
In hardware environment shown in Fig. 1, can be realized by software, it is also possible to realized by hardware.
As a kind of optional embodiment, as shown in fig. 7, said apparatus can also include：Setting unit 702, for connecing
After receiving the configuration information of client upload, according to the configuration information for receiving, the backup command in performance objective file is set
The predetermined execution time.
It should be noted that the setting unit 702 in the embodiment can be used for performing the step in the embodiment of the present application 1
S210。
Herein it should be noted that said units are identical with example and application scenarios that the step of correspondence is realized, but not
It is limited to 1 disclosure of that of above-described embodiment.It should be noted that said units as device a part may operate in as
In hardware environment shown in Fig. 1, can be realized by software, it is also possible to realized by hardware.
Used as a kind of optional embodiment, file destination includes：Crontab time files.
As a kind of optional embodiment, as shown in figure 8, configuration information can at least include that confidence is matched somebody with somebody in the storehouse of data base
Breath, wherein, said apparatus can also include：Dispensing unit 802, for the configuration information for receiving client upload on the server
Before so that by the above-mentioned configuration information of page configuration, further, above-mentioned dispensing unit 802 can include client：Receive mould
Block 8022, for the configuration parameter of client receiving user's input, wherein, configuration parameter includes the storehouse configuration of at least one of
Parameter：Backup cycle, BACKUP TIME back up retention time；First configuration module 8024, for client according to storehouse configuration parameter
Outbound configuration information is configured on the page.
It should be noted that the dispensing unit 802 in the embodiment can be used for performing the step in the embodiment of the present application 1
S212, the receiver module 8022 in the embodiment can be used for performing step S214 in the embodiment of the present application 1, in the embodiment
The first configuration module 8024 can be used for perform the embodiment of the present application 1 in step S216.
Herein it should be noted that above-mentioned module/unit is identical with example and application scenarios that the step of correspondence is realized,
But it is not limited to 1 disclosure of that of above-described embodiment.It should be noted that above-mentioned module/unit can as the part of device
To operate in hardware environment as shown in Figure 1, can be realized by software, it is also possible to realized by hardware.
As a kind of optional embodiment, as shown in figure 9, above-mentioned configuration information can also include that the needs in data base are standby
The table configuration information of the tables of data of part, wherein, above-mentioned dispensing unit 802 can also include：Second configuration module 902, for
After client configures outbound configuration information according to configuration parameter on the page, client is according to table configuration parameter in configuration parameter
The table configuration information of the tables of data for needing backup is configured on the page, wherein, table configuration parameter includes at least one of：Institute
Category data base, data table name, backup requirements confirm parameter.
It should be noted that the second configuration module 902 in the embodiment can be used for performing in the embodiment of the present application 1
Step S218.
Herein it should be noted that above-mentioned module is identical with example and application scenarios that the step of correspondence is realized, but not
It is limited to 1 disclosure of that of above-described embodiment.It should be noted that above-mentioned module as device a part may operate in as
In hardware environment shown in Fig. 1, can be realized by software, it is also possible to realized by hardware.
Used as a kind of optional embodiment, as shown in Figure 10, said apparatus can also include：Second detector unit 1002,
For according to the configuration information for receiving, adding in file destination for indicating to carry out data base the backup of backup operation
After order, detect whether to reach the backup retention time for deleting the backup command being added in file destination；Delete unit
1004, after backup retention time being reached in detection, delete backup command from file destination, to forbid continuing logarithm
Backup operation is carried out according to storehouse.
It should be noted that the second detector unit 1002 in the embodiment can be used for performing in the embodiment of the present application 1
The step of S220, in the embodiment delete unit 1004 can be used for perform the embodiment of the present application 1 in step S222.
Herein it should be noted that said units are identical with example and application scenarios that the step of correspondence is realized, but not
It is limited to 1 disclosure of that of above-described embodiment.It should be noted that said units as device a part may operate in as
In hardware environment shown in Fig. 1, can be realized by software, it is also possible to realized by hardware.
Used as a kind of optional embodiment, as shown in figure 11, said apparatus can also include：3rd detector unit 1102,
For the backup command in performance objective file, after backup operation being carried out to data base, detect backup script file
The return value of state and/or execution backup command；Judging unit 1104, for according to testing result, judging whether data base is standby
Part failure；Alarm Unit 1106, for after DB Backup failure is judged, then calling remote alarm interface to be reported to the police, with
Notify customer data base backup failure.
It should be noted that the 3rd detector unit 1102 in the embodiment can be used for performing in the embodiment of the present application 1
The step of S224, the judging unit 1104 in the embodiment can be used for perform the embodiment of the present application 1 in step S226, the reality
Apply the Alarm Unit 1106 in example to can be used for performing step S228 in the embodiment of the present application 1.
Herein it should be noted that said units are identical with example and application scenarios that the step of correspondence is realized, but not
It is limited to 1 disclosure of that of above-described embodiment.It should be noted that said units as device a part may operate in as
In hardware environment shown in Fig. 1, can be realized by software, it is also possible to realized by hardware.
By above-mentioned module, can solve in correlation technique due to the people caused by the way of manual backup data base
Power high cost, using underaction, operation not enough easily technical problem, and then reach saving human cost, what raising was used
The technique effect of flexibility ratio, the convenience of operation.
Embodiment 3
According to embodiments of the present invention, a kind of server for implementing above-mentioned database backup method or end are additionally provided
End.
Figure 12 is a kind of structured flowchart of terminal according to embodiments of the present invention, and as shown in figure 12, the terminal can include：
One or more (one is only illustrated in figure) processors 201, memorizer 203, and transmitting device 205 (in above-mentioned embodiment
Dispensing device), as shown in figure 12, the terminal can also include input-output equipment 207.
Wherein, memorizer 203 can be used to store software program and module, the such as DB Backup in the embodiment of the present invention
Corresponding programmed instruction/the module of method and apparatus, processor 201 by operation be stored in software program in memorizer 203 with
And module, so as to perform various function application and data processing, that is, realize above-mentioned database backup method.Memorizer 203
High speed random access memory is may include, nonvolatile memory, such as one or more magnetic storage device, sudden strain of a muscle can also be included
Deposit or other non-volatile solid state memories.In some instances, memorizer 203 can be further included relative to processor
201 remotely located memorizeies, these remote memories can be by network connections to terminal.The example of above-mentioned network include but
It is not limited to the Internet, intranet, LAN, mobile radio communication and combinations thereof.
Above-mentioned transmitting device 205 for data are received or sent via network, can be also used for processor with
Data transfer between memorizer.Above-mentioned network instantiation may include cable network and wireless network.In an example,
Transmitting device 205 includes a network adapter (Network Interface Controller, NIC), and which can pass through netting twine
It is connected with router so as to be communicated with the Internet or LAN with other network equipments.In an example, transmission dress
205 are put for radio frequency (Radio Frequency, RF) module, which is used to wirelessly be communicated with the Internet.
Wherein, specifically, memorizer 203 is used to store application program.
Processor 201 can pass through the application program that transmitting device 205 calls memorizer 203 to store, to perform following steps
Suddenly：The configuration information of client upload is received, wherein, configuration information is used to indicate to carry out backup behaviour to the data base on server
Make；According to the configuration information for receiving, add in file destination for indicating to carry out data base the backup life of backup operation
Order, wherein, file destination is used to arrange the order being periodically performed；Detect whether that reaching execution has been added in file destination
Backup command the predetermined execution time；Backup life after detection reaches the predetermined execution time, in performance objective file
Order, to carry out backup operation to data base.
Processor 201 is additionally operable to perform following step：After the configuration information for receiving client upload, according to receiving
Configuration information, set performance objective file in backup command the predetermined execution time.
Processor 201 is additionally operable to perform following step：Storehouse configuration information of the configuration information at least including data base, wherein,
Before the configuration information of client upload is received, client passes through the above-mentioned configuration information of page configuration, wherein, client passes through
The above-mentioned configuration information of page configuration can include：The configuration parameter of client receiving user's input, wherein, configuration parameter include with
At least one lower storehouse configuration parameter：Backup cycle, BACKUP TIME back up retention time；Client exists according to storehouse configuration parameter
Outbound configuration information is configured on the page.
Processor 201 is additionally operable to perform following step：Configuration information also includes the tables of data for needing backup in data base
Table configuration information, wherein, after client configures outbound configuration information according to configuration parameter on the page, client according to
In configuration parameter, table configuration parameter configures the table configuration information of the tables of data for needing backup on the page, wherein, table configuration ginseng
Number includes at least one of：Affiliated data base, data table name, backup requirements confirm parameter.
Processor 201 is additionally operable to perform following step：According to the configuration information for receiving, add in file destination and use
After indicating the backup command of backup operation to be carried out to data base, detect whether that reaching deletion has been added in file destination
The backup retention time of backup command；After detection reaches backup retention time, backup command is deleted from file destination,
To forbid continuing to carry out backup operation to data base.
Processor 201 is additionally operable to perform following step：Backup command in performance objective file, to carry out to data base
After backup operation, the return value of the state and/or execution backup command of backup script file is detected；According to testing result, sentence
Disconnected data base whether backup failure；After DB Backup failure is judged, then remote alarm interface is called to be reported to the police, to notify
Customer data base backup failure.
Using the embodiment of the present invention, there is provided a kind of scheme of DB Backup.The configuration information of client upload is received,
Wherein, configuration information is used to indicate to carry out backup operation to the data base on server；According to the configuration information for receiving, to mesh
Add in mark file for indicating to carry out data base the backup command of backup operation, wherein, file destination is used to arrange the cycle
The order that property is performed；Detect whether to reach the predetermined execution time for performing the backup command being added in file destination；
After detection reaches the predetermined execution time, the backup command in performance objective file, to carry out backup operation to data base, reaches
The purpose in automatically backup data storehouse has been arrived, it is achieved thereby that saving human cost, flexibility ratio, the convenience of operation for using has been improved
Technique effect, and then solve in correlation technique as the human cost caused by the way of manual backup data base is high,
Using underaction, the inadequate easily technical problem of operation.
Alternatively, the specific example in the present embodiment may be referred to showing described in above-described embodiment 1 and embodiment 2
Example, the present embodiment will not be described here.
It will appreciated by the skilled person that the structure shown in Figure 12 is only illustrated, terminal can be smart mobile phone
(such as Android phone, iOS mobile phones etc.), panel computer, palm PC and mobile internet device (Mobile Internet
Devices, MID), the terminal unit such as PAD.Figure 12 which does not cause to limit to the structure of above-mentioned electronic installation.For example, terminal is also
May include more more than shown in Figure 12 or less components (such as network interface, display device etc.), or with Figure 12 institutes
Show different configurations.
One of ordinary skill in the art will appreciate that all or part of step in the various methods of above-described embodiment is can
With by program come the device-dependent hardware of command terminal completing, the program can be stored in a computer-readable recording medium
In, storage medium can include：Flash disk, read only memory (Read-Only Memory, ROM), random access device (Random
Access Memory, RAM), disk or CD etc..
Embodiment 4
Embodiments of the invention additionally provide a kind of storage medium.Alternatively, in the present embodiment, above-mentioned storage medium can
For performing the program code of database backup method.
Alternatively, in the present embodiment, above-mentioned storage medium may be located at multiple in the network shown in above-described embodiment
On at least one of network equipment network equipment.
Alternatively, in the present embodiment, storage medium is arranged to store the program code for being used to performing following steps：
S1, receives the configuration information of client upload, wherein, configuration information is used to indicate to enter the data base on server
Row backup operation；
S2, according to the configuration information for receiving, adds for indicating to carry out backup operation to data base in file destination
Backup command, wherein, file destination is used to arrange the order being periodically performed；
S3, detects whether to reach the predetermined execution time for performing the backup command being added in file destination；
S4, after detection reaches the predetermined execution time, the backup command in performance objective file, to enter to data base
Row backup operation.
Alternatively, storage medium is also configured to store the program code for being used to performing following steps：Receiving client
After the configuration information of upload, according to the configuration information for receiving, the predetermined of backup command set in performance objective file holds
The row time.
Alternatively, storage medium is also configured to store the program code for being used to performing following steps：Configuration information is at least
Including the storehouse configuration information of data base, wherein, before the configuration information of client upload is received, client passes through page configuration
Above-mentioned configuration information, wherein, client can be included by the above-mentioned configuration information of page configuration：Client receiving user's input
Configuration parameter, wherein, configuration parameter includes the storehouse configuration parameter of at least one of：Backup cycle, BACKUP TIME, backup retain
Time；Client configures outbound configuration information on the page according to storehouse configuration parameter.
Alternatively, storage medium is also configured to store the program code for being used to performing following steps：Configuration information is also wrapped
The table configuration information of the tables of data that the needs in data base are backed up is included, wherein, matched somebody with somebody on the page according to configuration parameter in client
After putting outbound configuration information, client configures the data for needing backup on the page according to table configuration parameter in configuration parameter
The table configuration information of table, wherein, table configuration parameter includes at least one of：Affiliated data base, data table name, backup requirements are true
Recognize parameter.
Alternatively, storage medium is also configured to store the program code for being used to performing following steps：Receive in basis
Configuration information, add in file destination for indicate the backup command of backup operation is carried out to data base after, detection is
It is no to reach the backup retention time for deleting the backup command being added in file destination；Backup retention time is reached in detection
Afterwards, backup command is deleted from file destination, to forbid continuing to carry out backup operation to data base.
Alternatively, storage medium is also configured to store the program code for being used to performing following steps：In performance objective text
Backup command in part, after carrying out backup operation to data base, detects the state of backup script file and/or performs backup
The return value of order；According to testing result, data base's whether backup failure is judged；After DB Backup failure is judged,
Remote alarm interface is then called to be reported to the police, to notify customer data base backup failure.
Alternatively, the specific example in the present embodiment may be referred to showing described in above-described embodiment 1 and embodiment 2
Example, the present embodiment will not be described here.
Alternatively, in the present embodiment, above-mentioned storage medium can be including but not limited to：USB flash disk, read only memory (ROM,
Read-Only Memory), random access memory (RAM, Random Access Memory), portable hard drive, magnetic disc or
CD etc. is various can be with the medium of store program codes.
The embodiments of the present invention are for illustration only, do not represent the quality of embodiment.
If the integrated unit in above-described embodiment is realized and as independent product using in the form of SFU software functional unit
When sale or use, can be stored in the storage medium that above computer can read.Based on such understanding, the skill of the present invention
The part or all or part of the technical scheme that art scheme is substantially contributed to prior art in other words can be with soft
The form of part product is embodied, and the computer software product is stored in storage medium, is used so that one including some instructions
Platform or multiple stage computers equipment (can be personal computer, server or network equipment etc.) perform each embodiment institute of the invention
State all or part of step of method.
In the above embodiment of the present invention, the description to each embodiment all emphasizes particularly on different fields, and does not have in certain embodiment
The part of detailed description, may refer to the associated description of other embodiment.
In several embodiments provided herein, it should be understood that disclosed client, other sides can be passed through
Formula is realized.Wherein, device embodiment described above is only schematic, such as the division of described unit, and only one
Kind of division of logic function, can have when actually realizing other dividing mode, such as multiple units or component can with reference to or
Another system is desirably integrated into, or some features can be ignored, or do not performed.It is another, it is shown or discussed it is mutual it
Between coupling or direct-coupling or communication connection can be INDIRECT COUPLING or communication link by some interfaces, unit or module
Connect, can be electrical or other forms.
The unit as separating component explanation can be or may not be it is physically separate, it is aobvious as unit
The part for showing can be or may not be physical location, you can local to be located at one, or can also be distributed to multiple
On NE.Some or all of unit therein can be selected according to the actual needs to realize the mesh of this embodiment scheme
's.
In addition, each functional unit in each embodiment of the invention can be integrated in a processing unit, it is also possible to
It is that unit is individually physically present, it is also possible to which two or more units are integrated in a unit.Above-mentioned integrated list
Unit both can be realized in the form of hardware, it would however also be possible to employ the form of SFU software functional unit is realized.
The above is only the preferred embodiment of the present invention, it is noted that for the ordinary skill people of the art
For member, under the premise without departing from the principles of the invention, some improvements and modifications can also be made, these improvements and modifications also should
It is considered as protection scope of the present invention.
Claims (14)
1. a kind of database backup method, it is characterised in that include：
The configuration information of client upload is received, wherein, the configuration information is used to indicate to carry out the data base on server
Backup operation；
According to the configuration information for receiving, add in file destination for indicating to carry out backup operation to the data base
Backup command, wherein, the file destination is used to arrange the order being periodically performed；
Detect whether to reach the predetermined execution time for performing the backup command being added in the file destination；
After detection reaches the predetermined execution time, the backup command in the file destination is performed, with to institute
Stating data base carries out backup operation.
2. method according to claim 1, it is characterised in that after the configuration information for receiving client upload, described
Method also includes：
According to the configuration information for receiving, setting performs the described of the backup command in the file destination and makes a reservation for hold
The row time.
3. method according to claim 1, it is characterised in that the file destination includes：Crontab time files.
4. method according to claim 1, it is characterised in that the configuration information is at least matched somebody with somebody including the storehouse of the data base
Confidence ceases, wherein, before the configuration information of client upload is received, methods described also includes：The client passes through the page
The configuration information is configured, the step includes：
The configuration parameter of the client receiving user's input, wherein, the configuration parameter includes that the storehouse of at least one of is matched somebody with somebody
Put parameter：Backup cycle, BACKUP TIME back up retention time；
The client configures the storehouse configuration information on the page according to the storehouse configuration parameter.
5. method according to claim 4, it is characterised in that the configuration information also includes the needs in the data base
The table configuration information of the tables of data of backup, wherein, configured according to the configuration parameter on the page in the client
After the storehouse configuration information, methods described also includes：
The client configures the number for needing backup on the page according to table configuration parameter in the configuration parameter
According to the table configuration information of table, wherein, the table configuration parameter includes at least one of：Affiliated data base, data table name,
Backup requirements confirm parameter.
6. method according to claim 1, it is characterised in that according to the configuration information for receiving, to target text
After adding in part for indicating to carry out the backup command of backup operation to the data base, methods described also includes：
Detect whether to reach the backup retention time for deleting the backup command being added in the file destination；
After detection reaches the backup retention time, the backup command is deleted from the file destination, to forbid
Continuation carries out backup operation to the data base.
7. method according to claim 1, it is characterised in that the backup command in the file destination is performed,
After carrying out backup operation to the data base, methods described also includes：
The state for detecting the backup script file and/or the return value for performing the backup command；
According to testing result, the data base whether backup failure is judged；
After the DB Backup failure is judged, then remote alarm interface is called to be reported to the police, to notify data described in user
Library backup fails.
8. a kind of DB Backup device, it is characterised in that include：
Receiving unit, for the configuration information in reception client upload, wherein, the configuration information is used to indicate to the clothes
Data base on business device carries out backup operation；
Adding device, for according to the configuration information for receiving, adding in file destination for indicating to the data
Storehouse carries out the backup command of backup operation, wherein, the file destination is used to arrange the order being periodically performed；
First detector unit, for detecting whether reach performing the pre- of the backup command being added in the file destination
Surely perform the time；
Backup units, after reaching the predetermined execution time in detection, perform described standby in the file destination
Part order, to carry out backup operation to the data base.
9. device according to claim 8, it is characterised in that described device also includes：
Setting unit, for after the configuration information for receiving client upload, according to the configuration information for receiving, setting
Perform the described predetermined execution time of the backup command in the file destination.
10. device according to claim 8, it is characterised in that the file destination includes：Crontab time files.
11. devices according to claim 8, it is characterised in that storehouse of the configuration information at least including the data base
Configuration information, wherein, described device also includes：Dispensing unit, for before the configuration information of client upload is received so that
By configuration information described in page configuration, further, the dispensing unit includes the client：
Receiver module, for the configuration parameter of the client receiving user's input, wherein, the configuration parameter include with down to
One of few storehouse configuration parameter：Backup cycle, BACKUP TIME back up retention time；
First configuration module, on the page configures the storehouse configuration according to the storehouse configuration parameter for the client
Information.
12. devices according to claim 11, it is characterised in that the configuration information also includes the need in the data base
The table configuration information of tables of data to be backed up, wherein, the dispensing unit also includes：
Second configuration module, on the page configuring the storehouse configuration according to the configuration parameter in the client
After information, the client according to table configuration parameter in the configuration parameter configure on the page it is described need backup
Tables of data the table configuration information, wherein, the table configuration parameter includes at least one of：Affiliated data base, data
Table name, backup requirements confirm parameter.
13. devices according to claim 8, it is characterised in that described device also includes：
Second detector unit, for according to the configuration information for receiving, adding in file destination for indicating to institute
After stating the backup command that data base carries out backup operation, detect whether to reach and delete the institute being added in the file destination
State the backup retention time of backup command；
Unit is deleted, and after the backup retention time being reached in detection, deletes described standby from the file destination
Part order, to forbid continuing to carry out backup operation to the data base.
14. devices according to claim 8, it is characterised in that described device also includes：
3rd detector unit, it is for the backup command in the file destination is performed, standby to carry out to the data base
After part operation, the return value of the state and/or the execution backup command of the backup script file is detected；
Judging unit, for according to testing result, judging the data base whether backup failure；
Alarm Unit, for after the DB Backup failure is judged, then calling remote alarm interface to be reported to the police, to notify
DB Backup failure described in user.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610988896.8A CN106569920B (en) | 2016-11-09 | 2016-11-09 | Database backup method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610988896.8A CN106569920B (en) | 2016-11-09 | 2016-11-09 | Database backup method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106569920A true CN106569920A (en) | 2017-04-19 |
| CN106569920B CN106569920B (en) | 2020-12-11 |
Family
ID=58540998
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610988896.8A Active CN106569920B (en) | 2016-11-09 | 2016-11-09 | Database backup method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106569920B (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107230148A (en) * | 2017-05-03 | 2017-10-03 | 上海动联信息技术股份有限公司 | A kind of date determination methods for transaction funds settlement process |
| CN107479859A (en) * | 2017-08-02 | 2017-12-15 | 深圳市易材科技有限公司 | A kind of method using php program execution system orders |
| CN109117305A (en) * | 2018-07-24 | 2019-01-01 | 郑州市景安网络科技股份有限公司 | A kind of data back up method, device, equipment and computer readable storage medium |
| CN109885431A (en) * | 2019-03-06 | 2019-06-14 | 北京百度网讯科技有限公司 | Method and apparatus for Backup Data |
| CN110019229A (en) * | 2017-12-25 | 2019-07-16 | 航天信息股份有限公司 | Database configures system |
| CN112579531A (en) * | 2020-12-15 | 2021-03-30 | 东方电气风电有限公司 | Method for downloading and storing wind power plant data |
| CN113032406A (en) * | 2021-05-26 | 2021-06-25 | 四川新网银行股份有限公司 | Data archiving method for centralized management of sub-tables through metadata database |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030004980A1 (en) * | 2001-06-27 | 2003-01-02 | International Business Machines Corporation | Preferential caching of uncopied logical volumes in a peer-to-peer virtual tape server |
| US20080243949A1 (en) * | 2007-03-27 | 2008-10-02 | Yahoo! Inc. | Divided backup of data warehouse |
| CN101873457A (en) * | 2009-09-02 | 2010-10-27 | 杭州海康威视数字技术股份有限公司 | DVR (Digital Video Recorder) as well as data backup method and system thereof |
| CN102541694A (en) * | 2012-01-18 | 2012-07-04 | 浪潮(北京)电子信息产业有限公司 | Method and device for database backup |
| CN104252485A (en) * | 2013-06-29 | 2014-12-31 | 北京新媒传信科技有限公司 | Database management platform |
| CN104679612A (en) * | 2015-03-09 | 2015-06-03 | 陈健强 | Automatic backup and restoration method and automatic backup and restoration system for files |
| CN104731827A (en) * | 2013-12-24 | 2015-06-24 | 重庆新媒农信科技有限公司 | Generating method and generating device for file metadata of fast distributed file system |
| CN105468476A (en) * | 2015-11-18 | 2016-04-06 | 盛趣信息技术（上海）有限公司 | Hadoop distributed file system (HDFS) based data disaster backup system |
| CN105550073A (en) * | 2016-03-10 | 2016-05-04 | 世纪龙信息网络有限责任公司 | Database backup method and system thereof |
-
2016
- 2016-11-09 CN CN201610988896.8A patent/CN106569920B/en active Active
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030004980A1 (en) * | 2001-06-27 | 2003-01-02 | International Business Machines Corporation | Preferential caching of uncopied logical volumes in a peer-to-peer virtual tape server |
| US20080243949A1 (en) * | 2007-03-27 | 2008-10-02 | Yahoo! Inc. | Divided backup of data warehouse |
| CN101873457A (en) * | 2009-09-02 | 2010-10-27 | 杭州海康威视数字技术股份有限公司 | DVR (Digital Video Recorder) as well as data backup method and system thereof |
| CN102541694A (en) * | 2012-01-18 | 2012-07-04 | 浪潮(北京)电子信息产业有限公司 | Method and device for database backup |
| CN104252485A (en) * | 2013-06-29 | 2014-12-31 | 北京新媒传信科技有限公司 | Database management platform |
| CN104731827A (en) * | 2013-12-24 | 2015-06-24 | 重庆新媒农信科技有限公司 | Generating method and generating device for file metadata of fast distributed file system |
| CN104679612A (en) * | 2015-03-09 | 2015-06-03 | 陈健强 | Automatic backup and restoration method and automatic backup and restoration system for files |
| CN105468476A (en) * | 2015-11-18 | 2016-04-06 | 盛趣信息技术（上海）有限公司 | Hadoop distributed file system (HDFS) based data disaster backup system |
| CN105550073A (en) * | 2016-03-10 | 2016-05-04 | 世纪龙信息网络有限责任公司 | Database backup method and system thereof |
Non-Patent Citations (1)
| Title |
|---|
| 秦俊: "TMIS分局调度***数据库的自动备份与恢复", 《铁路计算机应用》 * |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107230148A (en) * | 2017-05-03 | 2017-10-03 | 上海动联信息技术股份有限公司 | A kind of date determination methods for transaction funds settlement process |
| CN107479859A (en) * | 2017-08-02 | 2017-12-15 | 深圳市易材科技有限公司 | A kind of method using php program execution system orders |
| CN110019229A (en) * | 2017-12-25 | 2019-07-16 | 航天信息股份有限公司 | Database configures system |
| CN110019229B (en) * | 2017-12-25 | 2022-04-15 | 航天信息股份有限公司 | Database configuration system |
| CN109117305A (en) * | 2018-07-24 | 2019-01-01 | 郑州市景安网络科技股份有限公司 | A kind of data back up method, device, equipment and computer readable storage medium |
| CN109117305B (en) * | 2018-07-24 | 2022-01-28 | 郑州市景安网络科技股份有限公司 | Data backup method, device and equipment and computer readable storage medium |
| CN109885431A (en) * | 2019-03-06 | 2019-06-14 | 北京百度网讯科技有限公司 | Method and apparatus for Backup Data |
| CN109885431B (en) * | 2019-03-06 | 2022-02-25 | 北京百度网讯科技有限公司 | Method and apparatus for backing up data |
| CN112579531A (en) * | 2020-12-15 | 2021-03-30 | 东方电气风电有限公司 | Method for downloading and storing wind power plant data |
| CN113032406A (en) * | 2021-05-26 | 2021-06-25 | 四川新网银行股份有限公司 | Data archiving method for centralized management of sub-tables through metadata database |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106569920B (en) | 2020-12-11 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106569920A (en) | Database backup method and device | |
| US11652918B2 (en) | Using automatically collected device problem information to route and guide users' requests | |
| US9049105B1 (en) | Systems and methods for tracking and managing event records associated with network incidents | |
| JP6396887B2 (en) | System, method, apparatus, and non-transitory computer readable storage medium for providing mobile device support services | |
| US9246757B2 (en) | Commissioning devices for automation systems | |
| CN105373428B (en) | Task scheduling method and system | |
| CN106302008A (en) | Data-updating method and device | |
| US8281187B1 (en) | Unified and extensible meta-testing framework | |
| CN106713487A (en) | Data synchronization method and device | |
| CN107465572A (en) | Intelligent terminal method of testing, apparatus and system | |
| CN104750550A (en) | Mobile terminal application management system and method and use time record generating method | |
| US20200026640A1 (en) | Systems and methods for modular test platform for applications | |
| CN105592168A (en) | Remotely locating and commanding a mobile device | |
| CN110311831A (en) | System resource monitoring method and relevant device based on container cloud | |
| CN110086664A (en) | A kind of access device fault handling method and device | |
| CN105472417A (en) | Method of acquiring video player abnormity and apparatus thereof | |
| CN108776604A (en) | The execution method and system of goal task | |
| CN102572896A (en) | Upgrading method and upgrading device for wireless communication system | |
| CN105868549A (en) | Medical equipment based on Internet internet of things and communication device and method thereof | |
| CN110515762A (en) | Data reconstruction method, device, terminal device and storage medium | |
| CN108959016A (en) | Acquisition management method, apparatus, server and the data acquisition equipment of monitoring parameter | |
| CN113760611B (en) | System site switching method and device, electronic equipment and storage medium | |
| CN103516880A (en) | Method and device for sending short messages | |
| CN105224420B (en) | A kind of analysis method and system of automatic parsing terminal abnormal | |
| US9053084B1 (en) | Self-service testing |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20231013 Address after: 518000 Tencent Building, No. 1 High-tech Zone, Nanshan District, Shenzhen City, Guangdong Province, 35 Floors Patentee after: TENCENT TECHNOLOGY (SHENZHEN) Co.,Ltd. Patentee after: TENCENT CLOUD COMPUTING (BEIJING) Co.,Ltd. Address before: 2, 518000, East 403 room, SEG science and Technology Park, Zhenxing Road, Shenzhen, Guangdong, Futian District Patentee before: TENCENT TECHNOLOGY (SHENZHEN) Co.,Ltd. |