Need help with SET GLOBAL.

[lokolokio]

Im needing help to fix this error because i dont know why it has been displayed the error is the next:

SET GLOBAL max_allowed_packet = 16776192;

Ive puted many many (on sql execute command in phpmyadmin) times and i think that it will fix the problem but arround each 3 restart of the server it will happen again.

 

[Cykotitan]

edit my.ini/my.cnf file instead (my.ini in mysql[/bin] folder on windows or /etc/mysql/my.cnf on linux)

 

[lokolokio]

i found two parts with that text:
but the first contains thiss:
[mysql]
max_allowed_packet = 1M

and the other one on:

[mysqldump]
quick
max_allowed_packet = 16M

i need to change both for this
max_allowed_packet = 1M for max_allowed_packet = 16776192;
and this for
max_allowed_packet = 16M max_allowed_packet = 16776192;

???

 

[Cykotitan]

just set the first one to 16M & restart mysql

 

[lokolokio]

Thank you very much it works... what i do without this forum... \o/