RE: Tracking changes in the database

2005-10-13 Thread Andre Matos
, but the "binary.log" file was not created. Note: I am using Mac OS X. Andre -- Andre Matos [EMAIL PROTECTED] -Original Message- From: Daniel Kasak [mailto:[EMAIL PROTECTED] Sent: Thursday, October 13, 2005 2:33 AM To: Andre Matos; mysql@lists.mysql.com Subject: Re: Tracking

Re: Tracking changes in the database

2005-10-13 Thread Ehrwin Mina
You can also set a plain logging of mysql activity by enabling this in my.cnf log= /tmp/mysqld.log tmpdir = /tmp/ restart mysql Thanks, At 02:32 PM 10/13/2005, Daniel Kasak wrote: Andre Matos wrote: I am using InnoDB and replication, is there any issues? Thanks. Andr

Re: Tracking changes in the database

2005-10-12 Thread Daniel Kasak
Andre Matos wrote: I am using InnoDB and replication, is there any issues? Thanks. Andre It depends what you're doing. If you use the binary log, there are no issues - in replication uses the binary log to achieve it's goals. Since the plain-text log is depreciated, you probably should lea

RE: Tracking changes in the database

2005-10-12 Thread Andre Matos
I am using InnoDB and replication, is there any issues? Thanks. Andre -- Andre Matos [EMAIL PROTECTED] -Original Message- From: Daniel Kasak [mailto:[EMAIL PROTECTED] Sent: Thursday, October 13, 2005 1:01 AM To: Andre Matos; 'mysql@lists.mysql.com ' Subject: Re: Tracking

Re: Tracking changes in the database

2005-10-12 Thread Daniel Kasak
Andre Matos wrote: Hi List, I need to track the changes made in the database using the insert, update and delete statements in MySQL 4.1.9. Can I use the "Binary Log" to get this information or is there another better solution? Thanks for any help. Andre The binary log is the recommended