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

Import from CSV file

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Import from CSV file

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • December 1, 2003 at 5:14 am #8256
      saleyoun
      Member

      I have a CSV file I can't import due to an SQLyog error# 2013 – Lost connection to MySQL Server during query. The file has 32 columns separated by commas. The values are not enclosed by double quotes (“”) and I'm logged in as root.

    • December 1, 2003 at 9:01 am #15271
      Shadow
      Member

      You may try increasing the timeout value, so the import could complete.

    • December 1, 2003 at 2:49 pm #15272
      saleyoun
      Member

      Thank you so much for your prompt reply, but where do I increase the time out?

    • December 2, 2003 at 8:34 am #15273
      Shadow
      Member

      In the my.cnf or my.ini (depending on which you have) net_read_timeout and net_write_timeout parameters (in seconds) should be increased or added. If the rows contain lots of data (blobs for example), then increasing the max_allowed_packet value may also resolve the issue. Furthermore, if you are using 4.0.15 and run it on Win platform, then you should upgrade because MySql screwd up the timeout settings…

  • Author
    Posts
Viewing 3 reply threads
  • You must be logged in to reply to this topic.