datax 从mysql导入到mysql

朴灿烈づ我的快乐病毒、 2022-05-11 03:56 282阅读 0赞

# datax 从mysql导入到mysql #

mysql2mysql .json

注意事项：

1、reader过程url有\[\]，writer过程没有\[\]

2、在执行之前writer过程的表已经创建好

3、严格按照格式书写

4、注意主机名、数据库名、用户名、密码不要写错

对人工智能感兴趣的同学，可以点击以下链接：

[现在人工智能非常火爆，很多朋友都想学，但是一般的教程都是为博硕生准备的，太难看懂了。最近发现了一个非常适合小白入门的教程，不仅通俗易懂而且还很风趣幽默。所以忍不住分享一下给大家。点这里可以跳转到教程。][Link 1]

[https://www.cbedai.net/u014646662][Link 1]

{
        "job": {
            "content": [
                {
                      "reader": {
                        "name": "mysqlreader",
                        "parameter": {
                            "column": ["id","name"],
                            "connection": [
                                {
                                    "jdbcUrl": ["jdbc:mysql://localhost:3306/test1?useUnicode=true&characterEncoding=utf8&yearIsDateType=false&zeroDateTimeBehavior=convertToNull&tinyInt1isBit=false&rewriteBatchedStatements=true"],
                                    "table": ["student"]
                                }
                            ],
                            "password": "****",
                            "username": "****",
                            
                        }
                    },
                    "writer": {
                        "name": "mysqlwriter",
                        "parameter": {
                               "column": ["id","name"],
                            "connection": [
                                {
                                    
                                    "jdbcUrl": "jdbc:mysql://localhost/test",
                                    "table": ["student"]
                                }
                            ],
                            "password": "****",
                            "username": "****",
                        }
                    }
                }
            ],
            "setting": {
                "speed": {
                    "channel": 1
                }
            }
        }
    }

DataX3.0安装过程：[https://blog.csdn.net/u014646662/article/details/82748055][https_blog.csdn.net_u014646662_article_details_82748055]

DataX3.0 Oracle导入Oracle：[https://blog.csdn.net/u014646662/article/details/82777966 ][https_blog.csdn.net_u014646662_article_details_82777966]

DataX3.0 MySQL导入MySQL：[https://blog.csdn.net/u014646662/article/details/82778067][https_blog.csdn.net_u014646662_article_details_82778067]

DataX3.0源离线同步工具介绍: [https://blog.csdn.net/u014646662/article/details/82792725][https_blog.csdn.net_u014646662_article_details_82792725]

[Link 1]: https://www.cbedai.net/u014646662
[https_blog.csdn.net_u014646662_article_details_82748055]: https://blog.csdn.net/u014646662/article/details/82748055
[https_blog.csdn.net_u014646662_article_details_82777966]: https://blog.csdn.net/u014646662/article/details/82777966
[https_blog.csdn.net_u014646662_article_details_82778067]: https://blog.csdn.net/u014646662/article/details/82778067
[https_blog.csdn.net_u014646662_article_details_82792725]: https://blog.csdn.net/u014646662/article/details/82792725