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]

Reply via email to