MySQLd Logging Question/Problem

[David Cary Hart]

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