ok... i just saw this in the manual: This command is implemented in MySQL 4.1.0
that's why it doesn't work... mine is 4.0.13. so what do people that have earlier versions then 4.1 do to see the warnings?! > 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]