本截主要讲解通过datax将一个mysql库中表的数据同步到另外一个库的表中
编写自定义配置文件mysql.json(job目录下 也可以放在别的目录)
新创建数据库test1和test2新建表employee
字段为id username(varchar) userid(varchar)
test1数据库
test2数据库
{
"job": {
"content": [
{
"reader": {
"name": "mysqlreader",
"parameter": {
"column": ["id","username","userid"],
"connection": [
{
"jdbcUrl": ["jdbc:mysql://localhost:3306/test1?useUnicode=true&characterEncoding=utf8&yearIsDateType=false&zeroDateTimeBehavior=convertToNull&tinyInt1isBit=false&rewriteBatchedStatements=true"],
"table": ["employee"]
}
],
"password": "****",
"username": "****",
}
},
"writer": {
"name": "mysqlwriter",
"parameter": {
"column": ["id","username","userid"],
"connection": [
{
"jdbcUrl": "jdbc:mysql://localhost:3306/test2?characterEncoding=utf8",
"table": ["employee"]
}
],
"password": "****",
"username": "****",
}
}
}
],
"setting": {
"speed": {
"channel": 1
}
}
}
}
执行之后的结果
发现数据传过去了但是中文乱码
数据库中的数据中文乱码解决:在json文件中jdbcUrl项加上:?characterEncoding=utf8
最终结果