Import Data from CSV log ?

[Anonymous]

Hi!, congratulations for this great software!.

I am using the freeware version 3.1 under Windows XP. The server is Linux Mandrake with the latest version of MySQL and PHP.

I am importing CSV files without problems but… in some cases it says that it skipped records.

I didn't find a log or a result page after importing.

Where may I find the reason of those skipped records ? Isn't there a log ?

Thank you in advance

Gabriel

[Ritesh]

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

[polka4ever]

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.

[Ritesh]

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.

[Author]

Posts