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!