datax 从mysql导入到mysql

datax 从mysql导入到mysql

 

mysql2mysql .json

注意事项：

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

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

3、严格按照格式书写

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

对人工智能感兴趣的同学，可以点击以下链接：

现在人工智能非常火爆，很多朋友都想学，但是一般的教程都是为博硕生准备的，太难看懂了。最近发现了一个非常适合小白入门的教程，不仅通俗易懂而且还很风趣幽默。所以忍不住分享一下给大家。点这里可以跳转到教程。

https://www.cbedai.net/u014646662

{
    "job": {
        "content": [
            {
                  "reader": {
                    "name": "mysqlreader",
                    "parameter": {
                        "column": ["id","name"],
                        "connection": [
                            {
                                "jdbcUrl": ["jdbc:mysql://localhost:3306/test1?useUnicode=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
            }
        }
    }
}

DataX3.0安装过程：https://blog.youkuaiyun.com/u014646662/article/details/82748055

DataX3.0 Oracle导入Oracle：https://blog.youkuaiyun.com/u014646662/article/details/82777966

DataX3.0 MySQL导入MySQL：https://blog.youkuaiyun.com/u014646662/article/details/82778067

DataX3.0源离线同步工具介绍: https://blog.youkuaiyun.com/u014646662/article/details/82792725