CN110895500A - Data backtracking method and device based on mydump and storage medium - Google Patents
Data backtracking method and device based on mydump and storage medium Download PDFInfo
- Publication number
- CN110895500A CN110895500A CN201911127981.5A CN201911127981A CN110895500A CN 110895500 A CN110895500 A CN 110895500A CN 201911127981 A CN201911127981 A CN 201911127981A CN 110895500 A CN110895500 A CN 110895500A
- Authority
- CN
- China
- Prior art keywords
- data
- time point
- return
- returned
- database
- 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
Images
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
Abstract
The invention discloses a data backtracking method and device based on mydumper and a storage medium, wherein the method comprises the following steps: acquiring a target backup data source according to the return information carried by the return application, wherein the data source is data backed up by mydumper; importing the decompressed target backup data source into a new idle instance, recovering incremental data between a first time point and a second time point, and importing the incremental data into the idle instance, wherein the first time point is a backup time point of the target backup data source, and the second time point is a time point to be subjected to back-up; and finally, exporting the decompressed target backup data source and the incremental data from the idle instance to a database to be restored. By adopting the invention, quick return can be realized on the basis of ensuring the safety of return data.
Description
Technical Field
The invention relates to the technical field of data processing, in particular to a data archive returning method and device based on mydumper and a storage medium.
Background
The rollback operation is a rollback operation, and means that data in a database is restored to a certain historical moment, for example, to a moment before data errors occur, when a database user needs to perform data rollback for a certain reason (such as game rollback, data confusion, and the like), based on backup data generated during database backup, the user can restore selected backup data to an affiliated instance by initiating a rollback task. However, in the existing method of returning to the file, the data is restored to a new instance and then backed up and imported into the original database, the process of returning to the file is tedious, and the traditional backup data is based on the whole database, so that the restoration is very slow.
Disclosure of Invention
The embodiment of the invention provides a data file returning method and device based on mydump and a storage medium, which can realize quick file returning on the basis of ensuring the safety of file returning data.
The first aspect of the embodiments of the present invention provides a data rollback method based on mydump, which may include:
acquiring a target backup data source according to the return information carried by the return application, wherein the target backup data source is data backed up by mydumper, and the return information at least comprises an example to be returned, a database name to be returned, a table name to be returned, time to be returned and a reason to be returned;
importing the decompressed target backup data source into a new idle instance, wherein the name of the idle instance is the same as the name of the database to be backuped and the name of the table to be backuped;
restoring incremental data between a first time point and a second time point, and importing the incremental data into the idle instance, wherein the first time point is a backup time point of the target backup data source, and the second time point is the time point to be subjected to the back-up;
and exporting the return data from the idle instance to the database to be returned, wherein the return data comprises the decompressed target backup data source and the incremental data.
Further, in all the backup data sources, the backup time point of the target backup data source is closest to the time point of the to-be-backed-up file.
Further, the recovering incremental data between the first time point and the second time point includes:
analyzing a binlog log on a database server;
and determining incremental data between the two time points according to the specified first time point, the specified second time point and the name of the database to be returned.
Further, the method further comprises:
detecting whether the decompressed target backup data source is successfully imported into the idle instance;
and when the detection result is yes, the step of recovering the incremental data between the first time point and the second time point is carried out.
Further, the method further comprises:
detecting whether the return data in the idle instance is complete;
when the return file data is complete, submitting the review to the upper-level examination and approval;
and after the examination and approval are passed, the step of exporting the return data from the idle instance to the database to be returned is carried out, and the prompt message of successful return is output.
A second aspect of an embodiment of the present invention provides a data rollback device based on mydumper, which may include:
the target data source acquisition module is used for acquiring a target backup data source according to the return information carried by the return application, the target backup data source is data backed up by mydump, and the return information at least comprises a new instance to be returned, a database name to be returned, a table name to be returned, time to be returned and a reason to be returned;
the target data processing module is used for importing the decompressed target backup data source into an idle instance, and the name of the idle instance is the same as the name of the database to be subjected to the file returning and the name of the table to be subjected to the file returning;
an incremental data processing module, configured to restore incremental data between a first time point and a second time point, and import the incremental data into the idle instance, where the first time point is a backup time point of the target backup data source, and the second time point is the time point to be subjected to the back-up;
and the archive return data export module is used for exporting archive return data from the idle instance to the database to be archived, wherein the archive return data comprises the decompressed target backup data source and the incremental data.
Further, in all the backup data sources, the backup time point of the target backup data source is closest to the time point of the to-be-backed-up file.
Further, the incremental data processing module comprises:
the log analysis unit is used for analyzing the binlog log on the database server;
and the incremental data determining unit is used for determining incremental data between the two time points according to the specified first time point, the specified second time point and the name of the database to be subjected to the gear returning.
Further, the apparatus further comprises:
the data detection module is used for detecting whether the decompressed target backup data source is successfully imported into the idle instance;
and the detection jumping module is used for switching to the step of recovering the incremental data between the first time point and the second time point when the detection result is yes.
Further, the apparatus further comprises:
the integrity detection module is used for detecting whether the return data in the idle instance is complete;
the audit submitting module is used for submitting audit to upper-level approval when the return file data is complete;
and the successful return-to-file prompting module is used for transferring to a return-to-file data exporting module to export the return-to-file data from the idle example to the database to be returned after the examination and approval are passed, and outputting successful return-to-file prompting information.
A third aspect of embodiments of the present invention provides a computer device, which includes a processor and a memory, where the memory stores at least one instruction, at least one program, a set of codes, or a set of instructions, and the at least one instruction, the at least one program, the set of codes, or the set of instructions is loaded and executed by the processor to implement the mydumper-based data archive method according to the above aspect.
A fourth aspect of the embodiments of the present invention provides a computer storage medium, where at least one instruction, at least one program, a code set, or a set of instructions is stored in the computer storage medium, and the at least one instruction, the at least one program, the code set, or the set of instructions is loaded and executed by a processor to implement the mydumper-based data archive method according to the above aspect.
In the embodiment of the invention, the safety of the produced data is ensured by recovering the idle instance firstly and then recovering the idle instance to the production (namely, the database to be subjected to the file return), the mydump backup data is utilized, the advantage of generating a file according to each table is combined with the system to realize the fast file return list table, and meanwhile, the flow audit is combined in the data file return process, so that the convenience of the tracing is increased.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
FIG. 1 is a schematic flowchart of a data rollback method based on mydumper according to an embodiment of the present invention;
FIG. 2 is a schematic flow chart of another mydump-based data rollback method according to an embodiment of the present invention;
FIG. 3 is a schematic structural diagram of a mydump-based data rollback device according to an embodiment of the present invention;
FIG. 4 is a schematic structural diagram of an incremental data processing module according to an embodiment of the present invention;
fig. 5 is a schematic structural diagram of a computer device according to an embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The terms "including" and "having," and any variations thereof, in the description and claims of this invention and the above-described drawings are intended to cover non-exclusive inclusions, with the terms "first" and "second," etc., being used for distinguishing between similar designations and not necessarily for indicating the size or order of the numerals. For example, a process, method, system, article, or apparatus that comprises a list of steps or elements is not limited to only those steps or elements listed, but may alternatively include other steps or elements not listed, or inherent to such process, method, article, or apparatus.
In the embodiment of the invention, the data archive returning method based on the mydump can be applied to computer equipment, and the computer equipment can be a computer or a smart phone and can also be other electronic equipment with computing processing capacity.
As shown in FIG. 1, the mydump-based data rollback method may include at least the following steps:
s101, obtaining a target backup data source according to the return information carried by the return application.
It is understood that the user may submit a return application for the database return from the operation and maintenance system, and may submit the following return information in the application page, which may specifically include an instance to be returned (including the database IP and the port information), a name of the database to be returned, a name of a table to be returned, a time to be returned (specifically, it needs to be accurate to seconds, such as 2019-10-1620:12:48), a reason to be returned, and the like. It should be noted that, if full-library archive returning is required, the archive returning information may not include the table name to be archived.
Further, the device may obtain the target backup data source in the backup machine according to the instance to be subjected to the file returning and the time to be subjected to the file returning in the file returning information, and in a specific implementation, the target backup data source may be data backed up by mydumper, so that a single table is conveniently and quickly restored, and a target backup data source closest to the time point to be subjected to the file returning is found.
S102, importing the decompressed target backup data source into an idle instance.
In a specific implementation, the device may decompress the target backup data source and obtain the table data file to be restored, and further, the device may import the decompressed target backup data source into the idle instance. It will be appreciated that the free instance may be a new instance having the same name as the database name to be backed up and the table name to be backed up, ensuring the security of the production data.
S103, recovering the incremental data between the first time point and the second time point, and importing the incremental data into the idle instance.
In specific implementation, the device may detect whether there is an abnormality in a process of decompressing a target backup data source and importing an idle instance, and if there is an abnormality (for example, decompression failure or data import failure), the device may fail to return the file data, and may output a file return failure prompt message; if no anomalies are present, the delta data between the first point in time and the second point in time can be restored.
It should be noted that the first time point is a backup time point of the target backup data source, and the second time point is a time point to be backed up, which is equivalent to that data that has a period of time from the backup time point of the target backup data source to the time point that needs to be backed up is not backed up, and may be referred to as incremental data.
During the process of recovering the incremental data, the device can analyze the added backup log data (namely binlog log which records all database updating operations of the database) on the database server, can analyze the log to the time point before the file return by using mysql official tools, and further can determine the incremental data between the two time points according to the specified first time point, the second time point and the name of the database to be returned. Further, the device may restore the delta data to the database of free instances.
To more clearly illustrate the processing of the incremental data, the following is exemplified:
if the requirement is to archive the T table of the A library back to the point in time of 2019-10-1610: 23:50, the system first finds the backup data source of the A library and finds the backup T table, and if the backup point in time of the T table is 2019-10-1602:12:40, the backup T table data is imported to the new instance. But since it is actually needed to restore to 2019-10-1610: 23:50, the data of this process in the middle needs to be restored from the binlog log of this instance. One tool that mysql authorities provide is the mysql log tool, which can use a specified start parse log for recovery to a specified point in time: mysqlbinglog-start-datetime ═ 2019-10-1602:12:40 "- -stop _ datetime ═ 2019-10-1610: 23: 50"
And S104, exporting the return data from the idle instance to a database to be returned.
In a preferred implementation manner, before exporting the return data (i.e., the decompressed target backup data source and the incremental data) from the idle instance, the device may detect whether the return data in the idle instance is complete, determine that the return fails if the return data is incomplete, and if the return data is complete, initiate an audit process to a superior audit, and output a return success prompt message after the audit is passed, for example, output a prompt message in a mail push manner.
In the embodiment of the invention, the safety of the produced data is ensured by recovering the idle instance firstly and then recovering the idle instance to the production (namely, the database to be subjected to the file return), the mydump backup data is utilized, the advantage of generating a file according to each table is combined with the system to realize the fast file return list table, and meanwhile, the flow audit is combined in the data file return process, so that the convenience of the tracing is increased.
Fig. 2 is a schematic flow chart of another mydump-based data rollback method according to the present application, which specifically includes the following steps:
s201, selecting an example to be subjected to gear returning and time to be subjected to gear returning according to the gear returning information.
S202, a target backup data source is obtained.
S203, decompressing the target backup data source and importing the decompressed data into the idle instance.
S204, detecting whether the decompressed target backup data source is successfully imported into an idle instance.
In a specific implementation, when it is detected that decompression is successful and the idle instance is successfully imported, the step of recovering incremental data in step S205 may be performed, otherwise, the step S210 of outputting a prompt message of a failure of returning to the file may be performed.
S205, the binlog log on the database server is analyzed.
S206, determining incremental data between the two time points according to the specified first time point, the specified second time point and the name of the database to be returned, and importing the incremental data into the idle instance.
S207, detecting whether the gear-returning data in the idle instance is complete.
In a specific implementation, when the data is detected to be complete, the step S208 may be executed to submit the audit to the upper examination and approval, otherwise, the step S210 may be executed.
And S208, submitting the examination to a superior examination and approval.
S209, after the approval is passed, the data of the returned file is led out from the idle example to the database to be returned, and the prompt information of the successful returning file is output.
And S210, outputting a return failure prompt message.
It should be noted that, for specific implementation processes of each step in this embodiment, reference may be made to the description in the foregoing method embodiment, and details are not described here again.
In the embodiment of the invention, the safety of the produced data is ensured by recovering the idle instance firstly and then recovering the idle instance to the production (namely, the database to be subjected to the file return), the mydump backup data is utilized, the advantage of generating a file according to each table is combined with the system to realize the fast file return list table, and meanwhile, the flow audit is combined in the data file return process, so that the convenience of the tracing is increased.
The mydump-based data archive device provided by the embodiment of the invention will be described in detail with reference to fig. 3 and 4. It should be noted that, the data rollback apparatus shown in fig. 3 and 4 is used for executing the method according to the embodiment of the present invention shown in fig. 1 and 2, for convenience of description, only the portion related to the embodiment of the present invention is shown, and details of the specific technology are not disclosed, please refer to the embodiment of the present invention shown in fig. 1 and 2.
Referring to fig. 3, a schematic structural diagram of a data archive device based on mydump is provided in the embodiment of the present invention. As shown in fig. 3, the data rollback apparatus 10 according to the embodiment of the present invention may include: the system comprises a target data source obtaining module 101, a target data processing module 102, an incremental data processing module 103, a return data exporting module 104, a data detecting module 105, a detection jumping module 106, an integrity detecting module 107, an audit submitting module 108 and a return success prompting module 109, wherein the incremental data processing module 103 includes a log analyzing unit 1031 and an incremental data determining unit 1032 as shown in fig. 4.
The target data source obtaining module 101 is configured to obtain a target backup data source according to the return information carried in the return application, where the target backup data source is data backed up by the mydump, and the return information at least includes a new instance to be returned, a name of a database to be returned, a name of a table to be returned, time to be returned, and a reason for returning to the file.
And the target data processing module 102 is configured to import the decompressed target backup data source into an idle instance, where the name of the idle instance is the same as the name of the database to be backuped and the name of the table to be backuped.
The incremental data processing module 103 is configured to restore the incremental data between the first time point and the second time point, and import the incremental data into the idle instance, where the first time point is a backup time point of the target backup data source, and the second time point is a time point to be shifted back.
And the archive return data export module 104 is configured to export archive return data from the idle instance to the database to be archived, where the archive return data includes the decompressed target backup data source and the incremental data.
Preferably, the backup time point of the target backup data source is closest to the time point to be backlogged in all the backup data sources.
In an alternative embodiment, the incremental data processing module 103 comprises:
a log parsing unit 1031, configured to parse the binlog log on the database server.
And the incremental data determining unit 1032 is used for determining incremental data between the two time points according to the specified first time point, the specified second time point and the name of the database to be shifted back.
And the data detection module 105 is configured to detect whether the decompressed target backup data source is successfully imported into the idle instance.
And the detection jumping module 106 is used for switching to the step of recovering the incremental data between the first time point and the second time point when the detection result is yes.
And an integrity detection module 107, configured to detect whether the rollback data in the idle instance is complete.
And the review submitting module 108 is used for submitting the review to the upper-level review and approval when the return file data is complete.
And the successful file return prompting module 109 is used for transferring the file return data to the file return data exporting module to export the file return data from the idle example to the database to be returned after the examination and approval is passed, and outputting the successful file return prompting information.
It should be noted that, the execution process of each module in this embodiment may refer to the description in the foregoing method embodiment, and is not described herein again.
In the embodiment of the invention, the safety of the produced data is ensured by recovering the idle instance firstly and then recovering the idle instance to the production (namely, the database to be subjected to the file return), the mydump backup data is utilized, the advantage of generating a file according to each table is combined with the system to realize the fast file return list table, and meanwhile, the flow audit is combined in the data file return process, so that the convenience of the tracing is increased.
An embodiment of the present invention further provides a computer storage medium, where the computer storage medium may store a plurality of instructions, where the instructions are suitable for being loaded by a processor and executing the method steps in the embodiments shown in fig. 1 and fig. 2, and a specific execution process may refer to specific descriptions of the embodiments shown in fig. 1 and fig. 2, which are not described herein again.
The embodiment of the application also provides computer equipment. As shown in fig. 5, the computer device 20 may include: the at least one processor 201, e.g., CPU, the at least one network interface 204, the user interface 203, the memory 205, the at least one communication bus 202, and optionally, a display 206. Wherein a communication bus 202 is used to enable the connection communication between these components. The user interface 203 may include a touch screen, a keyboard or a mouse, among others. The network interface 204 may optionally include a standard wired interface, a wireless interface (e.g., WI-FI interface), and a communication connection may be established with the server via the network interface 204. The memory 205 may be a high-speed RAM memory or a non-volatile memory (non-volatile memory), such as at least one disk memory, and the memory 205 includes a flash in the embodiment of the present invention. The memory 205 may optionally be at least one memory system located remotely from the processor 201. As shown in fig. 5, memory 205, which is a type of computer storage medium, may include an operating system, a network communication module, a user interface module, and program instructions.
It should be noted that the network interface 204 may be connected to a receiver, a transmitter or other communication module, and the other communication module may include, but is not limited to, a WiFi module, a bluetooth module, etc., and it is understood that the computer device in the embodiment of the present invention may also include a receiver, a transmitter, other communication module, etc.
acquiring a target backup data source according to the return information carried by the return application, wherein the target backup data source is data backed up by mydumper, and the return information at least comprises an example to be returned, a database name to be returned, a table name to be returned, time to be returned and a reason to be returned;
importing the decompressed target backup data source into a new idle instance, wherein the name of the idle instance is the same as the name of the database to be backuped and the name of the table to be backuped;
restoring incremental data between a first time point and a second time point, and importing the incremental data into an idle instance, wherein the first time point is a backup time point of a target backup data source, and the second time point is a time point to be subjected to backuped;
and exporting the return data from the idle instance to a database to be returned, wherein the return data comprises the decompressed target backup data source and the incremental data.
In some embodiments, the backup time point of the target backup data source is closest to the time point to be backlogged among all the backup data sources.
In some embodiments, the apparatus 20, when restoring the incremental data between the first time point and the second time point, is specifically configured to:
analyzing a binlog log on a database server;
and determining incremental data between the two time points according to the specified first time point, the specified second time point and the name of the database to be returned.
In some embodiments, apparatus 20 is further configured to:
detecting whether the decompressed target backup data source is successfully imported into an idle instance;
and when the detection result is yes, the step of recovering the incremental data between the first time point and the second time point is carried out.
In some embodiments, apparatus 20 is further configured to:
detecting whether the return data in the idle instance is complete;
when the return data is complete, submitting the review to the upper-level examination and approval;
and after the examination and approval are passed, the step of exporting the return data from the idle instance to the database to be returned is carried out, and the prompt message of successful return is output.
In the embodiment of the invention, the safety of the produced data is ensured by recovering the idle instance firstly and then recovering the idle instance to the production (namely, the database to be subjected to the file return), the mydump backup data is utilized, the advantage of generating a file according to each table is combined with the system to realize the fast file return list table, and meanwhile, the flow audit is combined in the data file return process, so that the convenience of the tracing is increased.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by a computer program, which can be stored in a computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. The storage medium may be a magnetic disk, an optical disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), or the like.
The above disclosure is only for the purpose of illustrating the preferred embodiments of the present invention, and it is therefore to be understood that the invention is not limited by the scope of the appended claims.
Claims (10)
1. A data archive returning method based on mydumper is characterized by comprising the following steps:
acquiring a target backup data source according to the return information carried by the return application, wherein the target backup data source is data backed up by mydumper, and the return information at least comprises an example to be returned, a database name to be returned, a table name to be returned, time to be returned and a reason to be returned;
importing the decompressed target backup data source into a new idle instance, wherein the name of the idle instance is the same as the name of the database to be backuped and the name of the table to be backuped;
restoring incremental data between a first time point and a second time point, and importing the incremental data into the idle instance, wherein the first time point is a backup time point of the target backup data source, and the second time point is the time point to be subjected to the back-up;
and exporting the return data from the idle instance to the database to be returned, wherein the return data comprises the decompressed target backup data source and the incremental data.
2. The method of claim 1, wherein the backup time point of the target backup data source is closest to the time point of the backlog among all backup data sources.
3. The method of claim 1, wherein recovering incremental data between a first point in time and a second point in time comprises:
analyzing a binlog log on a database server;
and determining incremental data between the two time points according to the specified first time point, the specified second time point and the name of the database to be returned.
4. The method of claim 1, further comprising:
detecting whether the decompressed target backup data source is successfully imported into the idle instance;
and when the detection result is yes, the step of recovering the incremental data between the first time point and the second time point is carried out.
5. The method of claim 1, further comprising:
detecting whether the return data in the idle instance is complete;
when the return file data is complete, submitting the review to the upper-level examination and approval;
and after the examination and approval are passed, the step of exporting the return data from the idle instance to the database to be returned is carried out, and the prompt message of successful return is output.
6. A data device of coming back a file based on mydumper, its characterized in that includes:
the target data source acquisition module is used for acquiring a target backup data source according to the return information carried by the return application, the target backup data source is data backed up by mydump, and the return information at least comprises a new instance to be returned, a database name to be returned, a table name to be returned, time to be returned and a reason to be returned;
the target data processing module is used for importing the decompressed target backup data source into an idle instance, and the name of the idle instance is the same as the name of the database to be subjected to the file returning and the name of the table to be subjected to the file returning;
an incremental data processing module, configured to restore incremental data between a first time point and a second time point, and import the incremental data into the idle instance, where the first time point is a backup time point of the target backup data source, and the second time point is the time point to be subjected to the back-up;
and the archive return data export module is used for exporting archive return data from the idle instance to the database to be archived, wherein the archive return data comprises the decompressed target backup data source and the incremental data.
7. The apparatus of claim 6, wherein the backup time point of the target backup data source is closest to the time point of the backlog among all backup data sources.
8. The apparatus of claim 6, wherein the incremental data processing module comprises:
the log analysis unit is used for analyzing the binlog log on the database server;
and the incremental data determining unit is used for determining incremental data between the two time points according to the specified first time point, the specified second time point and the name of the database to be subjected to the gear returning.
9. The apparatus of claim 6, further comprising:
the data detection module is used for detecting whether the decompressed target backup data source is successfully imported into the idle instance;
and the detection jumping module is used for switching to the step of recovering the incremental data between the first time point and the second time point when the detection result is yes.
10. A computer readable storage medium having stored therein at least one instruction, at least one program, a set of codes, or a set of instructions, which is loaded and executed by a processor to implement the mydumper-based data archive method of any of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911127981.5A CN110895500A (en) | 2019-11-18 | 2019-11-18 | Data backtracking method and device based on mydump and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911127981.5A CN110895500A (en) | 2019-11-18 | 2019-11-18 | Data backtracking method and device based on mydump and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110895500A true CN110895500A (en) | 2020-03-20 |
Family
ID=69786658
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911127981.5A Pending CN110895500A (en) | 2019-11-18 | 2019-11-18 | Data backtracking method and device based on mydump and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110895500A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113094379A (en) * | 2021-03-23 | 2021-07-09 | 杭州电魂网络科技股份有限公司 | Anchor type user data maintenance method, device, equipment and medium |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105843707A (en) * | 2016-03-28 | 2016-08-10 | 上海上讯信息技术股份有限公司 | Quick recovery method and equipment of database |
| CN106126371A (en) * | 2016-06-15 | 2016-11-16 | 腾讯科技（深圳）有限公司 | Data return a grade method, Apparatus and system |
| CN107145403A (en) * | 2017-04-20 | 2017-09-08 | 浙江工业大学 | The relevant database data retrogressive method of web oriented development environment |
| US20170300390A1 (en) * | 2015-01-21 | 2017-10-19 | Commvault Systems, Inc. | Database protection using block-level mapping |
| CN108228390A (en) * | 2018-01-19 | 2018-06-29 | 腾讯科技（深圳）有限公司 | Data return shelves method and device |
| US20180253360A1 (en) * | 2017-03-06 | 2018-09-06 | Dell Products, Lp | Database Failure Recovery in an Information Handling System |
| CN109491834A (en) * | 2018-10-23 | 2019-03-19 | 网宿科技股份有限公司 | A kind of data reconstruction method and device applied to database |
-
2019
- 2019-11-18 CN CN201911127981.5A patent/CN110895500A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20170300390A1 (en) * | 2015-01-21 | 2017-10-19 | Commvault Systems, Inc. | Database protection using block-level mapping |
| CN105843707A (en) * | 2016-03-28 | 2016-08-10 | 上海上讯信息技术股份有限公司 | Quick recovery method and equipment of database |
| CN106126371A (en) * | 2016-06-15 | 2016-11-16 | 腾讯科技（深圳）有限公司 | Data return a grade method, Apparatus and system |
| US20180253360A1 (en) * | 2017-03-06 | 2018-09-06 | Dell Products, Lp | Database Failure Recovery in an Information Handling System |
| CN107145403A (en) * | 2017-04-20 | 2017-09-08 | 浙江工业大学 | The relevant database data retrogressive method of web oriented development environment |
| CN108228390A (en) * | 2018-01-19 | 2018-06-29 | 腾讯科技（深圳）有限公司 | Data return shelves method and device |
| CN109491834A (en) * | 2018-10-23 | 2019-03-19 | 网宿科技股份有限公司 | A kind of data reconstruction method and device applied to database |
Non-Patent Citations (3)
| Title |
|---|
| 丰树谦: "《数据库技术与应用》", 31 May 2017, 电子科技大学出版社 * |
| 谷秀洁: "《开放型机构知识库著作权管理研究》", 31 August 2013, 上海交通大学出版社 * |
| 陈志文等: "《数字出版数据库基础与实训指导》", 31 August 2014, 上海大学出版社 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113094379A (en) * | 2021-03-23 | 2021-07-09 | 杭州电魂网络科技股份有限公司 | Anchor type user data maintenance method, device, equipment and medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| TWI582616B (en) | Formatting data by example | |
| CN111459495B (en) | Unit test code file generation method, electronic device and storage medium | |
| CN103377127A (en) | Development testing system, testing method and device for webpage product | |
| CN110474900B (en) | Game protocol testing method and device | |
| CN110162453B (en) | Test method, test device, computer readable storage medium and computer equipment | |
| CN110647471A (en) | Interface test case generation method, electronic device and storage medium | |
| CN111211929A (en) | Fault positioning method, fault positioning device, control equipment and intelligent equipment | |
| CN111367531A (en) | Code processing method and device | |
| CN111338759A (en) | Virtual disk check code generation method, device, equipment and storage medium | |
| CN110895500A (en) | Data backtracking method and device based on mydump and storage medium | |
| CN110688305A (en) | Test environment synchronization method, device, medium and electronic equipment | |
| CN108196975B (en) | Data verification method and device based on multiple checksums and storage medium | |
| CN109146096B (en) | Processing method and device for repair event, storage medium and electronic equipment | |
| CN108763053B (en) | Method for generating buried point name and terminal equipment | |
| CN110688315A (en) | Interface code detection report generation method, electronic device, and storage medium | |
| CN112286733B (en) | Method, device and equipment for determining backup data recovery time and storage medium | |
| CN115016775A (en) | Interface simulation method and device, storage medium and electronic equipment | |
| CN111786991B (en) | Block chain-based platform authentication login method and related device | |
| CN114911751A (en) | Method, device and equipment for building coal preparation plant management platform and readable storage medium | |
| CN114185805A (en) | Embedded point verification method, device, equipment and storage medium | |
| CN114003497A (en) | Method, device and equipment for testing service system and storage medium | |
| CN110601879B (en) | Method and device for forming Zabbix alarm process information and storage medium | |
| CN110704483A (en) | User routing process positioning method, device, storage medium and device | |
| CN114218079A (en) | Case testing method, device and equipment and readable storage medium | |
| CN115543227B (en) | Cross-system data migration method, system, electronic device and storage medium |
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 | ||
| CB02 | Change of applicant information |
Address after: 200120 Room 308, 3 / F, unit 2, No. 231, Shibo Village Road, China (Shanghai) pilot Free Trade Zone, Pudong New Area, Shanghai Applicant after: Wheel interconnection technology (Shanghai) Co., Ltd Address before: 200125 501, room 5, 3 building, 3601 Dongfang Road, Pudong New Area, Shanghai. Applicant before: SHANGHAI YIDIAN SPACE NETWORK Co.,Ltd. |
|
| CB02 | Change of applicant information | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200320 |
|
| RJ01 | Rejection of invention patent application after publication |