Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I want to log every insert,delete,update (successfully written) queries using mysql ? I tried following ways

1) used triggers ( but i can't get the SQL query );

2) show processlists ( only showing select queries )

3) mysql proxy ( didn't try but heard that can be monitor queries )

How can i achieve this ?

share|improve this question
add comment

1 Answer 1

Did you think about using another table as Log, that for every other table you create a trigger after each statement, and log the table ==> TableName,StatementType(INSERT,DELETE,UPDATE),time? and when ever you want to check the data, just simple select from that table?

share|improve this answer
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.