-   Linux - Software (
-   -   Mysql logging for specific table activity (

mycoolwater 09-21-2009 07:26 PM

Mysql logging for specific table activity
How do you guys to do just that? I know the option for global logging, with parameters --log on service run or log-bin and err-log for inside my.cnf. But what i am looking for is a way to log specifically a table activity, any activity, be it select or update queries.

3rd party solution is welcome too...

chrism01 09-21-2009 08:17 PM

I think you can either read the binary log


Add triggers to the table in qn, and write to an audit table and then 'read' the audit table.

All times are GMT -5. The time now is 03:41 PM.