Answers for "mysql got packet bigger than 'max_allowed_packet' bytes when dumping table"

1

Error:Got a packet bigger than 'max_allowed_packet' bytes

run this command in your mysql console.

set global net_buffer_length=1000000; 
set global max_allowed_packet=1000000000;
Posted by: Guest on June-18-2021
4

Got a packet bigger than 'max_allowed_packet' bytes

for linux user's -> using lampp
->goto  opt/lampp/etc/my.cnf ----- and change the below vales accordingly
max_allowed_packet=1000
innodb_log_file_size = 50M
Posted by: Guest on September-01-2021

Code answers related to "mysql got packet bigger than 'max_allowed_packet' bytes when dumping table"

Browse Popular Code Answers by Language