Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I've got mysql logging log_slow_queries or whatever, and had turned on all query logging for a moment before I found it to just be spammy and thus useless.

How can I log only mysql queries that result in syntax errors?

share|improve this question

1 Answer 1

You should look at the general log:


share|improve this answer
Right, I should have been more clear that I already checked that log out, I was hoping that there was a way to view queries with improper syntax and ignore queries that have the proper syntax. Because viewing everything in the log is so spammy that it's useless. –  Kzqai Apr 11 '11 at 22:54
All I can suggest to better filter the queries is to store them in a table instead of a file. I am not sure about a specific error log option in MySQL. –  Raisen Apr 11 '11 at 23:00

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.