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

CSV Immport Error

forums › forums › SQLyog › Using SQLyog › CSV Immport Error

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • March 22, 2004 at 6:11 pm #8375
      fraley
      Member

      Hi,

      I'm a new user, and I'm trying to import some data from a CSV. I have the table set up and selected, and fill in the CSV file name into the dialog box. However, I get the error message:

      Error No. 2013

      Lost connection to MySQL server during query

      However, I have a connection both before and after, and can do other queries. Repeating the import does not work.

      Is somethng not configured properly?

      Bob

    • March 23, 2004 at 4:13 am #15593
      fraley
      Member

      I solved my own problem by creating another table, looking exactly like the original table. This table loaded the CSV file with no problems, while the former table would not even start reading the file before it issued the error message.

      Whatever works.

    • March 23, 2004 at 12:34 pm #15594
      Shadow
      Member

      Glad that it works, but I would like to know a bit more about this problem. Versions of MySql and SQLyog? Are the two tables identical? Are they in the same DB? Do they have the same storage type? Did you tamper with my.ini or my.cnf between the two tries?

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