Max allowed packets

[KochanyMis]

[kravens]

open terminal.

 

write: updatedb

 

go to root>etc>my.cnf

 

write> max_allowed_packet = 300m

 

save it, then

 

write on terminal "service mysqld restart"

 

and done

[KochanyMis]

open terminal.

 

write: updatedb

 

go to root>etc>my.cnf

 

write> max_allowed_packet = 300m

 

save it, then

 

write on terminal "service mysqld restart"

 

and done

does it matter where I write max_allowed_packet=300m?

[kravens]

 

does it matter where I write max_allowed_packet=300m?

 

Where you want.

[fantasymerlin]

I ever take this...

 

mysql -u root -p

 

then...

set global max_allowed_packet=100000000

 

and saving...

 

flush privileges;
quit

 

Please Note after Reebot you set it new if you upload a database

 

I don´t write it in a file. So works fine at my machine and the database loads without errors

[KochanyMis]

Thanks a lot