mysql source 恢複 sql資料time_zone報錯 已解決

標籤：接受   comm   配置   log   prevent   參數   ref   one   sys   

報了一些變數的錯誤，類似於"time_zone" 等錯誤

解決：

[[email protected] conf.d]# vi /etc/my.cnf[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sock# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0# Settings user and group are ignored when systemd is used.# If you need to run mysqld under a different user or group,# customize your systemd unit file for mariadb according to the# instructions in http://fedoraproject.org/wiki/Systemdmax_allowed_packet = 1024M   #新增這項解決。[mysqld_safe]log-error=/var/log/mariadb/mariadb.logpid-file=/var/run/mariadb/mariadb.pid## include all files from the config directory#!includedir /etc/my.cnf.d

　　

原因：

MySQL根據設定檔會限制server接受的資料包大小。

有時候大的插入和更新會被max_allowed_packet 參數限制掉，導致失敗。  改大些就應該沒問題了。。

 

mysql source 恢複 sql資料time_zone報錯 已解決