linux安装datax

1.创建文件夹，存放安装包

cd /opt

mkdir datax

cd datax/

2.下载安装包

wget http://datax-opensource.oss-cn-hangzhou.aliyuncs.com/datax.tar.gz

3.解压到指定目录

tar -zxvf datax.tar.gz -C /opt/datax

4.修改/job/job.json文件

{
  "job":{
    "content":[
      {
        "reader":{
          "parameter":{
            "password":"root",
            "connection":[
              {
                "querySql":[
                  "SELECT * FROM user"
                ],
                "jdbcUrl":[
                  "jdbc:mysql://ip:端口号/库名"
                ]
              }
            ],
            "username":"root"
          },
          "name":"mysqlreader"
        },
        "writer":{
          "parameter":{
            "password":"root",
            "session":[
              "set session sql_mode='ANSI';"
            ],
            "column":[
              "*"
            ],
            "connection":[
              {
                "jdbcUrl":"jdbc:mysql://ip:端口号/库名",
                "table":[
                  "user1"
                ]
              }
            ],
            "writeMode":"insert",
            "username":"root",
            "preSql":[
              "truncate table user1"
            ]
          },
          "name":"mysqlwriter"
        }
      }
    ],
    "setting":{
      "errorLimit":{
        "record":10,
        "percentage":0.01
      },
      "speed":{
        "channel":1
      }
    }
  }
}

5.删除隐藏文件 (重要)

​​rm -rf /opt/datax/plugin/*/._*​​

6.添加mysql 8 的jar包

7.运行

python datax.py /opt/datax/job/dataxjob1.json