Ask Your Question

How to read mysql binlog DDL log

asked 2019-04-11 05:37:44 -0600

gavin gravatar image

i`m try to use MySQL Binary Log to syn data change to PostgreSQL( include insert , update ,delete , create, alter , drop), but in preview , only (insert , delete ,update ) will create records in pipeline, why ? how can i read DDL records in pipeline?

edit retag flag offensive close merge delete


is any one here?

gavin gravatar imagegavin ( 2019-04-21 20:16:53 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted

answered 2019-04-21 22:05:49 -0600

metadaddy gravatar image

The documentation for the MySQL Binary Log origin states:

The origin creates records for the INSERT, UPDATE, and DELETE operations.

The origin does not create records for DDL operations.

edit flag offensive delete link more


thanks for your replay , Is there such a origin ? can create records for DDL and DML

gavin gravatar imagegavin ( 2019-05-17 00:16:03 -0600 )edit

Not at present. MySQL does not make this easy.

metadaddy gravatar imagemetadaddy ( 2019-05-17 10:34:20 -0600 )edit

Many thanks, i need to find another solution to my problem.

gavin gravatar imagegavin ( 2019-05-20 20:16:02 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-04-11 05:37:44 -0600

Seen: 429 times

Last updated: May 17 '19