CN110908840A - Method, device, equipment and storage medium for restoring bak backup files - Google Patents

Method, device, equipment and storage medium for restoring bak backup files Download PDF

Info

Publication number
CN110908840A
CN110908840A CN201911214439.3A CN201911214439A CN110908840A CN 110908840 A CN110908840 A CN 110908840A CN 201911214439 A CN201911214439 A CN 201911214439A CN 110908840 A CN110908840 A CN 110908840A
Authority
CN
China
Prior art keywords
bak
backup file
restoring
database name
bak backup
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
Application number
CN201911214439.3A
Other languages
Chinese (zh)
Inventor
冯豪龙
范渊
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
DBAPPSecurity Co Ltd
Hangzhou Dbappsecurity Technology Co Ltd
Original Assignee
Hangzhou Dbappsecurity Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Hangzhou Dbappsecurity Technology Co Ltd filed Critical Hangzhou Dbappsecurity Technology Co Ltd
Priority to CN201911214439.3A priority Critical patent/CN110908840A/en
Publication of CN110908840A publication Critical patent/CN110908840A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/07Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/14Error detection or correction of the data by redundancy in operation
    • G06F11/1402Saving, restoring, recovering or retrying
    • G06F11/1446Point-in-time backing up or restoration of persistent data
    • G06F11/1458Management of the backup or restore process
    • G06F11/1469Backup restoration techniques
    • GPHYSICS
    • G06COMPUTING; CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/242Query formulation
    • G06F16/2433Query languages

Abstract

The invention discloses a method, a device, equipment and a computer readable storage medium for restoring bak backup files, which are applied to web application developed by adopting a spring boot frame and comprise the following steps: the SQLServer is connected through JDBCtemplate, a bak file to be restored is imported, and the bak file is stored to a fixed directory; the SQL for obtaining the database name is spelled according to the bak file, the SQL is executed, and the database name corresponding to the bak file is obtained; after the database name is successfully acquired, spelling the recovery SQL of the recovery bak file according to the database name and the bak file; and executing the reduction SQL, reducing the bak file to the SQLServer, and inquiring and displaying the reduced data through JDBCtemplate. The method, the device, the equipment and the computer readable storage medium provided by the invention can be used in a cross-platform manner, and are simple to operate and high in reduction efficiency.

Description

