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]