I receive the following error message:“Server is gone away…..”.What
am I doing wrong?
The most probable reason of the problem is the connection timeout. In this
case you need to increase the value of the wait_timeout variable when launching
mysqld. The error also occurs in the following cases:
- Somebody (your database
administrator) used the KILL sql or mysqladmin kill command to interrupt
your query thread.
- You are trying to run a query after closing the connection
with the server.
- You are trying to send too large a query to the server,
e.g. you are working with very big BLOB fields or the INSERT command
tries to insert too many records. You can increase the maximum allowed
packet size by setting the max_allowed_packet variable whose default
value is 1Mb. If this error occurs during the data import or copy database
process, you can lower the value of the "Record count per each data block" option.