Method, device, equipment and storage medium for restoring bak backup files
Technical Field
The present invention relates to the field of web application technologies, and in particular, to a method, an apparatus, a device, and a computer-readable storage medium for restoring bak backup files.
Background
In the development process of the level protection work, when the system information is evaluated, some evaluation organization companies adopt an evaluation little-power tool to backup and store the evaluation condition of the system information in the form of a bak backup file, when a network police records the evaluation, the network police cannot know the specific content of the bak file and cannot store the unsatisfied searching and displaying data in the form of a file, so that the bak files need to be restored on a security platform or other platforms.
Existing bak file reduction is mostly under the windows system, through visual tools, manual one-step reduction according to tool operation instructions is needed, cross-platform reduction is not supported, files cannot be processed in batches, when data are checked, an operator needs to perform sql inquiry by himself, and difficulty and complexity are high.
In summary, it can be seen that how to provide a bak backup file restoration method that can be used across platforms, is simple to operate, and has high efficiency is a problem to be solved at present.
Disclosure of Invention
The invention aims to provide a method, a device, equipment and a computer readable storage medium for restoring bak backup files, so as to solve the problems that the bak backup file restoring method in the prior art cannot be used across platforms, is complex in operation and low in efficiency.
In order to solve the above technical problem, the present invention provides a method for restoring bak backup files, which is applied to a web application developed by using a spring boot frame, and includes: after the SQL Server is connected through JDBC Template, introducing a bak backup file to be restored, and storing the bak backup file to a preset fixed directory; spelling an SQL command for acquiring a database name according to the bak backup file, executing the SQL command for acquiring the database name, and acquiring the database name corresponding to the bak backup file; judging whether the database name is successfully acquired or not; if the database name is successfully acquired, spelling and acquiring a restore SQL command for restoring the bak backup file according to the database name and the bak backup file; and executing the SQL restoring command, restoring the data of the bak backup file to the SQL Server, and inquiring and displaying the data obtained after restoring the bak backup file through JDBC Template.
Preferably, the importing the bak backup file to be restored and storing the bak backup file in a preset fixed directory includes:
uploading a bak backup file to be restored by adopting a multipartFile class, and storing the bak backup file to a preset fixed directory through an io stream.
Preferably, the executing the SQL command for obtaining the database name, and obtaining the database name corresponding to the bak backup file includes:
and executing the SQL command for acquiring the database name by a queryForList method of JDBC Template, and acquiring the database name corresponding to the bak backup file.
Preferably, the executing the restore SQL command comprises:
and executing the restore SQL command by an execute method so as to restore the bak backup file.
Preferably, the determining whether the database name is successfully acquired includes:
if the database name is not successfully acquired, the bak backup file is judged to be wrong or damaged, the restoring operation of the bak backup file is terminated, and the next bak backup file to be restored is imported.
The invention also provides a device for restoring the bak backup file, which is applied to the web application developed by adopting the spring boot frame and comprises the following steps:
the system comprises an importing module, a database module and a database module, wherein the importing module is used for importing a bak backup file to be restored after being connected with an SQL Server through JDBC Template and storing the bak backup file to a preset fixed directory;
the execution module is used for spelling the SQL command for acquiring the database name according to the bak backup file, executing the SQL command for acquiring the database name and acquiring the database name corresponding to the bak backup file;
the judging module is used for judging whether the database name is successfully acquired or not;
the spelling module is used for spelling a recovery SQL command for obtaining the recovery bak backup file according to the database name and the bak backup file if the database name is successfully obtained;
and the restoring module is used for executing the SQL restoring command, restoring the data of the bak backup file to the SQLServer, and inquiring and displaying the data obtained after restoring the bak backup file through JDBC Template.
Preferably, the importing module includes:
the system comprises an uploading unit, a restoring unit and a restoring unit, wherein the uploading unit is used for uploading bak backup files to be restored by adopting a multipartFile class;
and the storage unit is used for storing the bak backup file to a preset fixed directory through an io stream.
Preferably, the determining module includes:
and the judging module is used for judging that the bak backup file is wrong or damaged if the database name is not successfully acquired, terminating the restoration operation of the bak backup file and importing the next bak backup file to be restored.
The invention also provides a device for restoring the bak backup file, which comprises:
a memory for storing a computer program; and the processor is used for realizing the steps of the method for restoring the bak backup file when executing the computer program.
The present invention also provides a computer readable storage medium having stored thereon a computer program which, when executed by a processor, implements the steps of a method of restoring bak backed-up files as described above.
The method for restoring the bak backup file provided by the invention is applied to the web application developed by adopting a spring boot frame. After the web project is started, the JDBC Template is connected with the SQL Server, the bak backup file to be restored is imported, and the bak backup file is stored in a preset fixed directory. And spelling an executable SQL command for acquiring the database name according to the bak backup file, executing the SQL command for acquiring the database name, and acquiring the database name corresponding to the bak backup file as the database name of data storage. Judging whether the database name is successfully acquired; if the database name is successfully acquired, executing an SQL (structured query language) restoring command according to the database name and the SQL command of spelling the bak backup file to restore the bak backup file, storing the data obtained after restoring the bak backup file to an SQL Server, and inquiring and displaying the restored data according to actual needs by a JDBCtemplate correlation method. The method provided by the invention is applied to the technical field of web application, can be deployed and used in a cross-platform manner, is simple in reduction operation and high in efficiency, and can automatically reduce the uploaded files; the restored data can be displayed by accessing a browser page.
Drawings
In order to more clearly illustrate the embodiments or technical solutions of the present invention, the drawings used in the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art that other drawings can be obtained based on these drawings without creative efforts.
FIG. 1 is a flowchart illustrating a first embodiment of a method for restoring bak backed-up files according to the present invention;
FIG. 2 is a flowchart illustrating a second embodiment of a method for restoring bak backed-up files according to the present invention;
fig. 3 is a block diagram of a device for restoring bak backup files according to an embodiment of the present invention.
Detailed Description
The core of the invention is to provide a method, a device, equipment and a computer readable storage medium for restoring bak backup files, which can be deployed and used across platforms, and have simple operation and high restoring efficiency.
In order that those skilled in the art will better understand the disclosure, the invention will be described in further detail with reference to the accompanying drawings and specific embodiments. It is to be understood that the described embodiments are merely exemplary of the invention, and not restrictive of the full scope of the invention. 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.
Referring to fig. 1, fig. 1 is a flowchart illustrating a method for restoring bak backed-up files according to a first embodiment of the present invention. The method provided by the embodiment specifically comprises the following operation steps:
step S101: after the SQL Server is connected through JDBC Template, introducing a bak backup file to be restored, and storing the bak backup file to a preset fixed directory;
step S102: spelling an SQL command for acquiring a database name according to the bak backup file, executing the SQL command for acquiring the database name, and acquiring the database name corresponding to the bak backup file;
step S103: judging whether the database name is successfully acquired or not;
step S104: if the database name is successfully acquired, spelling and acquiring a restore SQL command for restoring the bak backup file according to the database name and the bak backup file;
step S105: and executing the SQL restoration command, restoring the data of the bak backup file to the SQLServer, and inquiring and displaying the data obtained after restoring the bak backup file through JDBC Template.
The bak backup file restoration method provided by this embodiment may further perform a batch restoration operation of the bak backup files. When a plurality of bak backup files are restored, the bak files are sequentially imported and are respectively stored to a preset path directory. And respectively traversing each bak backup file in the path directory, and executing the step S102 to the step S105 to realize the restoration operation of the plurality of bak backup files. The restored data can be displayed by accessing a browser page, all data can be displayed by default, and query can be expanded according to requirements.
The method provided by the embodiment provides a bak backup file restoration method which can be deployed and used across platforms and is simple to operate, and meanwhile, the restoration efficiency of the bak backup file is improved; the method solves the problems that the bak file restoration method in the prior art can not be used across platforms, can not process files in batches, is complex to operate and has low restoration efficiency.
Based on the above embodiments, in this embodiment, SQL Server2017 is used to store data, JDBCTemplate is used as a connection database framework, and a spring boot framework is used to develop web applications. When the database name related to the bak backup file to be restored cannot be successfully acquired, it can be determined that the bak backup file to be restored is wrong or damaged, and another bak backup file to be restored needs to be imported for restoration.
Referring to fig. 2, fig. 2 is a flowchart illustrating a method for restoring bak backed-up files according to a first embodiment of the present invention. The method provided by the embodiment specifically comprises the following operation steps:
step S201: after the JDBC Template is connected with the SQL Server2017, uploading a bak backup file to be restored by adopting a multipartFile class, and storing the bak backup file to a preset fixed directory through an io stream;
after the web application is started, uploading the bak backup file through a browser, wherein the bak backup file can be uploaded by a MultipartFile type in the embodiment; and then storing the uploaded bak backup file in a path directory set by a project through an io stream, such as in a Linux environment: root/bak/.
When a plurality of bak backup files need to be restored, the bak backup files can be sequentially uploaded to a preset fixed directory.
Step S202: obtaining an SQL command of the database name according to the spelling of the bak backup file;
step S203: executing the SQL command for acquiring the database name by a queryForList method of JDBC Template, and acquiring the database name corresponding to the bak backup file;
and starting a Web project, connecting JdbcTemplate with a database, and executing an organized sql command to acquire a database name related to the bak backup file as a library name of data storage by using a queryfORList method.
Step S204: judging whether the database name is successfully acquired or not;
step S205: if the database name is not successfully acquired, judging that the bak backup file is wrong or damaged, terminating the restore operation of the bak backup file, and importing the next bak backup file to be restored;
step S206: if the database name is successfully acquired, spelling and acquiring a restore SQL command for restoring the bak backup file according to the database name and the bak backup file;
step S207: executing the SQL restoring command by an execute method, and restoring the data of the bak backup file to the SQL Server 2017;
when restoring the plurality of bak backup files, the preset path directory may be traversed, and the steps S202 to S207 may be sequentially performed to restore each bak backup file.
Step S208: and querying and displaying data obtained after restoring the bak backup file through JDBC Template.
And after the bak backup file is restored, storing the data obtained after restoration into an SQL Server2017, and inquiring and displaying the data according to actual requirements by a JDBC Template correlation method.
The method provided by the embodiment is applied to the web application developed by adopting the spring boot frame, can be deployed and used in a cross-platform mode, is simple to operate, can automatically restore the uploaded files, supports batch processing and has high restoration efficiency. For data obtained after the bak backup file is restored, query and display can be realized according to actual needs through a JDBC Template related method. The method provided by the embodiment of the invention can effectively solve the problem of permanent and real-time viewing of bak data of the information evaluation of the grade protection system, and can accurately and quickly find the effective data of the system information and help a network police to judge whether the system evaluation is accurate and effective.
Referring to fig. 3, fig. 3 is a block diagram illustrating a structure of an apparatus for restoring bak backed-up files according to an embodiment of the present invention; the apparatus provided in this embodiment is applied to a web application developed by using a spring boot frame, and may specifically include:
the import module 100 is configured to import a bak backup file to be restored after connecting the SQL Server through JDBC Template, and store the bak backup file in a preset fixed directory;
the execution module 200 is configured to spell an SQL command for obtaining a database name according to the bak backup file, execute the SQL command for obtaining the database name, and obtain the database name corresponding to the bak backup file;
a judging module 300, configured to judge whether the database name is successfully acquired;
a spelling module 400, configured to spell a restore SQL command for obtaining a restore bak backup file according to the database name and the bak backup file if the database name is successfully obtained;
the restoring module 500 is configured to execute the SQL restoring command, restore the data of the bak backup file to the SQLServer, and query and display the data obtained after restoring the bak backup file through JDBC Template.
The apparatus for restoring a bak backup file of this embodiment is configured to implement the foregoing method for restoring a bak backup file, and therefore a specific implementation manner of the apparatus for restoring a bak backup file may be found in the foregoing embodiment portions of the method for restoring a bak backup file, for example, the importing module 100, the executing module 200, the determining module 300, the spelling module 400, and the restoring module 500 are respectively configured to implement steps S101, S102, S103, S104, and S105 in the foregoing method for restoring a bak backup file, and therefore, the specific implementation manner thereof may refer to descriptions of corresponding partial embodiments, and is not described herein again.
The specific embodiment of the present invention further provides an apparatus for restoring bak backup files, including: a memory for storing a computer program; and the processor is used for realizing the steps of the method for restoring the bak backup file when executing the computer program.
The specific embodiment of the present invention further provides a computer-readable storage medium, where a computer program is stored on the computer-readable storage medium, and when the computer program is executed by a processor, the computer program implements the steps of the method for restoring bak backup files.
The embodiments are described in a progressive manner, each embodiment focuses on differences from other embodiments, and the same or similar parts among the embodiments are referred to each other. The device disclosed by the embodiment corresponds to the method disclosed by the embodiment, so that the description is simple, and the relevant points can be referred to the method part for description.
Those of skill would further appreciate that the various illustrative elements and algorithm steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware, computer software, or combinations of both, and that the various illustrative components and steps have been described above generally in terms of their functionality in order to clearly illustrate this interchangeability of hardware and software. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the implementation. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present invention.
The steps of a method or algorithm described in connection with the embodiments disclosed herein may be embodied directly in hardware, in a software module executed by a processor, or in a combination of the two. A software module may reside in Random Access Memory (RAM), memory, Read Only Memory (ROM), electrically programmable ROM, electrically erasable programmable ROM, registers, hard disk, a removable disk, a CD-ROM, or any other form of storage medium known in the art.
The method, apparatus, device and computer readable storage medium for restoring bak backed-up files provided by the present invention are described in detail above. The principles and embodiments of the present invention are explained herein using specific examples, which are presented only to assist in understanding the method and its core concepts. It should be noted that, for those skilled in the art, it is possible to make various improvements and modifications to the present invention without departing from the principle of the present invention, and those improvements and modifications also fall within the scope of the claims of the present invention.

