Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I got problem (#2006 Mysql server gone away) with mysql while connecting and performing some operations through web browser.

Operation Listed below:

  1. When Executing big procedure
  2. Importing database dump
  3. When Access some particular tables It immediately throws "Server gone away".

Refer this question for Scenarios: http://stackoverflow.com/questions/19464939/record-not-inserted-2006-mysql-server-gone-away

Note : The above operations are works fine when I perform through terminal.

I tried some configuration from google search. That is set wait_timeout, max_allowed_packet. I checked for the bin_log but it is not available. But the issues will not rectified.

  1. What is the problem & How can I figure out & fix the issue?

  2. what is the different between access phpmyadmin mysql server from web browser and terminal?

  3. Where I can find the mysql server log file?

Note: If you know about any one of the above questions. Please post here. It would be helpful to trace.

Please help me to figure this out..

Thanks in advance...

share|improve this question

1 Answer 1

up vote 0 down vote accepted

It's actually MySQL server problem and not MySQL client problem I believe.

MySQL does not log error messages for MySQL server gone away and does not give any hint on how to solve this error.

There are some blog posts which can help you in identifying root cause of this issue, please refer:

http://blog.webyog.com/2009/08/10/mysql-server-has-gone-away-part-1-max_allowed_packet/

http://blog.webyog.com/2009/09/02/%E2%80%9Cmysql-server-has-gone-away%E2%80%9D-part-2-session-timeout/

I hope these information helps you.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.