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

# description #

MySQL Binlog Digger is a binlog mining and analysis tool based on graphical interface, which can provide undo sql rollback statement for data recovery. It is installation-free and can analyze online binlog and offline binlog. After selecting online binlog (or even analyzing the latest log) or offline binlog log The database, table, binlog start time, binlog end time, redo type of misoperation (redo sql, undo sql or all), redo sql keyword, display type (redo, undo or all) can be precisely filtered to get the redo sql redo statement or undo sql rollback statement we need. In addition, we can also copy or save the resulting redo sql or undo sql as a sql file. Through undo sql information, when there is a misoperation. You can quickly restore the business system data to a normal state.

# version update instructions #

1. Some unnecessary data are filtered in mining and analysis.

two。 Database names, table names, and field names are enclosed in reverse quotation marks (`) to avoid the exception of the generated statement during execution.

3. Added processing of mysql keywords such as INSERT INTO, DELETE FROM, UPDATE, WHERE, AND, SET, VALUES, etc.

4. Cancel undo sql manual sorting and use the default descending sort

5. Put the original insert into tab select col1, col2... Change to standard SQL:insert into tab (col1,col2...) Values (val1, val2...)

6. Fix null value exception

# instructions #

one。 Objective:

Mysql binlog log mining analysis, through the generation of redo statements (redo sql) and rollback statements (undo sql) for accurate rollback, to find mistakenly deleted, mistakenly added, mistakenly modified data.

two。 Note:

After the misoperation, if the table structure changes (for example, field ordering, field renaming), the accuracy of redo sql and undo sql will be greatly reduced.

three。 The main functions are divided into two categories:

Online mining analysis and offline mining analysis, online mining analysis binlog process requires a certain database management account.

four。 Use steps of online mining analysis

1. Enter the hostname or IP address, port, account number and password respectively, and then test the database connection.

two。 After testing the database connection, you can filter the database, table, start binlog, end binlog, latest binlog, start time, end time, keyword (sql), sql operation type (insert | delete | update | all) and display type (redo | undo | all).

3. After setting the filter conditions, set whether online analysis to 'Yes',' and mining analysis can be carried out.

4. The redo sql returned by mining analysis is sorted by default in ascending order of time, and cannot be sorted manually, while the undo sql returned by mining analysis is sorted in descending order by default, and its sequence number corresponds to the serial number of redo sql one by one, and manual sorting cannot be carried out either.

5. You can choose to copy or copy all of the mined redo sql and undo sql, and you can also choose to save or save all sql text files.

five。 Use steps of offline mining and analysis

1. There is no need for database online connection testing.

two。 Set whether to analyze online to 'No'.

3. However, you can filter the database, table, start binlog, end binlog, latest binlog, start time, end time, keyword (sql), sql operation type (insert | delete | update | all) and display type (redo | undo | all).

4. Once the filter conditions are set, mining analysis can be carried out.

5. The redo sql returned by mining analysis is sorted by default in ascending order of time, and cannot be sorted manually, while the undo sql returned by mining analysis is sorted in descending order by default, and its sequence number corresponds to the serial number of redo sql one by one, and manual sorting cannot be carried out either.

6. You can choose to copy or copy all of the mined redo sql and undo sql, and you can also choose to save or save all sql text files.

Download address:

Link: https://pan.baidu.com/s/1ryxj1ka_16e2fwCgmL9JKA

Extraction code: riih

Reverse boat data studio

2019-12-05

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.