Navicat – Error 2006 MySQL server has gone away

When trying to restore a backup from Navicat, I got the Error 2006 which said that MySQL server has gone away. Looking around and I figured out that it’s because of the max_allowed_packet setting.

So, to fix the problem, edit your MySQL configuration file (my.cnf) and change (or add if it doesn’t exist) the parameter

max_allowed_packet=80M

Hope that works for you, too!

Leave a Comment

Your email address will not be published. Required fields are marked *