我使用long2ice/synch工具为mysql点击在一个特定的表上复制数据,但是当我运行下面的命令> synch --alias mysql_db etl -h
得到错误
synch——alias mysql_db etl -h usage: synch [-h] [-c CONFIG][——version] {etl,produce,consume}…同步:错误:无效选择:'mysql_db' (select from 'etl', 'produce', 'consume')
如何解决上述错误。
配置文件的原样,下面作为我提到的
db_type: mysql
alias: mysql_db # must be unique
broker_type: redis # current support redis and kafka
server_id: 1
host: 127.0.0.1
port: 3306
user: root
password: "12345"
# optional, auto get from `show master status` when empty
init_binlog_file:
# optional, auto get from `show master status` when empty
init_binlog_pos:
skip_dmls: # dmls to skip
skip_delete_tables: # tables skip delete, format with schema.table
skip_update_tables: # tables skip update, format with schema.table
databases:
- database: test
上面的配置缺少什么
谢谢,
Bimal。
尝试使用以下配置
core:
debug: true
source_dbs:
- db_type: mysql
alias: mysql_db # must be unique
broker_type: redis # current support redis and kafka
server_id: 1
host: 127.0.0.1
port: 3306
user: root
password: "12345"
和运行
synch --alias mysql_db etl