inside the mind of a linux admin

MySQL: got a packet bigger than ‘max_allowed_packet’ bytes

Came across this rather annoying error when importing a rather large database into mySQL. Here’s an easy fix: Open mySQL console as root: mysql> set global max_allowed_packet=1000000000; mysql> set global net_buffer_length=1000000; Then import your database: # mysql db_name < sqldump.sql Done. Share on FacebookTweet

Read More