RE: to track the changes in database mySQL

[Jimmy Guerrero]

Hello,

Something to keep in the back of your mind, is in the latter part of next
year we will be enabling the option to log all/some DDL, DCL, SELECTs, DML
and Server Admin commands and its associated ID, IP, timestamp, etc.

At that point you'll be able to filter, sort or delete audit data to suit
your needs.

Thanks,

Jimmy Guerrero, Senior Product Manager
MySQL Inc, www.mysql.com    
Houston, TX USA




-----Original Message-----
From: Logan, David (SST - Adelaide) [mailto:David.Logan@stripped] 
Sent: Monday, December 12, 2005 11:14 PM
To: Satyanarayana_Kesani; mysql@stripped
Subject: RE: to track the changes in database mySQL


Hi Satya,

You might like to look at triggers here
http://dev.mysql.com/doc/refman/5.0/en/triggers.html You can set a trigger
to go off at any of the events you have noted below. This would allow you to
log the userid and any other relevant information you need.

Regards

David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia

[phone] - Work
[phone] - Mobile
[phone] - Fax


-----Original Message-----
From: Satyanarayana_Kesani [mailto:Satyanarayana_Kesani@stripped] 
Sent: Tuesday, 13 December 2005 3:13 PM
To: mysql@stripped
Subject: to track the changes in database mySQL

Hi all,
I got this mail Id from mySQL lists.I would like to request you for one
help. Actually I need to track the changes(UPDATE,INSERT,DELETE and others)
done on the database in mySQL by different users. I need to know which user
has done what changes . I am using mySQL 5.0.16-nt. I would like to know how
I can create binary log or some other log for the same? Could you please
help me on this? 
 
Thanks in advance
 
Thanks&Regards,
   Satya
 


DISCLAIMER:
This email (including any attachments) is intended for the sole use of the
intended recipient/s and may contain material that is CONFIDENTIAL AND
PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or
distribution or forwarding of any or all of the contents in this message is
STRICTLY PROHIBITED. If you are not the intended recipient, please contact
the sender by email and delete all copies; your cooperation in this regard
is appreciated.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1