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

Tracking changes in the database

2005-10-12 Thread Andre Matos
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 -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mail