Hello, Yes, the binary log will probably get the job done if its just data modifications you're after and you're archiving those logs to suit your needs. However if you'd like to also track other things like SELECTs, enabling the general query log might be a better option. Starting MySQL with the --log option will create the query log. Note, there are some important differences between the bin and query log. See http://dev.mysql.com/doc/refman/5.0/en/query-log.html for more info.
Thanks, Jimmy -----Original Message----- From: Satyanarayana_Kesani [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 13, 2005 7:28 AM To: Jimmy Guerrero; Logan, David (SST - Adelaide); mysql@lists.mysql.com Subject: RE: to track the changes in database mySQL Thanks Jimmy, I would like to get one thing clarified from you is: Am I able to create a binary log (may be some other log) to know the changes done on my database(any updations,deletion of records,addition of new records) in MySQL by different users? Thanks a lot, Satyanarayana Reddy From: Jimmy Guerrero [mailto:[EMAIL PROTECTED] Sent: Tue 12/13/2005 6:44 PM To: 'Logan, David (SST - Adelaide)'; Satyanarayana_Kesani; mysql@lists.mysql.com Subject: RE: to track the changes in database mySQL 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:[EMAIL PROTECTED] Sent: Monday, December 12, 2005 11:14 PM To: Satyanarayana_Kesani; mysql@lists.mysql.com 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 +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -----Original Message----- From: Satyanarayana_Kesani [mailto:[EMAIL PROTECTED] Sent: Tuesday, 13 December 2005 3:13 PM To: mysql@lists.mysql.com 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/[EMAIL PROTECTED] 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/[EMAIL PROTECTED]
