Tag Archives: 1153 Got a packet bigger than ‘max_allowed_packet’ bytes

Navicat Import Datas Error: — 1153 – Got a packet bigger than ‘max_allowed_packet’ bytes

Error in importing MySQL database from Navicat — 1153 – got a packet bigger than ‘Max_allowed_packet’ bytes

After checking, it turns out that the data table exceeds the maximum value of SQL file read and executed by MySQL by default; The maximum is 16m. My SQL file is 200m, so it cannot be executed

Solution:

Find the file my.cnf in the MySQL installation directory, search [mysqld], and add a sentence below it

max_allowed_packet=400M

Restart MySQL service

This size is set according to the size of your SQL file