Programming

Error Code: 2006 – MySQL server has gone away when importing backup

The problem is probably caused by too large backup/restore script or SQL commands. The solution which works for me is increasing `max_allowed_packet` setting in my.ini

  • Open¬†“c:\ProgramData\MySQL\MySQL Server 5.6\my.ini”
  • Change¬†max_allowed_packet to 24M
  • Save and restart mysql service

External sources:

Leave a Reply

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