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

Import Data from CSV log ?

forums forums SQLyog Using SQLyog Import Data from CSV log ?

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • #14974
      Ritesh
      Member

      SQLyog uses “LOAD DATA LOCAL…” command to import data from a CSV file.

      The message shown by SQLyog is returned by MySQL itself. You can find more information about the command at http://www.mysql.com/doc/en/LOAD_DATA_LOCAL.html

      HTH

    • #14975
      polka4ever
      Member

      Hello, I am having the same issue – when I LOAD DATA LOCAL INFILE, I receive a message that says,

      Query OK, 397 rows affected (0.02)

      Records: 412 Deleted:0 Skipped:15 Warnings: 0

      I would like to determine WHICH records were skipped – and hopefully why. Where is the log file for this? I have looked locally on my machine (where mySQL is installed) and do not see any log files for this.

      Where should I be looking? The specific answer I'm looking for here is the LOG FILE itself and it's location.

      Sincerely,

      p0lkag1rl


      For clarity – I wanted to mention that I am using mySQL Command Line Client and the file I am loading is a tab-delimited file.


      making a note to this: apparantly I can use the command “show warnings;” at the command line to show all of the warnings related to this data load – but I'd actually like to be able to see the “skipped” records. Still looking for this info, but I thought this might help point me and others in the right direction, if others are looking for this info as well.

    • #14976
      Ritesh
      Member

      I don't think MySQL keeps a log of skipped rows while doing an import from CSV file.

      You might try the MySQL mailing lists regarding your problem.

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