The invention relates to the technical field of databases, in particular to a MySQL binary log incremental
recovery import failure position quick positioning method, which comprises the following steps of: 1, executing a flush-logs command in a
target database server to generate a target end latest binary log file, in the conversion process, the line boundary of the event and the relative sequence of endlogpos and CRC32
checksum are kept unchanged; step 2, scanning the binary log
text file of the target end line by line by adopting a co-occurrence
detector, and determining an endlogpos value analyzed in the co-occurrence of the source end in the stable
pairing as a final
recovery breakpoint position; and step 3, the controller generates an increment
recovery parameter according to the final recovery
breakpoint position, and if the import is successful, the recovery
breakpoint position and the
common line number mapping of the source end and the target end are recorded. According to the method, the
automation degree and accuracy of incremental recovery are remarkably improved, and
data loss or repeated import caused by inaccurate breakpoint positioning is reduced.