Claims (10)

1. A method for restoring bak backup files is applied to web applications developed by adopting a spring boot frame, and comprises the following steps:
after the SQL Server is connected through JDBC Template, introducing a bak backup file to be restored, and storing the bak backup file to a preset fixed directory;
spelling an SQL command for acquiring a database name according to the bak backup file, executing the SQL command for acquiring the database name, and acquiring the database name corresponding to the bak backup file;
judging whether the database name is successfully acquired or not;
if the database name is successfully acquired, spelling and acquiring a restore SQL command for restoring the bak backup file according to the database name and the bak backup file;
and executing the SQL restoring command, restoring the data of the bak backup file to the SQL Server, and inquiring and displaying the data obtained after restoring the bak backup file through JDBC Template.
2. The method of claim 1, wherein the importing the bak backup file to be restored and storing the bak backup file in a preset fixed directory comprises:
uploading a bak backup file to be restored by adopting a multipartFile class, and storing the bak backup file to a preset fixed directory through an io stream.
3. The method of claim 2, wherein said executing the SQL command to obtain a database name, obtaining a database name corresponding to the bak-backed file comprises:
and executing the SQL command for acquiring the database name by a queryForList method of JDBC Template, and acquiring the database name corresponding to the bak backup file.
4. The method of claim 3, wherein said executing the restore SQL command comprises:
and executing the restore SQL command by an execute method so as to restore the bak backup file.
5. The method of claim 1, wherein said determining whether the database name was successfully obtained comprises:
if the database name is not successfully acquired, the bak backup file is judged to be wrong or damaged, the restoring operation of the bak backup file is terminated, and the next bak backup file to be restored is imported.
6. An apparatus for restoring bak backup files, which is applied to a web application developed by using a spring boot frame, includes:
the system comprises an importing module, a database module and a database module, wherein the importing module is used for importing a bak backup file to be restored after being connected with an SQL Server through JDBC Template and storing the bak backup file to a preset fixed directory;
the execution module is used for spelling the SQL command for acquiring the database name according to the bak backup file, executing the SQL command for acquiring the database name and acquiring the database name corresponding to the bak backup file;
the judging module is used for judging whether the database name is successfully acquired or not;
the spelling module is used for spelling a recovery SQL command for obtaining the recovery bak backup file according to the database name and the bak backup file if the database name is successfully obtained;
and the restoring module is used for executing the SQL restoring command, restoring the data of the bak backup file to an SQL Server, and inquiring and displaying the data obtained after restoring the bak backup file through JDBC Template.
7. The apparatus of claim 6, wherein the import module comprises:
the system comprises an uploading unit, a restoring unit and a restoring unit, wherein the uploading unit is used for uploading bak backup files to be restored by adopting a multipartFile class;
and the storage unit is used for storing the bak backup file to a preset fixed directory through an io stream.
8. The apparatus of claim 6, wherein the determining module comprises:
and the judging module is used for judging that the bak backup file is wrong or damaged if the database name is not successfully acquired, terminating the restoration operation of the bak backup file and importing the next bak backup file to be restored.
9. An apparatus for restoring bak backed files, comprising:
a memory for storing a computer program;
a processor for implementing the steps of a method of restoring bak backed-up files as claimed in any one of claims 1 to 5 when executing said computer program.
10. A computer-readable storage medium, having stored thereon a computer program which, when executed by a processor, performs the steps of a method of restoring bak backed files as claimed in any one of claims 1 to 5.
CN201911214439.3A 2019-12-02 2019-12-02 Method, device, equipment and storage medium for restoring bak backup files Pending CN110908840A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201911214439.3A CN110908840A (en) 2019-12-02 2019-12-02 Method, device, equipment and storage medium for restoring bak backup files

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201911214439.3A CN110908840A (en) 2019-12-02 2019-12-02 Method, device, equipment and storage medium for restoring bak backup files

