DataX

https://github.com/alibaba/DataX

配置json文件
目标：本地mysql://localhost/table2
来源：本地mysql://localhost/table1

cmd python \datax\bin\datax.py \datax\job\test.json

{
    "job": {
        "content": [
            {
                "reader": {
                    "name": "mysqlreader",
                    "parameter": {
                        "username":"root",
                        "password":"******",
                        "column" : [
                                "id",
                                "name"
                            ],
                        "connection":[
                            {

                                "table":[
                                    "table1"
                                ],
                                "jdbcUrl":[
                                    "jdbc:mysql://localhost/testdb?characterEncoding=utf8"
                                ]
                            }
                        ]

                    }
                },
                "writer": {
                    "name": "mysqlwriter",
                    "parameter": {
                        "username":"root",
                        "password":"******",
                        "column":[
                            "id",
                            "name"
                        ],
                        "connection":[
                            {
                                "table":[
                                    "table2"
                                ],
                                "jdbcUrl":"jdbc:mysql://localhost/testdb?characterEncoding=utf8"
                            }
                        ]
                    }
                }
            }
        ],
            "setting": {
            "speed": {
                "channel": 1,
                "byte": 104857600
            },
            "errorLimit": {
                "record": 10,
                "percentage": 0.05
            }
        }
    },
}

mysql-connector-java-8.0.24:
https://dev.mysql.com/downloads/connector/j/?os=26

一开始出现错误基本上是因为jdbcUrl的问题，dataX默认的connector版本替换成适用于mysql8.0版本的jdbc就可以了
替换位置:
\datax\plugin\reader\mysqlreader\libs
\datax\plugin\reader\mysqlwriter\libs

参考：https://www.cnblogs.com/Aduorisk/p/12408559.html