Variable ‘time_zone’ can’t be set to the value of ‘NULL’解决方法

来源:互联网 发布:水冷的热仿真软件 编辑:程序博客网 时间:2024/05/16 05:49

MYSQL恢复数据库时出现如下错误:
ERROR 1231 (42000): Variable ‘time_zone’ can’t be set to the value of ‘NULL’
ERROR 1231 (42000): Variable ‘sql_mode’ can’t be set to the value of ‘NULL’
ERROR 1231 (42000): Variable ‘foreign_key_checks’ can’t be set to the value of ‘NULL’
ERROR 1231 (42000): Variable ‘unique_checks’ can’t be set to the value of ‘NULL’
ERROR 1231 (42000): Variable ‘character_set_client’ can’t be set to the value of ‘NULL’
Query OK, 0 rows affected (0.00 sec)

解决方式:

mysql> set global max_allowed_packet=1000000000;
mysql> source ./my_db.sql;
1 0
原创粉丝点击