has anyone face the issues with Mysql that it shown this

tap-mysql    |     sync_non_binlog_streams(mysql_conn, non_binlog_catalog, state)
tap-mysql    |   File "/Users/lee.pham/Documents/test-tech/elt-stack/meltano_project_2/demo-project_2/.meltano/extractors/tap-mysql/venv/lib/python3.9/site-packages/tap_mysql/__init__.py", line 325, in sync_non_binlog_streams
tap-mysql    |     raise Exception("only INCREMENTAL, LOG_BASED, and FULL TABLE replication methods are supported")
tap-mysql    | Exception: only INCREMENTAL, LOG_BASED, and FULL TABLE replication methods are supported

This is my meltano yml, i really struggle with this for a few days and don;t really know what should I do more

- name: tap-mysql
    variant: transferwise
    pip_url: pipelinewise-tap-mysql
    config:
      host: localhost
      port: 3306
      user: root
      database: forTesting
      export_batch_rows: 1000
      session_sqls:
      - SET @@session.wait_timeout=28800
      - SET @@session.net_read_timeout=3600
      - SET @@session.innodb_lock_wait_timeout=3600
      - SET @@session.time_zone='+0:00'
    select:
    - forTesting-data_csv.*
    metadata:
      '*' :
        replication_method: FULL_TABLE

One way to check is to look at the catalog that's generated.

meltano invoke --dump=catalog tap-mysql > castalog.json

Check your streams, are they actually set to FULL_TABLE?

Hi @ly_pham! I think the right key is

replication-method

(with a hyphen)

thanks guys, it worked. Not sure why this weren’t before. I think i did try

replication-method

. I did try to

meltano install

again helped this time.