Support Knowledge Base

MySQL server has gone away

This issue usually encounters when max_allowed_packet has very low value than the data you submitted via query. This can be fixed by increasing max_allowed_packet variable value so it is recommended to edit this variable through /mysql/bin/my.ini (Windows) or /etc/my.cnf  (Linux/UNIX) config file. It should look like as follows:

 
my.ini / my.cnf Configuration Sample

[mysqld]

max_allowed_packet = 16M

Explanation: max_allowed_packet is set to 16 Megabytes

Once, you have updated the value then restart your MySQL Server and you're done!

That's it!

NOTE: If you are not sure how to do this then kindly reach out to your web server administrator and ask to make this change.

Custom Fields
  • Applicable To: Standard Edition, Standard (Multi-Language) Edition, Enterprise Edition (MySQL), Enterprise Multi-Language Edition (MySQL), Enterprise Edition (SQL Server), Enterprise Multi-Language Edition (SQL Server)
5 (1)
Article Rating (1 Votes)
Rate this article
Attached Files
There are no attachments for this article.
Comments
There are no comments for this article. Be the first to post a comment.
Name
Email
Security Code Security Code
Related Articles RSS Feed
How to enable mbstring in PHP?
Viewed 344473 times since Wed, Feb 6, 2013
How to enable text selection and copying on article page?
Viewed 9005 times since Thu, Jan 22, 2015
Can I use the PHPKB software without active support subscription?
Viewed 9092 times since Mon, Aug 8, 2011
How to install wkhtmltopdf and configure in PHPKB
Viewed 10146 times since Fri, Dec 11, 2015
Unable to upload large files or no data received on "Save Article" page
Viewed 2996 times since Thu, May 26, 2016
Problem with Truncated Article Content for SQL Server Edition
Viewed 5527 times since Thu, Feb 9, 2012
SEO Friendly URLs Not Working
Viewed 9088 times since Fri, Mar 18, 2016
Why should I renew my software maintenance?
Viewed 10374 times since Mon, Aug 8, 2011