标题: 解决问题：Variable 'time_zone' can't be set to the value of 'NULL' [打印本页] 作者: 洪七公 时间: 2023-4-11 09:13 标题: 解决问题：Variable 'time_zone' can't be set to the value of 'NULL'
恢复数据库的时候可能会遇到Variable 'time_zone' can't be set to the value of 'NULL'的错误
这个问题的原因是因为数据sql文件内部有注释，去掉就可以了
/*!40000 ALTER TABLE `t_error_identification` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;