cant connect error no 2013

This topic is empty.

Viewing 11 reply threads

Author

Posts
- August 18, 2003 at 11:56 am #8134
  
  sjparkwe
  Member
  
  hello~
  
  ^^
  
  i very happy by getting the webyog
  
  but ~ one problem!
  
  error no 2013
  
  and erro message is ” Lost connection to MySql server during query”
  
  help me please!~
  
  good luck
- August 18, 2003 at 12:52 pm #14789
  
  Shadow
  Member
  
  I've encountered the same error under two conditions:
  
  1. MySql server was restarted while I was still logged in
  
  2. Wanted to send a too large packet to MySql and sometimes got this warning (along with packet too large…).
- August 18, 2003 at 12:59 pm #14790
  
  Shadow
  Member
  
  You may want to check chapter “A.2.2 MySQL server has gone away Error” of MySql's manual as well.
- August 18, 2003 at 4:04 pm #14791
  
  CalEvans
  Member
  
  I've encountered this several times also but it has never been the fault of sqlyog.
  
  For some reason the mysql deamon died. The last time I had this happen was because I had a corrupt index.
  
  Try using the mysql command line tool to execute the same query. See if it finishes. (I'm betting it won't.)
  
  =C=
- August 19, 2003 at 7:47 am #14792
  
  Shadow
  Member
  
  That's true, either I made a mistake or the test server was shut down for some reason when I got this warning.
- August 24, 2003 at 3:42 pm #14793
  
  jacobelias
  Member
  
  Hello,
  
  I am encountering the same problem. Lost connection to MySql server during query.
  
  How did you fix this problem?
  
  Thanks
  
  Jac
- August 25, 2003 at 4:40 am #14794
  
  sjparkwe
  Member
  
  ok~ find it!
  
  install
  
  cp support-files/my-medium.cnf /etc/my.cnf
  
  vi /etc/my.cnf
  
  [mysqld]
  
  port = 3306
  
  socket = /tmp/mysql.sock
  
  skip-locking
  
  set-variable = key_buffer=16M
  
  set-variable = max_allowed_packet=1M
  
  set-variable = table_cache=64
  
  set-variable = sort_buffer=512K
  
  set-variable = net_buffer_length=8K
  
  set-variable = myisam_sort_buffer_size=8M
  
  log-bin
  
  server-id = 1
  
  here
  
  skip-name-resolve –> this line insert
  
  here
  
  that it!!!!!!!!!!! good luck
- August 31, 2003 at 3:48 pm #14795
  
  jacobelias
  Member
  
  This is for linux or for windows?
  
  Jac
- August 31, 2003 at 5:37 pm #14796
  
  Ritesh
  Member
  
  I guess this is for a MySQL server running on Linux. You have to modify my.cnf
- September 1, 2003 at 11:36 am #14797
  
  jacobelias
  Member
  
  sjparkwe,
  
  Can you please tell me how to do the same in Windows 2000?
  
  Thanks in advance
  
  Jac
- September 6, 2003 at 8:10 am #14798
  
  jacobelias
  Member
  
  Hello,
  
  Can anyone help me with this, I made the changes in
  
  the above mentioned files, however I am ageeting the same error.
  
  Moreover my SQLyog will be expiring soon.
  
  Thanks
  
  Jc
- September 6, 2003 at 8:23 am #14799
  
  Ritesh
  Member
  
  Probably this will help http://www.mysql.com/doc/en/Gone_away.html
Author

Posts