Shulou(Shulou.com)06/01 Report--

Mysql database delete deleted after how to restore data, in order to let you know more about the SQL database, the editor summarized the following, let's look down together. Database environment deployment and failure reasons:

The restored database is installed on the customer's local server, and the server operating system is windows2008 R2. A single instance of mysql5.6 is installed in the current environment, the engine type is innodb, and the tablespace type used for in-table data storage is independent tablespace. No database backup was performed and binlog was not turned on.

The reason for the data loss is that the whole table data is deleted without adding a where clause to filter when using the Delete command to delete the data, and no operation is performed on the table after deletion, which requires data recovery operation that is deleted by mistake from the database level.

Data recovery plan development:

1. Classification of fault types: in this case, the database cannot be directly restored because the production environment is not backed up and the binlog log is not opened, which belongs to the erroneous deletion of mysql-delete data in a typical table.

2. Fault analysis and feasibility scheme formulation: generally speaking, there are three recovery schemes for the loss of records caused by mysql innodb erroneous deletion, which are backup restore, binlog restore and record depth analysis. Because the database in this case is not backed up and binlog is not enabled, that is to say, the first two schemes are not applicable and can only be restored by deep resolution of records. The recovery principle of this recovery scheme is to simulate the record management mode of the innodb engine and parse the binary file into character records according to the table structure information.

Data recovery process:

1. Get the data file: the customer sends the table structure file and the table data file (.ibd) to the data recovery center by means of network transmission, and the data recovery engineer starts to analyze and recover the data after downloading the file.

2. Use the database data recovery tool to scan:

In this data recovery case, the customer provides a database table structure script, which can be restored using the 5room3 function in this tool.

First, read the table structure information:

Start parsing the record:

This tool extracts the records into SQL backup format by default, and restores the results to the database after parsing (key information has been coded to ensure customer privacy):

Customer acceptance data:

After the data extraction is completed, inform the customer to verify the extraction results and count the total number of recovery records. After verification, the customer indicates that the final data recovery result is complete, and the total number of records in the original table is in line with the number of records in the original table.

How to restore the data after Mysql database delete deletion is shared here, of course, not only the above and everyone analysis methods, but the editor can ensure its accuracy is absolutely no problem. I hope that the above content can have a certain reference value for everyone, and can be put into practice. If you like this article, you might as well share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.