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]
