Look at your wait_timeout and interactive_timeout settings. They may be set to a low value. If your connection sleeps for > these 2 vars mysql will disconnect you.
- Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 -->-----Original Message----- -->From: Randy Chrismon [mailto:[EMAIL PROTECTED] -->Sent: Tuesday, October 14, 2003 10:55 AM -->To: [EMAIL PROTECTED] -->Subject: Connection Time Out --> --> -->Splain this to me: I use my laptop to connect to the test-bed MySQL -->server residing on my desktop. Using this connection, I can do -->anything: load 200K lines, do complex (for me) queries, whatever. -->But, -->open a MySQL console connection _on the desktop_ where the MySQL -->server lives, I can't do a desc table without getting the "Lost -->connection to MySQL server during query" message. -->I've looked in the documentation and none of the possibilities there -->seem to apply. It seems especially strange since the remote -->connection -->from my laptop has none of these problems. -->Any ideas will be appreciated. -->Randy --> -->-- -->MySQL General Mailing List -->For list archives: http://lists.mysql.com/mysql -->To unsubscribe: -->http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
