数据环境
- DataX安装环境:win10
- 源数据库:云主机,MySQL8.0.18
- 目标数据库:云主机,MySQL8.0.18
软件环境
- DataX需求环境(参见dataX官网):
- JDK(1.8以上,推荐1.8)
- Python(推荐Python2.6.X)
- Apache Maven 3.x (Compile DataX)
配置源库和目标库
- 切换到datax的安装目录
cd F:\datax
- 查看配置文件模板命令
python bin/datax.py -r mysqlreader -w mysqlwriter
模板如下:
DataX (DATAX-OPENSOURCE-3.0), From Alibaba !
Copyright (C) 2010-2017, Alibaba Group. All Rights Reserved.
Please refer to the mysqlreader document:
https://github.com/alibaba/DataX/blob/master/mysqlreader/doc/mysqlreader.md
Please refer to the mysqlwriter document:
https://github.com/alibaba/DataX/blob/master/mysqlwriter/doc/mysqlwriter.md
Please save the following configuration as a json file and use
python {
DATAX_HOME}/bin/datax.py {
JSON_FILE_NAME}.json
to run the job.
{
"job": {
"content": [
{
"reader":