Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method for recovering whole MySQL database

A recovery method and database technology, applied in the field of recovery of the entire database of MySQL database, to achieve the effect of increasing the probability of successful recovery

Active Publication Date: 2018-09-21
SICHUAN QIAODUOTIANGONG PRECISION EQUIP CO LTD
View PDF10 Cites 12 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] 1. It needs to be restored when the backup file, log file or table structure definition file is complete. Once the file is missing or damaged, nothing can be done;
[0004] 2. Can only be restored for a specific MySQL engine;
[0005] 3. For the recovery of MySQL compressed data, it seems that there is more than enough energy;
[0006] 4. In many cases, only a fixed table can be restored

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method for recovering whole MySQL database
  • Method for recovering whole MySQL database
  • Method for recovering whole MySQL database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0051] The present invention will be further elaborated below in conjunction with the accompanying drawings and embodiments. Such as figure 1 Shown, method of the present invention comprises the following steps:

[0052] S100: Carve MySQL database files: scan the disk, search for file features and obtain table data files and table structure files with the file features, reorganize the files according to the data page number and table space identifier, and save the table definition file, wherein the File features include table structure file features and table data file features, including such as figure 2 The following steps are shown:

[0053] S101: scan the disk and look for table structure file features and table data file features;

[0054] In this embodiment, the feature of the table structure file is 0xfe01.

[0055] For table data file characteristics, it is divided into the following situations:

[0056] Features of table data files whose engine type is InnoDB: I...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a method for recovering a whole MySQL database. The method is characterized by comprising the following steps that S100, a MySQL database file is carved, wherein a magnetic disk is scanned, file features are searched for, a table data file and a table structure file with the file features are obtained, the files are reconstructed according to the serial number of a data page and a table space identifier, and a table definition file is saved; S200, the database file is correlated, wherein the carved MySQL database file and the engine type of the MySQL database are matched, and the table structure file is correlated with the corresponding table data file; S300, a table structure is recovered, wherein whether the table data file is correlated with the corresponding table structure file or not is judged, if yes, S400 is executed, and otherwise, the table structure is recovered according to the engine type; S400, the database file is recovered.

Description

technical field [0001] The invention belongs to the field of data recovery, and in particular relates to a method for recovering the entire database of a MySQL database. Background technique [0002] With the advent of the information age, the management and application of data are inseparable from the database. As a free and open source database, MySQL is loved by many people. In the process of using MySQL, it is inevitable that misoperation, man-made malicious damage, software and hardware failures and other reasons will cause damage to the database and loss of important data. At this time, it is very important to restore the MySQL database and retrieve important data. At present, the recovery scheme in the prior art is to recover by the mode of database backup and log, and some recovery schemes at a deeper level are to utilize file carving technology to restore the database from the disk, but these methods all face the following defects: [0003] 1. It needs to be rest...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F11/14G06F17/30
CPCG06F11/1448
Inventor 梁效宁许超明张强
Owner SICHUAN QIAODUOTIANGONG PRECISION EQUIP CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com