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
add comment

1 Answer 1

You should look at the general log:

http://dev.mysql.com/doc/refman/5.5/en/query-log.html

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
add comment

Your Answer

 
discard

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.