数据导入mysql5.7报错

[3746658]

[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO cmdb_resource_network VALUES (3,'10.16.25','2016-08-15 13:53:47','','',NULL,24,'25段生产环境');
[Err] 1231 - Variable 'time_zone' can't be set to the value of 'NULL'
[Err] /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE /;
[Err] 1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
[Err] /!40101 SET SQL_MODE=@OLD_SQL_MODE /;
[Err] 1231 - Variable 'foreign_key_checks' can't be set to the value of 'NULL'
[Err] /!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS /;
[Err] 1231 - Variable 'unique_checks' can't be set to the value of 'NULL'
[Err] /!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS /;
[Err] 1231 - Variable 'character_set_client' can't be set to the value of 'NULL'
[Err] /!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /;
[Err] 1231 - Variable 'collation_connection' can't be set to the value of 'NULL'
[Err] /!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION /;
[Err] 1231 - Variable 'sql_notes' can't be set to the value of 'NULL'
[Err] /!40111 SET SQL_NOTES=@OLD_SQL_NOTES /;
[Err] 1060 - Duplicate column name 'vlan'
[Err] /*

• 2017-04-04
  */
  alter table cmdb_resource_network add vlan varchar(10) comment "网络所在vlan";
  [Err] 1050 - Table 'cmdb_graph_quartz' already exists
  [Err] CREATE TABLE cmdb_graph_quartz (
  name varchar(200) DEFAULT NULL COMMENT '只要名字在，就不执行，等于一个锁',
  ip_address varchar(32) DEFAULT NULL COMMENT '哪个ip地址添加的',
  create_time bigint(20) DEFAULT NULL COMMENT '添加时间'
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  [Msg] Finished - Unsuccessfully

---

[zhaoyun006]

先手动修改下

[RoyZhou2008]

数据库脚本有两三处错误

[L00J]

哪里有问题？发自我的华为手机-------- 原始邮件 --------主题：Re: [AsuraTeam/monitor] 数据导入mysql5.7报错 (#15)发件人：YuanZhou 收件人：AsuraTeam/monitor 抄送：Subscribed 数据库脚本有两三处错误 —You are receiving this because you are subscribed to this thread.Reply to this email directly, view it on GitHub, or mute the thread.