编辑job文件job.json
{
"job":{
"setting":{
"channel":2,
"byte":10485760
}
},
"content":[
{
"reader":{
"name":"mysqlreader",
"parameter":{
"username":"yourusername",
"password":"yourpassword",
"column":["*"],
"connection":[{
"jdbcUrl":["jdbc:mysql://192.168.0.100:3306/databasename?useSSL=false"],
"table":["your_table_name"]
}]
}
},
"writer":{
"name":"txtfilewriter",
"parameter":{
"fileName": "output.csv",
"path":"/root/",
"writeMode":"truncate"
}
}
}
]
}
"writeMode":"truncate"会覆盖文件
执行python /file/to/path/datax.py job.json