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

This article is about whether the data deleted by navicat can be restored. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

Can the data deleted by navicat be restored?

Data deleted by navicat can be restored. Delete the intrusive data in the database with navicat, resulting in easy deletion, and delete some important data that looks like duplicate data directly in the table (equivalent to the delete from table command). However, the database has not made a backup of these data and has not opened the binary log, so the conventional recovery method has completely come to a dead end.

In the process of solving the problem, the following attempts have been made:

1. Learn that if logging is enabled, mysqlbinlog can use log recovery directly.

two。 If instead of deleting part of a table, but deleting the entire table, you can try to recover it with disk data recovery software immediately after deletion. (because files will be deleted after deleting the table, and some of the data in the table will be deleted, the file still exists)

3. Looking for a data recovery company, which claims to be able to recover with ibdata1, I used a tool to analyze ibdata1, page by page to see if there were any historical records, and finally found that only existing data was stored in the page.

Using ibdata1 to recover data should be an attempt when the database except ibdata1 is damaged and cannot be used normally on the premise of understanding the structure of the data table, rather than deleting the table data and restoring it. (in fact, this file stores existing table data, but it can also be set to one file per table. )

4. Finally found that mysql under the ib_logfile0 and ib_logfile1 two files, in fact, these two files, recorded some things log of Mysql, for transactions roll forward and backward, is the use of Mysql itself, this file opened with a text tool, there are a lot of garbled, but you can find a small amount of data deleted insert records, a very small amount of garbled through the sentence before and after to find the original text, and finally restore the deleted file through the log of things.

Note: several prerequisites are required to recover from the transaction log.

1: know the approximate location of the deleted data, do not look for it here, there are constantly new data inserted there.

2: because there are a lot of garbled codes, it is suitable for finding a small amount of data, rather than for the recovery of a large amount of data, wasting energy.

3: if the binary log is not open and there is no backup, then it can only be restored in this way.

Thank you for reading! About whether the data deleted by navicat can be restored and shared here, I hope the above content can be of some help to you, so that you can learn more knowledge. If you think the article is good, you can share it and let more people see it.

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.