本文主要向大家介绍了【云计算】dataxmysql2mysqlmysql导入mysql，通过具体的内容向大家展现，希望对大家学习云计算有所帮助。

datax mysql2mysql mysql导入mysql

mysql2mysql .json

注意事项：

1、reader过程url有[]，writer过程没有[]

2、在执行之前writer过程的表已经创建好

3、严格按照格式书写

4、注意主机名、数据库名、用户名、密码不要写错

{
    "job": {
        "content": [
            {
                  "reader": {
                    "name": "mysqlreader",
                    "parameter": {
                        "column": ["id","name"],
                        "connection": [
                            {
                                "jdbcUrl": ["jdbc:mysql://localhost:3306/test1useUnicode=true&characterEncoding=utf8&yearIsDateType=false&zeroDateTimeBehavior=convertToNull&tinyInt1isBit=false&rewriteBatchedStatements=true"],
                                "table": ["student"]
                            }
                        ],
                        "password": "****",
                        "username": "****",
                        
                    }
                },
                "writer": {
                    "name": "mysqlwriter",
                    "parameter": {
                           "column": ["id","name"],
                        "connection": [
                            {
                                
                                "jdbcUrl": "jdbc:mysql://localhost/test",
                                "table": ["student"]
                            }
                        ],
                        "password": "****",
                        "username": "****",
                    }
                }
            }
        ],
        "setting": {
            "speed": {
                "channel": 1
            }
        }
    }
}

本文由职坐标整理并发布，希望对同学们有所帮助。了解更多详情请关注职坐标大数据云计算大数据安全频道！