error mysql : Got a packet bigger than 'max_allowed_packet' bytes

Question

for import mysql database give me this error :

$ `mysql -u user -p password zxc_db < zxc.sql`
ERROR 1153 (08S01) at line 96: Got a packet bigger than 'max_allowed_packet' bytes

Please give me a best solution to solve it ? tanx .

Do you mean other than `"increase max_allowed_packet in my.cnf"`? — Burhan Khalid, Nov 04 '12 at 13:35
Another thread answered this question: http://stackoverflow.com/questions/93128/mysql-error-1153-got-a-packet-bigger-than-max-allowed-packet-bytes Basically, you need to change the settings both on the dameon and on the client. — mprat, Sep 12 '13 at 17:01

score 13 · Accepted Answer · answered Nov 04 '12 at 13:41

13

the best solution is " change mysql.cnf " debian : /etc/mysql/mysql.cnf change this line ==> max_allowed_packet = 16M to : max_allowed_packet = 128M

or add --max_allowed_packet=128M to your mysqldump command.

mysql --max_allowed_packet=128M -u user -ppass database < database.sql

answered Nov 04 '12 at 13:41

yal110

154
1
3

1

tried that, yet received same error message as before... – alexus Jan 31 '13 at 20:13
Still receiving this error message after doing this. – Allen Gingrich Sep 03 '13 at 17:44
4

From the link shared by @PrimozRome, before running your import, run this: mysql -uroot -p -e "set global net_buffer_length=1000000; set global max_allowed_packet=1000000000;" – kakoma Jul 07 '14 at 07:22
When you change the mysql.cnf file, you need to restart the server before that setting is refreshed. – iewebguy Jan 26 '15 at 19:20

error mysql : Got a packet bigger than 'max_allowed_packet' bytes

1 Answers1