List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:July 28 2009 5:47pm
Subject:Re: tracing table updates
View as plain text  
Ron

 > I would like to log all updates for a certain, only updates, not 
inserts, is it possible?

Sure. For a review of methods for various kinds of audit trails see 
"Audit Trails" Parts I & II at 
http://www.artfulsoftware.com/infotree/mysqltips.php.

PB

----

Ron wrote:
> Hi All,
>
> I have a mysql cluster setup with 2 nodes. I would like to log all 
> updates for a certain, only updates, not inserts, is it possible?
>
> would i be able to tell when it was updated and from what IP address 
> the update came from?
>
> coz i have an issue wherein a certain table is being updated but i 
> could not tell where or when. thanks in advanced.
>
> Regards,
> Ron
>
> ------------------------------------------------------------------------
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com 
> Version: 8.5.392 / Virus Database: 270.13.34/2268 - Release Date: 07/28/09 06:00:00
>
>   

Thread
tracing table updatesRon28 Jul
  • Re: tracing table updatesPeter Brawley28 Jul
    • Re: tracing table updatesRon29 Jul