Description:
When executing a mysqldump file containing hundreds of thousands or records, I get a
large number of warnings, but I'm never told what the warnings are, nor does there seem
to be any way of finding out at the time or having them logged. It seems the only thing I
can do is log everything verbosely, then manually search through the monstrous dump files
to find the error messages.
The log_warnings system variable seems to do nothing, nor does it appear to be properly
documented (it's mentioned in passing, but nowhere are its values explained).
Lack of this is going to cost me literally days of work that I will have to repeat every
time I want to do this kind of import, and I can't believe that no-one wants to see
warnings. I've rated this S3 as it's more than a cosmetic oversight - it's almost enough
to make me stop using mysql altogether. I notice in other places that you're doing quite
the opposite! http://bugs.mysql.com/bug.php?id=6662
I'm observing this in 4.1.10, but I suspect that it is doing the same in earlier
versions.
How to repeat:
Execute a mysqldump file that generates warnings in the mysql client.
Attempt to find out what the warnings are.
Suggested fix:
Document the log_warnings variable.
Allow warnings to be logged to either the main error log, or a custom client-side log, or
add the ability to display warnings as they occur, rather than just their count. Perhaps
amend the verbose output handler to issue a 'SHOW WARNINGS' if warnings > 0.
