Details
-
Bug
-
Status: Needs Feedback (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
mariadb10.2.22
Description
/apps/svr/mariadb10/bin/mysqlbinlog -vv --base64-output='decode-rows' mysql-bin.181053 > /apps/tmp/tmp_mysql-bin.181053.sql
When parsing the binlog, I cannot see all the data.
I've seen many explanations saying that mysqlbinlog lacks metadata and therefore can't parse it properly. But I want to parse the complete binlog. What should I do? Please help me.
version: mariadb10.2.22 ,and Master-slave replication is working properly.
### INSERT INTO `testdb`.`student`
|
### SET
|
### @1=1411470544 /* LONGINT meta=0 nullable=0 is_null=0 */ |
### @2='testxxx' /* VARSTRING(150) meta=150 nullable=1 is_null=0 */ |
### @3=NULL /* VARSTRING(150) meta=150 nullable=1 is_null=1 */ |
### @4=1154396009 /* TIMESTAMP meta=0 nullable=1 is_null=0 */ |
### @5='' /* VARSTRING(150) meta=150 nullable=1 is_null=0 */ |
### @6=NULL /* VARSTRING(150) meta=150 nullable=1 is_null=1 */ |
### @7=NULL /* VARSTRING(150) meta=150 nullable=1 is_null=1 */ |
### @8=1761607680 /* TIMESTAMP meta=0 nullable=1 is_null=0 */ |
### @10=12598 /* LONGINT meta=0 nullable=1 is_null=0 */ |
### @11='' /* VARSTRING(384) meta=384 nullable=0 is_null=0 */ |
### @12='' /* VARSTRING(120) meta=120 nullable=0 is_null=0 */ |
### @13='' /* VARSTRING(384) meta=384 nullable=0 is_null=0 */ |
### @14='' /* VARSTRING(900) meta=900 nullable=1 is_null=0 */ |
### @15='' /* VARSTRING(54) meta=54 nullable=0 is_null=0 */ |
### @16=51306800.00 /* DECIMAL(10,2) meta=2562 nullable=1 is_null=0 */ |
### @17=NULL /* VARSTRING(30) meta=30 nullable=1 is_null=1 */ |
### @18='' /* VARSTRING(384) meta=384 nullable=1 is_null=0 */ |
### @19=***Corrupted replication event was detected. Not printing the value*** |