max_allowed_packet error when importing a large database

I got max_allowed_packet error when importing a sql database from the server,

anyways, I solved it through setting new values for this “max_allowed_packet”!

ok, here it is
1. login to your mysql account

mysql -uYOUR_USERNAME -pYOUR_PASSWORD

2. Now, when your logged in set the new value for your “max_allowed_packet”

set global max_allowed_packet = 1073741824;

3. to check the new value of our max_allowed_packet

show variables like ‘max%’

There you go!

Advertisement