List:General Discussion« Previous MessageNext Message »
From:kalin mintchev Date:December 10 2004 3:51am
Subject:RE: Deleted: 0 Skipped: 0 Warnings: a lot
View as plain text  
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:kalin@stripped]
> 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:kalin@stripped]
>> Sent: Thursday, December 09, 2004 6:53 PM
>> To: mysql@stripped
>> 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/mysql?unsub=1
>>
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>>
>>
>
>
> --
>
>
>


-- 

Thread
Deleted: 0 Skipped: 0 Warnings: a lotkalin mintchev10 Dec
  • RE: Deleted: 0 Skipped: 0 Warnings: a lotJ.R. Bullington10 Dec
    • RE: Deleted: 0 Skipped: 0 Warnings: a lotkalin mintchev10 Dec
RE: Deleted: 0 Skipped: 0 Warnings: a lotJ.R. Bullington10 Dec
  • RE: Deleted: 0 Skipped: 0 Warnings: a lotkalin mintchev10 Dec
    • Re: Deleted: 0 Skipped: 0 Warnings: a lotDan Nelson10 Dec
  • RE: Deleted: 0 Skipped: 0 Warnings: a lotkalin mintchev10 Dec