CN105740101A - Automatic backup and automatic restoration method and apparatus for MySQL database - Google Patents
Automatic backup and automatic restoration method and apparatus for MySQL database Download PDFInfo
- Publication number
- CN105740101A CN105740101A CN201610066727.9A CN201610066727A CN105740101A CN 105740101 A CN105740101 A CN 105740101A CN 201610066727 A CN201610066727 A CN 201610066727A CN 105740101 A CN105740101 A CN 105740101A
- Authority
- CN
- China
- Prior art keywords
- backup
- file
- full backup
- full
- completing
- 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
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/1448—Management of the data involved in backup or backup restore
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Quality & Reliability (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides an automatic backup and automatic restoration method and apparatus for a MySQL database. The automatic backup method for the MySQL database comprises the following steps: determining whether a completely backed-up file exists under a first backup directory; and if the completely backed-up file exists, performing a corresponding backup operation according to whether a current time is a set time. The method and apparatus improve the efficiency of performing MySQL database backup and restoration operations by massive servers and reduce costs of server maintenance.
Description
Technical field
The present invention relates to server technology field, particularly relate to a kind of automated back-up for MySQL database and automatic reduction method and device.
Background technology
The method of the artificial deployment backup and reduction being currently used in the MySQL database of server is comparatively ripe, but when the quantity of server is very many, when especially reaching magnanimity, so batch carries out MySQL database artificial and disposes backup and reduction strategy and be manually backed-up the operation of reduction just unusual trouble, the cost of MySQL database backup and reduction work is greatly improved, reduces the efficiency of backup and reduction work.Accordingly, it would be desirable to a kind of automated back-up for MySQL database and automatic reduction method and device, to solve the above-mentioned technical problem existed in prior art.
Summary of the invention
The invention provides a kind of automated back-up for MySQL database and automatic reduction method and device, improve magnanimity server and perform the efficiency of MySQL database backup and reduction work, reduce the cost of server maintenance.
The technical solution used in the present invention is:
A kind of automatic backup method for MySQL database, it comprises the following steps: judge whether there is the file having completed full backup under the first backup directory；If there is the file having completed full backup, then according to whether current time is set time point, perform corresponding backup operation.
Preferably, described judge whether exist after the file having completed full backup under the first backup directory, described method, also include: if being absent from completing the file of full backup, then carry out full backup operation backed off after random.
Preferably, whether described be set time point according to current time, performs corresponding backup operation, specifically includes: if described current time is described setting time point, then based on nearest complete full backup carry out full backup operation backed off after random.
Preferably, described according to whether current time is set time point, perform corresponding backup operation, specifically include: if described current time is not described setting time point, then further determine whether to start full backup operation；If startup full backup operation, then carry out full backup operation backed off after random based on the nearest file completing full backup.
Preferably, described in judge whether to start after full backup operation, described method, also include: if not starting full backup operation, then carry out incremental backup operations backed off after random based on the described nearest file completing full backup.
Present invention also offers a kind of automatic reduction method for MySQL database, it comprises the following steps: judge whether there is the file having completed full backup under the second backup directory；If there is the file having completed full backup, then according to whether current time is set time point, perform corresponding restoring operation.
Preferably, described judge whether exist after the file having completed full backup under the second backup directory, described method, also include: if being absent from completing the file of full backup, then perform abnormal exit or reports to the police.
Preferably, described according to whether current time is set time point, perform corresponding restoring operation, specifically include: judge whether current time is described setting time point；If described current time is for setting time point, then carry out full backup operation backed off after random based on the nearest file completing full backup.
Preferably, described according to whether current time is set time point, perform corresponding restoring operation, specifically include: if described current time is not described setting time point, then further determine whether to start full backup operation；If starting full backup operation, then carry out full backup operation backed off after random based on the nearest file completing full backup.
Preferably, described in judge whether start full backup operation after, described method, also include: if do not start full backup operation, then check and under the second backup directory, whether there is the file having completed incremental backup；If there is the file having completed incremental backup, then whether the BACKUP TIME having completed the file of incremental backup described in judging again is later than the BACKUP TIME of the described nearest file completing full backup；If the BACKUP TIME of the described file having completed incremental backup is later than the BACKUP TIME of the described nearest file completing full backup, then carries out the up-to-date file completing incremental backup based on the described nearest file completing full backup with based on the described nearest file completing full backup and carry out increment restoring operation.
Present invention also offers a kind of automatic backup device for MySQL database, comprising: the first judge module, for judging whether there is the file having completed full backup under the first backup directory；Backup module, if for there is the file having completed full backup, then according to whether current time is set time point, performs corresponding backup operation.
Preferably, described backup module, it is additionally operable to: if being absent from completing the file of full backup, then carry out full backup operation backed off after random.
Preferably, described backup module, specifically for: if described current time is described setting time point, then carry out full backup operation backed off after random based on the nearest file completing full backup.
Preferably, described backup module includes: first starts judging unit, if not being described setting time point for described current time, then further determines whether to start full backup operation；Full backup unit, if for starting full backup operation, then carrying out full backup operation backed off after random based on the nearest file completing full backup.
Preferably, described backup module, including incremental backup unit, it is used for: start judging unit described first, it may be judged whether after starting full backup operation；If not starting full backup operation, then carry out incremental backup operations backed off after random based on the described nearest file completing full backup.
Present invention also offers a kind of automatic reduction device for MySQL database, comprising: the second judge module, for judging whether there is the file having completed full backup under the second backup directory；Recovery module, if for there is the file having completed full backup, then according to whether current time is set time point, performs corresponding restoring operation.
Preferably, described recovery module, it is additionally operable to: if being absent from completing the file of full backup, then performs extremely exit or report to the police.
Preferably, described recovery module, including: time judging unit, it is used for judging whether current time is described setting time point；Full backup unit, if for described current time for setting time point, then carries out full backup operation backed off after random based on the nearest file completing full backup.
Preferably, described recovery module, also include the second startup judging unit, be used for: if described current time is not described setting time point, then further determine whether to start full backup operation；Described full backup unit, if starting full backup operation, then carries out full backup operation backed off after random based on the nearest file completing full backup.
Preferably, described recovery module, including BACKUP TIME comparing unit and incremental backup unit: described second judge module, if not starting full backup operation, then checking and whether there is the file having completed incremental backup under the second backup directory；Described BACKUP TIME comparing unit, if for there is the file having completed incremental backup, then whether the BACKUP TIME having completed the file of incremental backup described in judging again is later than the BACKUP TIME of the described nearest file completing full backup；Described incremental backup unit, if be later than the BACKUP TIME of the described nearest file completing full backup for the BACKUP TIME of the described file having completed incremental backup, then the up-to-date file completing incremental backup based on the described nearest file completing full backup with based on the described nearest file completing full backup carries out increment restoring operation.
Present invention also offers a kind of server, it includes according to automatic backup device mentioned above.
Present invention also offers a kind of server, it includes automatic reduction device mentioned above.
Adopting technique scheme, the present invention at least has following effect:
Automated back-up for MySQL database provided by the invention and automatic reduction method, solve magnanimity server batch and dispose MySQL database backup and reduction strategy and the work of automated back-up reduction, save server maintenance cost, improve the work efficiency of server.
Accompanying drawing explanation
Fig. 1 is the flow chart of the automatic backup method of first embodiment of the invention；
Fig. 2 is the flow chart of the automatic backup method of second embodiment of the invention, the 3rd embodiment, the 4th embodiment and the 5th embodiment；
Fig. 3 is the flow chart of the automatic reduction method of sixth embodiment of the invention；
Fig. 4 is the flow chart of the automatic reduction method of seventh embodiment of the invention, the 8th embodiment, the 9th embodiment and the tenth embodiment；
Fig. 5 is the block diagram of the automatic backup device of eleventh embodiment of the invention；
Fig. 6 is the block diagram of the automatic reduction device of sixteenth embodiment of the invention；
Fig. 7 is the block diagram of the server of 21st embodiment of the invention；
Fig. 8 is the block diagram of the server of 22nd embodiment of the invention.
Detailed description of the invention
For further setting forth that the present invention reaches technological means and effect that predetermined purpose is taked, below in conjunction with accompanying drawing and preferred embodiment, the present invention is described in detail as after.
It should be noted that, about the installation order of automated back-up with the script of automatic reduction and all software kits of dependence or software kit in the application, all packing is placed in file server, when needs deployment of new services device, will decompress after file bag telecopy to destination server, perform install order, the automatic of file bag can be realized install, operating in a key, quick for installation, and when artificial direct copying script is to destination server, only need to change a small amount of parameter.
It addition, adopt ssh agreement to send backup file to far-end when carrying out automated back-up, and scp agreement is adopted to communicate when carrying out automatic reduction.
Automated back-up for MySQL database provided by the invention and automatic reduction method, it is possible to improve the work efficiency of magnanimity server, reduce the maintenance cost of server.The automated back-up of the present invention and automatic reduction method and each step thereof will be described in detail belows.
First embodiment
As it is shown in figure 1, the automatic backup method for MySQL database in the present embodiment, including step S10: judge whether there is the file having completed full backup under the first backup directory；And step S20: if there is the file having completed full backup, then according to whether current time is set time point, perform corresponding backup operation.Xtrabackup backup tool can be adopted to perform corresponding backup, Xtrabackup backup tool can the backup operation of fulfillment database and restoring operation, particularly realize the automated back-up scheme of the MySQL database of magnanimity server.
The work of automated back-up is by timed task, for instance cron timed task drives, S10: judge whether there is the file having completed full backup under backup directory；If there is the file having completed full backup, then according to whether current time is set time point, namely, the full backup time point of equipment in the script of Xtrabackup backup tool, perform corresponding backup operation, it is therefore an objective to ensure that MySQL database data after the machine of delaying are not lost or seldom lose to greatest extent.Wherein the language of script is Shell script, and this script is flexible, during manual intervention, it is not necessary to change script, it is only necessary to whether script brings parameter into when performing.
Second embodiment
As shown in Figure 2, on the basis of first embodiment, step S10: judge whether exist after the file having completed full backup under the first backup directory, the automatic backup method of the present embodiment, also include: if being absent from completing the file of full backup, then perform step S201: carry out full backup operation backed off after random.
Wherein, the judgement having completed the file of full backup is to look under backup directory whether have the file having completed full backup accordingly.
3rd embodiment
As shown in Figure 2, on the basis of first embodiment and the second embodiment, step S20: according to whether current time is set time point, perform corresponding backup operation, specifically include: if current time is for setting time point, then perform step S201: carry out full backup operation backed off after random based on the nearest file completing full backup.
4th embodiment
As shown in Figure 2, on the basis of the 3rd embodiment, in step S20: according to whether current time is set time point, perform corresponding backup operation, the automatic backup method of the present embodiment, specifically include: if current time is not for setting time point, then perform step S202 further: judge whether to start full backup operation；If startup full backup operation, then perform step S201: carry out full backup operation backed off after random based on the nearest file completing full backup.
5th embodiment
As shown in Figure 2, on the basis of the 4th embodiment, in step S202: after judging whether to start full backup operation, the automatic backup method of the present embodiment, also include: if not starting full backup operation, then perform step S203: carry out incremental backup operations backed off after random based on the nearest file completing full backup.
Sixth embodiment
As it is shown on figure 3, the automatic reduction method for MySQL database of the present embodiment, including step S30: judge whether there is the file having completed full backup under the second backup directory；And step S40: if there is the file having completed full backup, then according to whether current time is set time point, perform corresponding restoring operation.
Xtrabackup backup tool can be adopted to perform corresponding restoring operation.The automatic reduction method of the present embodiment, it is achieved the automatic reduction of the MySQL database of magnanimity server, reduces data on up-to-date line, facilitates developer to carry out inspection and the debugging of data on line.
The work of automatic reduction is by timed task, for instance cron timed task starts, and according to the setting time point carrying out full backup arranged in the script of Xtrabackup backup tool and current time relation, performs corresponding restoring operation.
7th embodiment
As shown in Figure 4, on the basis of sixth embodiment, step S30: judge whether exist after the file having completed full backup under the second backup directory, the automatic reduction method of the present embodiment, also include: if being absent from completing the file of full backup, then perform step S407: extremely exit or report to the police.
8th embodiment
As shown in Figure 4, on the basis of sixth embodiment and the 7th embodiment, step S40: according to whether current time is set time point, perform corresponding restoring operation, specifically include: step S401: judge whether current time is set time point；If current time is for setting time point, then perform step S404: carry out full backup operation backed off after random based on the nearest file completing full backup.
9th embodiment
As shown in Figure 4, on the basis of the 8th embodiment, in step S40: according to whether current time is set time point, perform corresponding restoring operation, the automatic reduction method of the present embodiment, specifically include: if current time is not for setting time point, then perform step S402 further: judge to start full backup operation；If starting full backup operation, then perform step S404: carry out full backup operation backed off after random based on the nearest file completing full backup.
Tenth embodiment
As shown in Figure 4, on the basis of the 9th embodiment, in step S402: after judging whether to start full backup operation, the automatic reduction method of the present embodiment, also include: if not starting full backup operation, then check and whether whether there is the file having completed incremental backup under the second backup directory；If there is the file having completed incremental backup, then perform step S405 again: whether the BACKUP TIME judging to have completed the file of incremental backup is later than the BACKUP TIME of the nearest file completing full backup；If the BACKUP TIME having completed the file of incremental backup is later than the BACKUP TIME of the nearest file completing full backup, then perform step S406: carry out the up-to-date file completing incremental backup based on the nearest file completing full backup with based on the nearest file completing full backup and carry out increment restoring operation.
It addition, as shown in Figure 4, as preferably, on the basis of the present embodiment, step S403 determines the file being absent from completing incremental backup, perform step S407: extremely exit/report to the police, and record the daily record of this exception stream.
In addition, as shown in Figure 4, on the basis of the present embodiment, step S405 judges the BACKUP TIME having completed the file of the incremental backup BACKUP TIME early than the nearest file completing full backup, then perform step S407: extremely exit/report to the police, and record the daily record of this exception stream.
11st embodiment
As it is shown in figure 5, the automatic backup device for MySQL database of the present embodiment, including the first judge module 10 and backup module 20, wherein the first judge module, it is used for: judge under the first backup directory, whether there is the file having completed full backup；Backup module 20, is used for: if there is the file having completed full backup, then according to whether current time is set time point, perform corresponding backup operation.The automatic backup device of the present embodiment, it is possible in unattended situation, carries out automated back-up, it is not necessary to manual intervention, work efficiency is substantially improved.
12nd embodiment
As it is shown in figure 5, on the basis of the 11st embodiment, the backup module 20 of the present embodiment, it is additionally operable to: if being absent from completing the file of full backup, then carry out full backup operation backed off after random.
13rd embodiment
On the basis of the 11st embodiment and the 12nd embodiment, backup module 20 in the automatic backup device of the present embodiment, specifically for: if current time is for setting time point, then carry out full backup operation backed off after random based on the nearest file completing full backup.
14th embodiment
On the basis of the 13rd embodiment, the backup module in the automatic backup device of the present embodiment includes the first startup judging unit, is used for: if current time is not for setting time point, then further determine whether to start full backup operation；Full backup unit, if for starting full backup operation, then carrying out full backup operation backed off after random based on the nearest file completing full backup.
15th embodiment
On the basis of the 14th embodiment, backup module 20 in the automatic backup device of the present embodiment, also include incremental backup unit, be used for: start judging unit first, it may be judged whether after starting full backup operation；If not starting full backup operation, then carry out incremental backup operations backed off after random based on the nearest file completing full backup.
16th embodiment
As shown in Figure 6, the automatic reduction device for MySQL database of the present embodiment, including the second judge module 30 and recovery module 40, wherein the second judge module 30, it is used for: judge under the second backup directory, whether there is the file having completed full backup.Recovery module 40, if for there is the file having completed full backup, then according to whether current time is set time point, performs corresponding restoring operation.
17th embodiment
As shown in Figure 6, on the basis of the 16th embodiment, the recovery module 40 of the present embodiment, it is additionally operable to: if being absent from completing the file of full backup, then performs extremely exit or report to the police.
18th embodiment
On the basis of the 16th embodiment and the 17th embodiment, the recovery module 40 in the automatic reduction device of the present embodiment, including time judging unit, it is used for judging whether current time is set time point；Full backup unit, if for current time for setting time point, then carries out full backup operation backed off after random based on the nearest file completing full backup.
19th embodiment
On the basis of the 18th embodiment, the recovery module in the automatic reduction device of the present embodiment, also include the second startup judging unit, be used for: if current time is not for setting time point, then further determine whether to start full backup operation；Described full backup unit, if starting full backup operation, then carries out full backup operation backed off after random based on the nearest file completing full backup.
20th embodiment
On the basis of the 19th embodiment, recovery module in the automatic reduction device of the present embodiment, also includes BACKUP TIME comparing unit and incremental backup unit, the second judge module, if not starting full backup operation, then checking and whether there is the file having completed incremental backup under the second backup directory；BACKUP TIME comparing unit, if for there is the file having completed incremental backup, then whether the BACKUP TIME having completed the file of incremental backup described in judging again is later than the BACKUP TIME of the described nearest file completing full backup；Incremental backup unit, if be later than the BACKUP TIME of the described nearest file completing full backup for the BACKUP TIME of the described file having completed incremental backup, then the up-to-date file completing incremental backup based on the described nearest file completing full backup with based on the described nearest file completing full backup carries out increment restoring operation.
It addition, as preferably, on the basis of the present embodiment, recovery module 40, it is additionally operable to: when determining the file being absent from completing incremental backup, performs extremely to exit/report to the police, and record the daily record of this exception stream.
In addition, on the basis of the present embodiment, recovery module 40, it is additionally operable to: judge the BACKUP TIME completing the file of the incremental backup BACKUP TIME early than the nearest file completing full backup, then perform extremely to exit/report to the police, and record the daily record of this exception stream.
21st embodiment
It addition, as it is shown in fig. 7, the present embodiment provide server, including according to automatic backup device 1 mentioned above.
22nd embodiment
Additionally, as shown in Figure 8, the server that the present embodiment provides, including according to automatic reduction device 2 mentioned above.
By the explanation of detailed description of the invention, it should can be reach technological means that predetermined purpose takes and effect is able to more deeply and concrete understanding to the present invention, however appended diagram be only to provide with reference to and purposes of discussion, be not used for the present invention is any limitation as.
Claims (22)
1. the automatic backup method for MySQL database, it is characterised in that comprise the following steps:
Judge under the first backup directory, whether there is the file having completed full backup；
If there is the file having completed full backup, then according to whether current time is set time point, perform corresponding backup operation.
2. automatic backup method according to claim 1, it is characterised in that described judge whether exist after the file having completed full backup under the first backup directory, described method, also include:
If being absent from completing the file of full backup, then carry out full backup operation backed off after random.
3. automatic backup method according to claim 1, it is characterised in that described according to whether current time is set time point, performs corresponding backup operation, specifically includes:
If described current time is described setting time point, then based on nearest complete full backup carry out full backup operation backed off after random.
4. automatic backup method according to claim 3, it is characterised in that described according to whether current time is set time point, performs corresponding backup operation, specifically includes:
If described current time is not described setting time point, then further determine whether to start full backup operation；
If startup full backup operation, then carry out full backup operation backed off after random based on the nearest file completing full backup.
5. automatic backup method according to claim 4, it is characterised in that described in judge whether to start after full backup operation, described method, also include:
If not starting full backup operation, then carry out incremental backup operations backed off after random based on the described nearest file completing full backup.
6. the automatic reduction method for MySQL database, it is characterised in that comprise the following steps:
Judge under the second backup directory, whether there is the file having completed full backup；
If there is the file having completed full backup, then according to whether current time is set time point, perform corresponding restoring operation.
7. automatic reduction method according to claim 6, it is characterised in that described judge whether exist after the file having completed full backup under the second backup directory, described method, also include:
If being absent from completing the file of full backup, then perform extremely exit or report to the police.
8. automatic reduction method according to claim 7, it is characterised in that described according to whether current time is set time point, performs corresponding restoring operation, specifically includes:
Judge whether current time is described setting time point；
If described current time is for setting time point, then carry out full backup operation backed off after random based on the nearest file completing full backup.
9. automatic reduction method according to claim 8, it is characterised in that described according to whether current time is set time point, performs corresponding restoring operation, specifically includes:
If described current time is not described setting time point, then further determine whether to start full backup operation；
If starting full backup operation, then carry out full backup operation backed off after random based on the nearest file completing full backup.
10. automatic reduction method according to claim 9, it is characterised in that described in judge whether start full backup operation after, described method, also include:
If not starting full backup operation, then check and under the second backup directory, whether there is the file having completed incremental backup；
If there is the file having completed incremental backup, then whether the BACKUP TIME having completed the file of incremental backup described in judging again is later than the BACKUP TIME of the described nearest file completing full backup；
If the BACKUP TIME of the described file having completed incremental backup is later than the BACKUP TIME of the described nearest file completing full backup, then the up-to-date file completing incremental backup based on the described nearest file completing full backup with based on the described nearest file completing full backup carries out increment restoring operation.
11. the automatic backup device for MySQL database, it is characterised in that including:
First judge module, for judging whether there is the file having completed full backup under the first backup directory；
Backup module, if for there is the file having completed full backup, then according to whether current time is set time point, performs corresponding backup operation.
12. automatic reduction device according to claim 11, it is characterised in that described backup module, it is additionally operable to:
If being absent from completing the file of full backup, then carry out full backup operation backed off after random.
13. automatic reduction device according to claim 11, it is characterised in that described backup module, specifically for:
If described current time is described setting time point, then carry out full backup operation backed off after random based on the nearest file completing full backup.
14. automatic reduction device according to claim 13, it is characterised in that described backup module includes:
First starts judging unit, if not being described setting time point for described current time, then further determines whether to start full backup operation；
Full backup unit, if for starting full backup operation, then carrying out full backup operation backed off after random based on the nearest file completing full backup.
15. automatic backup device according to claim 14, it is characterised in that described backup module, including incremental backup unit, it is used for:
Judging unit is started, it may be judged whether after starting full backup operation described first；
If not starting full backup operation, then carry out incremental backup operations backed off after random based on the described nearest file completing full backup.
16. the automatic reduction device for MySQL database, it is characterised in that including:
Second judge module, for judging whether there is the file having completed full backup under the second backup directory；
Recovery module, if for there is the file having completed full backup, then according to whether current time is set time point, performs corresponding restoring operation.
17. automatic reduction device according to claim 16, it is characterised in that described recovery module, it is additionally operable to:
If being absent from completing the file of full backup, then perform extremely exit or report to the police.
18. automatic reduction device according to claim 17, it is characterised in that described recovery module, including:
Time judging unit, is used for judging whether current time is described setting time point；
Full backup unit, if for described current time for setting time point, then carries out full backup operation backed off after random based on the nearest file completing full backup.
19. automatic reduction device according to claim 18, it is characterised in that described recovery module, also include the second startup judging unit, be used for:
If described current time is not described setting time point, then further determine whether to start full backup operation；
Described full backup unit, if starting full backup operation, then carries out full backup operation backed off after random based on the nearest file completing full backup.
20. automatic reduction device according to claim 19, it is characterised in that described recovery module, including BACKUP TIME comparing unit and incremental backup unit:
Described second judge module, if not starting full backup operation, then checking and whether there is the file having completed incremental backup under the second backup directory；
Described BACKUP TIME comparing unit, if for there is the file having completed incremental backup, then whether the BACKUP TIME having completed the file of incremental backup described in judging again is later than the BACKUP TIME of the described nearest file completing full backup；
Described incremental backup unit, if be later than the BACKUP TIME of the described nearest file completing full backup for the BACKUP TIME of the described file having completed incremental backup, then the up-to-date file completing incremental backup based on the described nearest file completing full backup with based on the described nearest file completing full backup carries out increment restoring operation.
21. a server, it is characterised in that include the automatic backup device according to any one of claim 11 to 15.
22. a server, it is characterised in that include the automatic reduction device according to any one of claim 16 to 20.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610066727.9A CN105740101A (en) | 2016-01-29 | 2016-01-29 | Automatic backup and automatic restoration method and apparatus for MySQL database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610066727.9A CN105740101A (en) | 2016-01-29 | 2016-01-29 | Automatic backup and automatic restoration method and apparatus for MySQL database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105740101A true CN105740101A (en) | 2016-07-06 |
Family
ID=56248064
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610066727.9A Pending CN105740101A (en) | 2016-01-29 | 2016-01-29 | Automatic backup and automatic restoration method and apparatus for MySQL database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105740101A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106227621A (en) * | 2016-07-25 | 2016-12-14 | 北京飞杰信息技术有限公司 | The data back up method of logic-based volume management simplification volume and system |
| CN109254875A (en) * | 2018-09-05 | 2019-01-22 | 宁波纵横信息技术有限公司 | A kind of back-up device and process of the software and hardware combining for MS-sql database |
| CN110750461A (en) * | 2019-10-28 | 2020-02-04 | 美核电气（济南）股份有限公司 | Nuclear power plant software alarm system based on high-speed serial communication |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1614566A (en) * | 2004-11-29 | 2005-05-11 | 中兴通讯股份有限公司 | Back-up restoring method for user database |
| CN101067818A (en) * | 2007-06-06 | 2007-11-07 | 中国工商银行股份有限公司 | Data incremental backup and recovery method applied to data bank |
| CN101256528A (en) * | 2008-03-20 | 2008-09-03 | 中国科学院计算技术研究所 | Magnetic disk data backup system and method supporting nought backup window |
| CN101477485A (en) * | 2009-01-15 | 2009-07-08 | 中山大学 | MySQL database remote backup and reduction method based on ASP.net |
| CN101739313A (en) * | 2009-11-27 | 2010-06-16 | 华中科技大学 | Method for protecting and restoring continuous data |
| CN102541940A (en) * | 2010-12-31 | 2012-07-04 | 上海可鲁***软件有限公司 | Method for controlling data integrity of industrial database |
| CN103942121A (en) * | 2014-04-04 | 2014-07-23 | 上海斐讯数据通信技术有限公司 | Data recovery system and mobile terminal |
| CN104714858A (en) * | 2013-12-13 | 2015-06-17 | ***通信集团公司 | Data backup method, data recovery method and device |
-
2016
- 2016-01-29 CN CN201610066727.9A patent/CN105740101A/en active Pending
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1614566A (en) * | 2004-11-29 | 2005-05-11 | 中兴通讯股份有限公司 | Back-up restoring method for user database |
| CN101067818A (en) * | 2007-06-06 | 2007-11-07 | 中国工商银行股份有限公司 | Data incremental backup and recovery method applied to data bank |
| CN101256528A (en) * | 2008-03-20 | 2008-09-03 | 中国科学院计算技术研究所 | Magnetic disk data backup system and method supporting nought backup window |
| CN101477485A (en) * | 2009-01-15 | 2009-07-08 | 中山大学 | MySQL database remote backup and reduction method based on ASP.net |
| CN101739313A (en) * | 2009-11-27 | 2010-06-16 | 华中科技大学 | Method for protecting and restoring continuous data |
| CN102541940A (en) * | 2010-12-31 | 2012-07-04 | 上海可鲁***软件有限公司 | Method for controlling data integrity of industrial database |
| CN104714858A (en) * | 2013-12-13 | 2015-06-17 | ***通信集团公司 | Data backup method, data recovery method and device |
| CN103942121A (en) * | 2014-04-04 | 2014-07-23 | 上海斐讯数据通信技术有限公司 | Data recovery system and mobile terminal |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106227621A (en) * | 2016-07-25 | 2016-12-14 | 北京飞杰信息技术有限公司 | The data back up method of logic-based volume management simplification volume and system |
| CN106227621B (en) * | 2016-07-25 | 2019-03-01 | 北京飞杰信息技术有限公司 | The data back up method and system of logic-based volume management simplification volume |
| CN109254875A (en) * | 2018-09-05 | 2019-01-22 | 宁波纵横信息技术有限公司 | A kind of back-up device and process of the software and hardware combining for MS-sql database |
| CN109254875B (en) * | 2018-09-05 | 2020-12-01 | 宁波纵横信息技术有限公司 | Software and hardware combined backup device and process for MS-sql database |
| CN110750461A (en) * | 2019-10-28 | 2020-02-04 | 美核电气（济南）股份有限公司 | Nuclear power plant software alarm system based on high-speed serial communication |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7185335B2 (en) | Programmatic application installation diagnosis and cleaning | |
| CN105487980B (en) | The method and device that repairing applications are operating abnormally | |
| CN103428333B (en) | Mobile terminal, server and errors repair method | |
| CN105740101A (en) | Automatic backup and automatic restoration method and apparatus for MySQL database | |
| CN104572422A (en) | Memory monitoring achievement method based on startup and shutdown of Linux system | |
| CN109032838B (en) | Automatic verification method for consistency of backup and recovery data of virtual machine | |
| CN102346673A (en) | Method and device for upgrading mobile phone system | |
| US7555751B1 (en) | Method and system for performing a live system upgrade | |
| CN102779094A (en) | Terminal and software exception test method | |
| CN103559126A (en) | Method, device and computer terminal for testing software versions | |
| CN109543417B (en) | Vulnerability mining method and device based on Qemu platform | |
| CN103488562A (en) | Automated testing method and device | |
| CN102902563A (en) | Linux operating system and method for mounting file system in starting process of Linux operating system | |
| CN109324918A (en) | Application program exception handling method and device, terminal and storage medium | |
| CN106598774A (en) | Virtual machine backup restoring method and apparatus | |
| CN105354102B (en) | A kind of method and apparatus of file system maintenance and reparation | |
| CN109688427A (en) | A kind of smart television and its system repair | |
| CN106603289B (en) | LMT configuration file smooth upgrading method | |
| CN108763005B (en) | Memory ECC fault error reporting method and system | |
| CN110990289A (en) | Method and device for automatically submitting bug, electronic equipment and storage medium | |
| CN114020509A (en) | Method, device and equipment for repairing work load cluster and readable storage medium | |
| CN107480061B (en) | Automatic regression testing method for constructing change module based on Jenkins CI | |
| CN109766207A (en) | Restoration methods, device, monitoring device and the storage medium of firmware remote upgrade | |
| CN105653408A (en) | Test method for POWER CYCLE startup and shutdown based on BMC IPMITOOL command single-node batch control | |
| CN104346239A (en) | Method and device for recovering anomaly of application program in embedded system |
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 |
Application publication date: 20160706 |
|
| RJ01 | Rejection of invention patent application after publication |