RE: Tracking changes in the database
It did not work Daniel. I added this into my.cnf file: [mysqld] log-bin=/var/log/mysql/binary.log and saved the file in two places: /etc/my.cnf /usr/local/mysql/my.cnf Then, I restart the server: sudo /Lybrary/StartupItems/MySQLCOM restart I also did two UPDATE, one INSERT, and one DELETE, 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 changes in the database 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 learn to use the binary log. As I noted before, the plain-text log has some issues. I'm not sure what all of them are, but I've encountered issues when using plain-text logs and temporary tables ( eg 2 users create temporary tables - in the plain text log, it looks like the 1 user ). -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Tracking changes in the database
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. 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 learn to use the binary log. As I noted before, the plain-text log has some issues. I'm not sure what all of them are, but I've encountered issues when using plain-text logs and temporary tables ( eg 2 users create temporary tables - in the plain text log, it looks like the 1 user ). -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Ehrwin C. Mina 9/F Tower 2 RCBC Plaza 6819 Ayala Avenue cor. Sen. Gil J. Puyat Avenue Makati City 1200 Philippines Cell (63 918) 930 4383 (63 917) 845 2102 Tel(63 2) 757 2633 Fax(63 2) 757 2633 Email [EMAIL PROTECTED] Webwww.chikka.com This message and any attachment are confidential and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, you must not copy this message or attachment or disclose the contents to any other person. If you have received this transmission in error, please notify the sender immediately and delete the message and any attachment from your system. Chikka does not accept liability for any omissions or errors in this message which may arise as a result of E-Mail-transmission or for damages resulting from any unauthorized changes of the content of this message and any attachment thereto. Chikka does not guarantee that this message is free of viruses and does not accept liability for any damages caused by any virus transmitted therewith. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Tracking changes in the database
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 learn to use the binary log. As I noted before, the plain-text log has some issues. I'm not sure what all of them are, but I've encountered issues when using plain-text logs and temporary tables ( eg 2 users create temporary tables - in the plain text log, it looks like the 1 user ). -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Tracking changes in the database
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 changes in the database 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 way. There's also a plain-text log, but you'll run into issues if you're using temporary tables, amongst other things. Also, the plain text log has been removed from 5.0.x ( I believe ). You can enable either with startup switches or with entries in the my.cnf file. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Tracking changes in the database
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 way. There's also a plain-text log, but you'll run into issues if you're using temporary tables, amongst other things. Also, the plain text log has been removed from 5.0.x ( I believe ). You can enable either with startup switches or with entries in the my.cnf file. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]