解决问题：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文件内部有注释，去掉就可以了

1. /*!40000 ALTER TABLE `t_error_identification` ENABLE KEYS */;
   
2. UNLOCK TABLES;
   
3. /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
   
4. 
   
5. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
   
6. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
   
7. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
   
8. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
   
9. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
   
10. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
    
11. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

复制代码