Solved

MySQL server has gone away

Posted on 2004-10-18
5
437 Views
Last Modified: 2010-03-18
MySQL server has gone away


that error i got when i need add any sql file


now what?
0
Comment
Question by:free-mind
  • 2
5 Comments
 
LVL 2

Expert Comment

by:mmartha
ID: 12350230
http://dev.mysql.com/doc/mysql/en/Gone_away.html

It has a windoze user comment about your problem: "If " MySQL server has gone away" occurs when trying to upload a file, here's the cure.(...)"

Hope it helps ;D

MMarts
0
 

Author Comment

by:free-mind
ID: 12351840
my OS Linux RH9
0
 
LVL 2

Accepted Solution

by:
mmartha earned 500 total points
ID: 12429640
"The most common reason for the MySQL server has gone away error is that the server timed out and closed the connection." (http://dev.mysql.com/doc/mysql/en/Gone_away.html)

"Here's something that others might run across which I haven't seen mentioned on this site elsewhere. (...) The problem turned out to be caused by a lack of reverse name lookups in DNS for the ip of the clients.  Somehow the dns server listed in /etc/resolv.conf had stopped doing reverse lookup resolution for the zone these clients were in. Some of the hosts were listed in /etc/hosts -- those were the ones that were working.

Simply adding the hostnames to /etc/hosts with the correct ip addresses was enough to get mysqld and the client working normally again."

Or else, you can try this one that I recommended previously:

look for these files in your system:
my-small.cnf
my-large.cnf
my-medium.cnf
my-huge.cnf

with: find / -name "my-*.cnf" -print

then open my-medium.cnf (suggested by the original poster) and change the set-variable = max_allowed_packet line  to 32Mb maybe (that's the example made by the poster in the mysql page)

change the same set-variable under the [mysqldump] tag.


Please answer if this doesn't help you.

MMarts
0

Featured Post

New My Cloud Pro Series - organize everything!

With space to keep virtually everything, the My Cloud Pro Series offers your team the network storage to edit, save and share production files from anywhere with an internet connection. Compatible with both Mac and PC, you're able to protect your content regardless of OS.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Redhat Linux 6.6 and LDAP 18 112
USPS intelligent mail barcode font 11 133
How to identify SSH user interactive login? 15 75
Linux Login using LDAP or Active Directory 4 115
I have seen several blogs and forum entries elsewhere state that because NTFS volumes do not support linux ownership or permissions, they cannot be used for anonymous ftp upload through the vsftpd program.   IT can be done and here's how to get i…
Note: for this to work properly you need to use a Cross-Over network cable. 1. Connect both servers S1 and S2 on the second network slots respectively. Note that you can use the 1st slots but usually these would be occupied by the Service Provide…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now