MySQL_ERROR 1231 (42000) at line XX in file 'file_name' Variable 'time_zone' can't be

baichuo19940724發表於2017-04-13
MySqlError
  • 類似的錯誤資訊如下
ERROR 1231 (42000) at line 10370 in file: '/root/sql/ultrax_170322.dmp': Variable 'time_zone' can't be set to the value of 'NULL'
ERROR 1231 (42000) at line 10372 in file: '/root/sql/ultrax_170322.dmp': Variable 'sql_mode' can't be set to the value of 'NULL'
ERROR 1231 (42000) at line 10373 in file: '/root/sql/ultrax_170322.dmp': Variable 'foreign_key_checks' can't be set to the value of 'NULL'
ERROR 1231 (42000) at line 10374 in file: '/root/sql/ultrax_170322.dmp': Variable 'unique_checks' can't be set to the value of 'NULL'
ERROR 1231 (42000) at line 10375 in file: '/root/sql/ultrax_170322.dmp': Variable 'character_set_client' can't be set to the value of 'NULL'
Query OK, 0 rows affected (0.00 sec)

ERROR 1231 (42000) at line 10377 in file: '/root/sql/ultrax_170322.dmp': Variable 'collation_connection' can't be set to the value of 'NULL'
ERROR 1231 (42000) at line 10378 in file: '/root/sql/ultrax_170322.dmp': Variable 'sql_notes' can't be set to the value of 'NULL'

在網上查閱了資料說是備份的時候新增了註釋，在匯入的時候會出問題，具體是什麼原因，也沒有詳細瞭解，按照網上的做法把這些語句給註釋掉，然後就可以正常匯入了

參考：http://blog.csdn.net/u012599988/article/details/46606825

轉載於:https://www.cnblogs.com/ZhangRuoXu/p/6706440.html

相關文章