Windows SQL question about setting max package.

[RoHaN-OTs]

Anyone know what the max package limit is?

Of this; SET GLOBAL max_allowed_packet = 16776192; (example)

Using xampp 1.7.3 if that matters.

 

[Havocbringer]

--max_allowed_packet=100M -u root -p database < dump.sql

 

[Cykotitan]

you don't need it higher than 16M, also set it in my.ini instead

 

[Havocbringer]

Yes u dont need it cyko but he asked the max i just ansered the question
Also, change the my.cnf or my.ini file under the mysqld section and

set max_allowed_packet=100M

( or 16 m whatever )
or you could run these commands in a mysql console connected to that same server:

set global net_buffer_length=1000000; 
set global max_allowed_packet=1000000000;

( or whatever u need 16m )

:$

 

[RoHaN-OTs]

Thanks guys. rep'd