Publications (1)

Publication Number Publication Date
CN110908840A true CN110908840A (en) 2020-03-24

Family

ID=69821292

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201911214439.3A Pending CN110908840A (en) 2019-12-02 2019-12-02 Method, device, equipment and storage medium for restoring bak backup files

Country Status (1)

Country Link
CN (1) CN110908840A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112732747A (en) * 2021-03-30 2021-04-30 广州嘉为科技有限公司 Method, system, device and medium for quickly executing SQL on target computer

Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103491089A (en) * 2013-09-22 2014-01-01 北京锐安科技有限公司 Transcoding method and system of data recovery based on HTTP
CN103617277A (en) * 2013-12-09 2014-03-05 山东瀚高基础软件股份有限公司 Method for restoring data table content deleted mistakenly
CN105373631A (en) * 2015-12-18 2016-03-02 河南思维自动化设备股份有限公司 SQLSever-based automatic upgrading method for database structure
CN106528830A (en) * 2016-11-16 2017-03-22 华为技术有限公司 Method and device for recovering file index catalogue
US10216580B1 (en) * 2018-03-29 2019-02-26 Model9 Software Ltd. System and method for mainframe computers backup and restore on object storage systems
CN110309021A (en) * 2019-07-10 2019-10-08 合肥盈云信息科技有限公司 A kind of backup of Python database cross platform and restoration methods
CN110515764A (en) * 2019-07-30 2019-11-29 国云科技股份有限公司 A kind of cloud DB Backup and the system and method across cloud recovery

Patent Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103491089A (en) * 2013-09-22 2014-01-01 北京锐安科技有限公司 Transcoding method and system of data recovery based on HTTP
CN103617277A (en) * 2013-12-09 2014-03-05 山东瀚高基础软件股份有限公司 Method for restoring data table content deleted mistakenly
CN105373631A (en) * 2015-12-18 2016-03-02 河南思维自动化设备股份有限公司 SQLSever-based automatic upgrading method for database structure
CN106528830A (en) * 2016-11-16 2017-03-22 华为技术有限公司 Method and device for recovering file index catalogue
US10216580B1 (en) * 2018-03-29 2019-02-26 Model9 Software Ltd. System and method for mainframe computers backup and restore on object storage systems
CN110309021A (en) * 2019-07-10 2019-10-08 合肥盈云信息科技有限公司 A kind of backup of Python database cross platform and restoration methods
CN110515764A (en) * 2019-07-30 2019-11-29 国云科技股份有限公司 A kind of cloud DB Backup and the system and method across cloud recovery

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
油菜花花籽: "SQL SERVER如何恢复bak备份文件", 《百度经验>游戏/数码>电脑>电脑软件,HTTPS://JINGYAN.BAIDU.COM/ARTICLE/363872EC7872FD6E4BA16F18.HTML》 *

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112732747A (en) * 2021-03-30 2021-04-30 广州嘉为科技有限公司 Method, system, device and medium for quickly executing SQL on target computer

