[polka4ever]

Since this is a LOAD DATA LOCAL INFILE thread – I wanted to ask a question as well. I am using this to load up some data – and I get a message that states, (in the mySQL Command Line Client):

Query OK, 397 rows affected (0.00 sec)

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

Where is the log for this located? I have searched locally (especially under C:Program FilesMySQLMySQL Server 4.1) – and I do not see any logs for this. Do I need to turn logging on? If so, how do I do so? I'd like to see exactly which files were skipped and WHY.

~polka4ever

~p0lkag1rl

---

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.

[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.

[Author]

Posts