HOP_CONFIG_FOLDER ,定义了 Apache Hop 存储所有配置信息的根目录。环境变量不配置,默认是hop的安装目录。
./hop-conf.sh --projects-list
mydumper -h 11.22.33.44 -u root -P3307 -p pAssw0rd -B myschema -t 4 -o myschema_dump/
myloader -h <cluster_dns_endpoint> -u master -p pAssw0rd -P 3307 -B myschema -t 4 -d myschema_dump
# vim my.load
LOAD DATABASE
FROM mysql://root:[email protected]:3307/demo_db?useSSL=false
INTO postgresql://postgres:123123@@[email protected]:5432/postgres?demo_db
with prefetch rows = 500
WITH include drop, create tables, create indexes, workers = 1, concurrency = 1
;
# 运行