List:General Discussion« Previous MessageNext Message »
From:J.R. Bullington Date:December 10 2004 12:38am
Subject:RE: Deleted: 0 Skipped: 0 Warnings: a lot
View as plain text  
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