LCKB
Max allowed packets - Printable Version

+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Help & Support (https://lckb.dev/forum/forumdisplay.php?fid=157)
+----- Forum: Ep4 Support (https://lckb.dev/forum/forumdisplay.php?fid=128)
+------ Forum: Solved topics (https://lckb.dev/forum/forumdisplay.php?fid=158)
+------ Thread: Max allowed packets (/showthread.php?tid=4445)



- KochanyMis - 12-29-2015






- kravens - 12-29-2015


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 Smile




- KochanyMis - 12-29-2015



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 Smile

does it matter where I write max_allowed_packet=300m?




- kravens - 12-29-2015



 

does it matter where I write max_allowed_packet=300m?

 

Where you want.




- fantasymerlin - 12-29-2015


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 - 12-29-2015

Thanks a lot Smile