Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forums | Webyog

Tools to manage and monitor MySQL databases

Mysql Has Gone Away

This topic is empty.

Viewing 3 reply threads

Author

Posts
- October 18, 2006 at 4:35 pm #9973
  
  Richard J Lacroix
  Member
  
  I get the following when attempting to import data:
  
  Job started at Wed Oct 18 12:31:47 2006
  
  ERROR: 2006, MySQL server has gone away
  
  ERROR: 2006, MySQL server has gone away
  
  ERROR: Import aborted…
  
  But when I leave the Migration Toolkit wizard, I can access that table.
  
  What gives?
  
  I've attached the Job file (usercontact.txt)
- June 27, 2007 at 8:09 pm #22795
  
  zTodd
  Member
  
  Richard J Lacroix wrote on Oct 18 2006, 09:35 AM:
  
  I get the following when attempting to import data:
  
  Job started at Wed Oct 18 12:31:47 2006
  
  ERROR: 2006, MySQL server has gone away
  
  ERROR: 2006, MySQL server has gone away
  
  ERROR: Import aborted…
  
  But when I leave the Migration Toolkit wizard, I can access that table.
  
  What gives?
  
  I've attached the Job file (usercontact.txt)
  
  We would get that message when the data in one of the tables is too large or has line feeds in it. Check your log to see which table bombed out.
- June 28, 2007 at 8:16 am #22796
  
  peterlaursen
  Participant
  
  @to both of you!
  
  To me it looks either like a networking issue of some kind or a MySQL configuration issue (max_allowed_packet ?).
  
  How do you connect? HTTP-tunnel, direct connection?
  
  Any idea about how we can have 'hands on' this
  
  1) a more detailed test case
  
  2) remote access to both ODBC data and MySQL
- June 28, 2007 at 8:24 am #22797
  
  peterlaursen
  Participant
  
  If max_allowed_packet in server configuration is low (like 1 M) then please try to raise the value. 32M, 64M for instance!
Author

Posts

Viewing 3 reply threads

You must be logged in to reply to this topic.