How to handle the changing binary log file in mysql database to keep up with the same state_id ? When the binary log file is expired how to handle the same state pick up the new binary log file and continue to load into from the previous state. I am using tap-mysql db.

You could use

meltano state

to update the value to the new binary log file: 1.

meltano state get <state_id> > state.json

2. edit

state.json

3.

meltano state set <state_id> --input-file state.json