On Tue, 2005-08-02 at 18:36 +0100, Paul F. Johnson wrote: > Hi, > > > > mysql> LOAD DATA LOCAL INFILE 'discards' INTO TABLE discards; > > Query OK, 35457 rows affected, 594 warnings (0.62 sec) > > Records: 35457 Deleted: 0 Skipped: 0 Warnings: 594 > > > > mysql> LOAD DATA LOCAL INFILE 'rejects' INTO TABLE rejects; > > Query OK, 93064 rows affected, 1620 warnings (1.56 sec) > > Records: 93064 Deleted: 0 Skipped: 0 Warnings: 1620 > > > > Where are these "warnings" logged? I have an empty mysqld.log. > > Change the logging level in mysqld to something higher and you'll see > them. I *think* they just mean your data doesn't exactly fit the table > (not quite incompatible types, but something akin to it - the data is in > there usually though). > It inexplicably fixed itself on the next batch. I have been getting some inconsistent results ever since the last update. -- Tired of spam? Do YOUR part: http://www.BoulderPledge.org Our DNSRBL - Eliminate Spam: http://www.TQMcube.com/spam_trap.htm RBLDNSD HowTo: http://www.TQMcube.com/rbldnsd.htm Multi-RBL Check: http://www.TQMcube.com/rblcheck.htm
