max_allowed_packet increase not working

I am trying to migrate a database that is 145mb at errors at 87 tables inserted with this message:

ERROR 1153 at line 1378802: Got a packet bigger than 'max_allowed_packet'


So to my understanding I need to increase the max_allowed_packet. I have mysql v4.23 and to my understand the MAP is 1gb but i also understand that there is another MAP which is the servers? Do i need to increase that? I have searched desperately even spoken to unix shell support to no avail.

This is what I have done and it still results in the above message. Log into my msql:

mysq> mysql --max_allowed_packet=200m (hit enter)
->

Thats it still nothing no error message or confirmation just the arrow, please assist. Thanks

re: max_allowed_packet increase not working

I was doing the syntax wrong:

mysql> SET MAX_ALLOWED_PACKET = 104857600;

You need to specifiy bytes

However if i set it then view it like this


mysql> show variables like 'max_a%';

it shows that it changed but when i log out of mysql and try to transfer the database it hasn't changed, it resets, how to you actually completely SET it?

re: max_allowed_packet increase not working

issue resolved for future reference you must set it from the shell not the mysql prompt

re: max_allowed_packet increase not working

Welcome to The Scripts!

And thanks very much for this information. I am sure it will help other members with packet size problems.

Ronald :cool: