Get Events of a particular table

[NAYAN KHANNA]

How can I use BinLogStreamReader to extract logs of just a single table of a database? Also, to have the file running in the terminal and printing realtime the newer changes until it is manually closed. Please let me know how can I achieve these.

Thanks in Advance

[Harshad Ambekar]

For your first question, I believe you can setup a configuration by passing your table(s)

stream = BinLogStreamReader(connection_settings= MYSQL_SETTINGS,

server_id=1,

blocking=True,

resume_stream=True,

only_schemas="123",

only_tables="employee"