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

Importing Csv Problem

forums › forums › SQLyog › Using SQLyog › Importing Csv Problem

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • April 11, 2011 at 6:26 am #32125
      Aparna
      Member

      Hi,

      The sample data that you have provided imports absolutely fine without having to change the data type to Varchar. Can you please tell us how you connect to MySQL(Direct/HTTP/SSH) and your MySQL version? In order to find the version of MySQL that you are using please execute

      SELECT VERSION();. If it is either SSH or direct connection then goto the table menu and try the option IMPORT CSV DATA USING LOAD LOCAL option to import the CSV file. Can you create a job file using import external data and send it to us(Sensitive information like the MySQL connection details can be removed from the job file). Also request you to send the CSV file in order to replicate and understand the issue at our end. If the data is confidential you can create a support ticket by mailing us at [email protected]

      Thanks and Regards,

      Aparna.

    • April 11, 2011 at 7:26 am #32126
      peterlaursen
      Participant

      And .. what column type do you import to?

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.