Nurulazrad Blog

MySQL Error 1153 — Got a packer bigger than ‘max_allowed_packet’ bytes

Being a developement team, sometimes you need to do some simulation on your on notebook but to found that during the mysql migration (i’m using command line to do the import) has give me an error 1153. What is 1153 error?, well it basically inform you that during the migration, you have hit the max allowed packet. In layman term, your sql file is too big to be handled by the mysql.

In order to overwrite this limitation, you can opt to make permanent changes to your mysql setting and change the ‘max_allowed_packet’ variable or if you like me, since this is a temp process, I would use the following opt:

#load mysql

$ mysql -u <user> -p

$ mysql > set global max_allowed_packet=1000000000;

$ mysql > set global net_buffer_length=1000000;

#open another terminal

$ mysql -u <user> -p <database> < your_large_mysql_data_file.sql

I will take sometimes, please wait until the cursor return to your prompt command.

Enjoy!