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


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


Restart MySQL service

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

Similar Posts: