Why do I have the error “MySQL server has gone away” on file upload? - LabCollector

Knowledge Base

Search Knowledge Base by Keyword

Why do I have the error “MySQL server has gone away” on file upload?

You are here:
← All Topics

 

Your files have probably more than 1Mb and MySQL server is limited to 1Mb by default.

You can increase the limit in my.ini (From Windows Manager, go to Settings > Configure Servers > MySQL or go to \AgileBio\LabCollector\conf):

max_allowed_packet=16M
wait_timeout=28800

This will add 16Mb limit. Adapt to your needs.
Note also that you cannot export MySQL as dump files anymore as it will generate extremely large export files.
Backup your database directly by saving the MySQL files or using the automatic backup in the Windows Manager.