David Slack - Web developer

So you tried to upload a database and got the error "Got a packet bigger than 'max_allowed_packet' bytes". This happens offten when you move a Drupal DB from one server to another.

So how do you make your server allow bigger packets? Easy.

There is a file in /etc called my.cnf. Simply add the line 'max_allowed_packet = 12M' to the end of the file (or edit the line) so the file reads:

{syntaxhighlighter brush: ruby;fontsize: 100; first-line: 1; }[mysqld] set-variable = max_connections=500 log-slow-queries safe-show-database local-infile=0 max_allowed_packet = 12M{/syntaxhighlighter}

Then simply restart the MySQL Server.