世界上并没有完美的程序,但是我们并不因此而沮丧,因为写程序就是一个不断追求完美的过程。
下载:
https://github.com/alibaba/DataX
环境:
JDK 1.8
python 2.6.x
解压配置:job -> mysql.json 从mysql中获取数据并存入到txt文件中
{
"job": {
"setting": {
"speed": {
"channel":1
}
},
"content": [
{
"reader": {
"name": "mysqlreader",
"parameter": {
"username": "root",
"password": "root",
"connection": [
{
"querySql": [
"select ID from user;"
],
"jdbcUrl": [
"jdbc:mysql://127.0.0.1:3306/test"
]
}
]
}
},
"writer": {
"name": "txtfilewriter",
"parameter": {
"path": "/home/houbw_bak/datax/datax/",
"fileName": "mysqlwt.txt",
"writeMode": "truncate",
"dateFormat": "yyyy-MM-dd"
}
}
}
]
}
}
运行:
datax.py ../job/mysql.json