Re: tracing table updates
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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: tracing table updates
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
tracing table updates
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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org