So, what can you do? Create a log table? Sprinkle your code with
SELECT 'Debug: ...'statements?
At the UDF Repository for MySQL, we now have a solution to log messages to the MySQL error log: a user-defined function called
Currently it is all very crude: the
log_errorfunction takes one argument and writes it to the mysql_error log, appending a line terminator.
Please try it out, and let us know if you have comments or suggestions to improve. Thanks in advance,