mysql数据文件解析_Mysql Binlog 文件读取解析

Maven 配置

com.github.shyiko

mysql-binlog-connector-java

0.13.0

Java文件import com.github.shyiko.mysql.binlog.BinaryLogFileReader;

import com.github.shyiko.mysql.binlog.event.Event;

import com.github.shyiko.mysql.binlog.event.deserialization.ChecksumType;

import com.github.shyiko.mysql.binlog.event.deserialization.EventDeserializer;

import java.io.File;

import java.io.IOException;

class Sample {

public static void main(String[] args) throws IOException {

String filePath="D:\\DATA\\mysql-bin.000987";

File binlogFile = new File(filePath);

EventDeserializer eventDeserializer = new EventDeserializer();

eventDeserializer.setChecksumType(ChecksumType.CRC32);

BinaryLogFileReader reader = new BinaryLogFileReader(binlogFile, eventDeserializer);

try {

for (Ev