mysql warnings, how to display them?

D

danyal711

Limp Gawd
Joined
Jul 9, 2004
Messages
205
Hi, I am using mySQL version 4.0.20a. When I use the LOAD data infile command I get the following output:

mysql> load data infile 'tabd.txt' INTO TABLE ppd.mytab;
Query OK, 101 rows affected (0.03 sec)
Records: 101 Deleted: 0 Skipped: 0 Warnings: 101

It says Warnings: 101 and I would like to view these warnings so I know what to fix. How can I do this? I have looked up the documentation online and it only talks about the SHOW WARNINGS command which was implemented in mysql V. 4.1+. How can I show the warnings in my version? Thanks
 
Warnings are written to the log by default I believe since 3.23. You could grep through the log for warnings.
 
Sorry, still can't find the warnings. I looked through the error log in the data directory and it only has mysql shutdowns and errors, not warnings. Can anyone give me more specific instructions on how to find out about warnings? Also, just letting you know that this is a windows machine.
 
Sorry...I have 0 mySQL experience on Windows. What GUI client are you using? I would imagine there would be an option to log warnings.
 
I have mysqladmin and mysql control panel however neither of those have options for warnings. mysqladmin has bare minimum options for logs and all it shows is server shutdowns and startups + connections to the server. No warnings or queries or anything. Other than that I just use the mysql command prompt.
 
You must log in or register to reply here.
Back
Top