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

Reply via email to