MySQLGotapacketbiggerthanmax_allowed_packetbytes error today we use NavicatPremium to execute the data insertion command. There are more than 30 thousand records. The error message "ErrorCode: 1153Gotapacketbiggerthanmax_allowed_packetbytes. I didn't pay attention to it at the beginning. A bunch of prompts were prompted.
MySQL Got a packet bigger than 'max _ allowed_packet 'bytes Error today we use Navicat Premium to execute the data insertion command. There are more than 30 thousand records in total. When importing the database, the system prompts: Error Code: 1153 Got a packet bigger than 'max _ allowed_packet 'bytes error message. I didn't pay attention to it at the beginning. A bunch of prompts were prompted.
MySQL Got a packet bigger than 'max _ allowed_packet 'bytes Error
Today, we use Navicat Premium to execute the data insertion command. There are more than 30 thousand records. The prompt is displayed when we import the database:
Error Code: 1153 Got a packet bigger than 'max _ allowed_packet 'bytes Error message.
I didn't pay attention to it at first. I had a bunch of prompts before I saw this sentence.
When you use the Navicat Premium tool to export MySQL Data, when the data volume is large, the export will not be wrong, but the import will produce an error. If the SQL statement is executed separately, the Error Code: 1153 Got a packet bigger than 'max _ allowed_packet 'bytes is returned.
To solve this problem, add max_allowed_packet = 16 m at the end of my. ini (set as needed ).
Note: The value added in [client] and [mysql] is invalid, which is the parameter read by the client.