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

Thanks for your help. I now created a trigger that would do an insert on 
another table on what changes has been made to the other table.

another question is, is it possible to get the host from where the 
update request came from from the trigger?

Regards
Ron

Peter Brawley wrote:
> 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