DataWorks迁移ECS自建MySQL数据库至MaxCompute前提条件

已拥有至少一个绑定专有网络VPC的ECS（请勿使用经典网络），并在ECS上安装好MySQL数据库，数据库中已创建好用户和测试数据。本文中ECS自建MySQL的测试数据创建语句如下。 CREATE TABLE IF NOT EXISTS good_sale(create_time timestamp,category varchar(20),brand varchar(20),buyer_id varchar(20),trans_num varchar(20),trans_amount DOUBLE,click_cnt varchar(20));insert into good_sale values('2018-08-21','coat','brandA','lilei',3,500.6,7),('2018-08-22','food','brandB','lilei',1,303,8),('2018-08-22','coat','brandC','hanmeimei',2,510,2),('2018-08-22','bath','brandA','hanmeimei',1,442.5,1),('2018-08-22','food','brandD','hanmeimei',2,234,3),('2018-08-23','coat','brandB','jimmy',9,2000,7),('2018-08-23','food','brandA','jimmy',5,45.1,5),('2018-08-23','coat','brandE','jimmy',5,100.2,4),('2018-08-24','food','brandG','peiqi',10,5560,7),('2018-08-24','bath','brandF','peiqi',1,445.6,2),('2018-08-24','coat','brandA','ray',3,777,3),('2018-08-24','bath','brandG','ray',3,122,3),('2018-08-24','coat','brandC','ray',1,62,7) ;请记录好您的ECS的私有IP、专有网络和虚拟交换机信息。//help-static-aliyun-doc.aliyuncs.com/as https://help.aliyun.com/document_detail/154993.html，此回答整理自钉群“DataWorks交流群(答疑@机器人)”