mysqldump causes error 2006
Hot on the heels of the recent mysqldump I’ve been running on MySQL 5.5 which ended with the following error:
Got error: 2006: MySQL server has gone away when selecting the database
Turned out that this error is quite common and there is a quick work around for that – increase max_allowed_packet. In my case going from 16M to 128M was enough.
P.S. There is a helpful thread at DBA Stackexchange which is worth reading too.