1. The error log will show which Inserts failed and how. The SQL insert statements don't become "records" or rows till they're inserted, so there's no such thing as "records that were not inserted". If the error log is insufficient for your requirement, there are a couple of ways to go. One would be to enclose the Insert process in transactions so they succeed or fail en bloc. In the unlikely event that that's not practical, you could turn on the "general log" (see the manual page for logs), or more elaborately, see
http://www.artfulsoftware.com/infotree/Transaction%20time%20validity%20in%20MySQL.pdf for a review of how to build an audit system.
2. > I do not have my.ini or my.cnf on my PC.
Unlikely. To find what my.ini is in use, open up the Services applet, scroll to the MySQL entry in the list, right-click, select Properties; in "Path to executable", "defaults-file" is followed by the full path to my.ini
3. By default the error file is in the folder set b datadir in my.ini. It's usually preferable to let mysql put its error files where it chooses.
Edited 1 time(s). Last edit at 07/02/2015 12:12PM by Peter Brawley.