MySQLGotapacketbiggerthan'max_allowed_packet'bytes異
來源:懂視網
責編:小采
時間:2020-11-09 14:03:21
MySQLGotapacketbiggerthan'max_allowed_packet'bytes異
MySQLGotapacketbiggerthan'max_allowed_packet'bytes異:MySQL Got a packet bigger than 'max_allowed_packet' bytes錯誤 今天用Navicat Premium執行數據插入命令,一共3萬多條記錄吧,導入數據庫時提示: Error Code:1153 Got a packet bigger than 'max_allowed_pac
導讀MySQLGotapacketbiggerthan'max_allowed_packet'bytes異:MySQL Got a packet bigger than 'max_allowed_packet' bytes錯誤 今天用Navicat Premium執行數據插入命令,一共3萬多條記錄吧,導入數據庫時提示: Error Code:1153 Got a packet bigger than 'max_allowed_pac

MySQL Got a packet bigger than 'max_allowed_packet' bytes錯誤 今天用Navicat Premium執行數據插入命令,一共3萬多條記錄吧,導入數據庫時提示: Error Code:1153 Got a packet bigger than 'max_allowed_packet' bytes錯誤提示。 開始沒注意,提示一大堆
MySQL Got a packet bigger than 'max_allowed_packet' bytes錯誤
今天用Navicat Premium執行數據插入命令,一共3萬多條記錄吧,導入數據庫時提示:
Error Code:1153 Got a packet bigger than 'max_allowed_packet' bytes錯誤提示。
開始沒注意,提示一大堆,后來才看見這句
使用Navicat Premium工具導出MySQL數據時,當數據量大時,導出不會錯誤,但導入時會出現錯誤。如果將SQL單獨執行會發現是Error Code:1153 Got a packet bigger than 'max_allowed_packet' bytes錯誤。
對于這個問題可以在my.ini中最后增加一行max_allowed_packet=16M即可(根據實際情況設置)。
注意,在[client]和[mysql]部分增加無效,那個是客戶端讀取的參數。
聲明:本網頁內容旨在傳播知識,若有侵權等問題請及時與本網聯系,我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com
MySQLGotapacketbiggerthan'max_allowed_packet'bytes異
MySQLGotapacketbiggerthan'max_allowed_packet'bytes異:MySQL Got a packet bigger than 'max_allowed_packet' bytes錯誤 今天用Navicat Premium執行數據插入命令,一共3萬多條記錄吧,導入數據庫時提示: Error Code:1153 Got a packet bigger than 'max_allowed_pac