Log Mysql warnings

Question

I'm trying to get Mysql to log all warnings to the log file. I'm running stored procedures, and I want to get at the warnings they generate.

Answer 1

Assuming that you have administrator privilege then you need to change the server configuration. You can do this by using the MySQL server tools (workbench is the latest) or by editing the my.ini file directly.

remember to turn on general logging. Here's an entry for writing Errors to a logfile:

general-log=1
log-error = "C:\Program Files\MySQL\MySQL Server 5.1\logfiles\ErrorMessages.log"

edit

Ah. Here's an extract from my 5.0.51b server my.ini file

log-queries-not-using-indexes
log-warnings
long_query_time = 2
log = "C:\Program Files\MySQL\MySQL Server 5.0\logfiles\querylog.log"
log-slow-queries = "C:\Program Files\MySQL\MySQL Server 5.0\logfiles\SlowQueryLog.log"
log-error = "C:\Program Files\MySQL\MySQL Server 5.0\logfiles\ErrorLog.log"