Similar Documents

Publication Publication Date Title
RU2565109C2 (en) Method and apparatus for recovering backup database
EP1630674A1 (en) Generating an optimized database restore plan
CN108664359B (en) Database recovery method, device, equipment and storage medium
CN110908840A (en) Method, device, equipment and storage medium for restoring bak backup files
CN109240854B (en) Method and system for recovering data of change caused by misoperation
CN106201570A (en) A kind of application program exempts from installation and operation method and device
CN107179965B (en) Database recovery method and device
WO2019134339A1 (en) Desensitization method and procedure, application server and computer readable storage medium
CN112286733B (en) Method, device and equipment for determining backup data recovery time and storage medium
CN108399125B (en) Automatic testing method and device, computer equipment and storage medium
CN110955562A (en) Data recovery method, system, equipment and readable storage medium
KR20100134355A (en) A method for recovering logical data errors in database
JP4630489B2 (en) Log comparison debugging support apparatus, method and program
US11003538B2 (en) Automatically configuring boot order in recovery operations
CN109246297B (en) Method, device and storage medium for determining factory reset time of mobile terminal
CN108874661B (en) Test mapping relation library generation method and device, computer equipment and storage medium
CN112417240A (en) Website link detection method and device and computer equipment
CN107368569B (en) Data difference comparison method and device, storage medium and processor
CN110807037A (en) Data modification method and device, electronic equipment and storage medium
CN109815083B (en) Application crash monitoring method and device, electronic equipment and medium
CN108241543B (en) Method, service server and system for executing service operation breakpoint
CN108304456B (en) Method and device for determining longitude and latitude of population
CN110659257B (en) Metadata object repairing method, device, equipment and readable storage medium
CN112631905A (en) Execution process data management method and device, computer equipment and storage medium
CN109471650B (en) Upgrading abnormity determining method and device and computer equipment

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