阿里Datax,mysqltomysqljob.json模板

文件名testjob.json，格式要符合json规范，最好写完之后用工具格式化一下看看对不对

{
    "job": {
        "content": [
            {
                "reader": {
                    "name": "mysqlreader", 
                    "parameter": {
                        "column": ["id","name","age"], 
                        "connection": [
                            {
                                "jdbcUrl": ["jdbc:mysql://xxx.xxx.xxx.xxx:3306/数据库名?useUnicode=true&characterEncoding=utf8"], 
                                "table": ["表名"]
                            }
                        ], 
                        "password": "数据库密码", 
                        "username": "数据库用户名", 
                        "where": ""
                    }
                }, 
                "writer": {
                    "name": "mysqlwriter", 
                    "parameter": {
                        "column": ["id","name","age"], 
                        "connection": [
                            {
                                "jdbcUrl": "jdbc:mysql://xxx.xxx.xxx.xxx:3306/数据库名?useUnicode=true&characterEncoding=utf8", 
                                "table": ["表名"]
                            }
                        ], 
                        "password": "数据库密码", 
                        "preSql": [], 
                        "session": [], 
                        "username": "数据库用户名", 
                        "writeMode": "insert（这里可以选择写入模式）"
                    }
                }
            }
        ], 
        "setting": {
            "speed": {
                "channel": "50"
            }
        }
    }
}

执行命令：

[root@localhost datax]# bin/datax.py   job/testjob.json