I have never had a problem running that command, however you do have to run it right after you run your query (or LOAD DATA). That may be why you can't use it.
Also, try looking under <HOSTNAME.ERR> instead of a log file. That might help out. J.R. -----Original Message----- From: kalin mintchev [mailto:[EMAIL PROTECTED] Sent: Thursday, December 09, 2004 7:29 PM To: J.R. Bullington Subject: RE: Deleted: 0 Skipped: 0 Warnings: a lot > Command is SHOW WARNINGS; > > You can run this from either the command line or from the MySQL CC SQL > viewer. thanks.. but from the command line i get: Check the manual that corresponds to your MySQL server version for the right syntax to use near 'warnings' at line 1 is mysql-standard-4.0.13 to old for show warnings!? > > J.R. > > -----Original Message----- > From: kalin mintchev [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 09, 2004 6:53 PM > To: [EMAIL PROTECTED] > Subject: Deleted: 0 Skipped: 0 Warnings: a lot > > hi all... > > where can i see what these warnings are. i get them when i do load > data infile. > i was looking for some kind of log under /var/logs/ or mysql/var/log > but there isn't a log file for mysql at any of those locations. and > the mysql/var/ doesn't exist at all. > i created it and redid the load but still no log file.. > > is there a way to read the binary log files... > > thanks... > > > > -- > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
