Ask Your Question
1

How to read mysql binlog DDL log

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

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

Comments

is any one here?

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

1 Answer

Sort by ยป oldest newest most voted
1

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

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

Comments

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 -0500 )edit

Not at present. MySQL does not make this easy.

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

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

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

Question Tools

1 follower

Stats

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

Seen: 213 times

Last updated: May 17