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