"Philip Molter" <[EMAIL PROTECTED]> wrote: > We've got a fairly critical database system that we're setting up > and we need to know if there's an easy way to track changes made > to the database (hopefully at a fairly low level). > > In essence, what we want, is a log of what fields and values are > changed by the primary key on each table, including timestamps of > said changes.
mysqld can be started with several logging options. Run "./mysqld --help | grep log" for details (and read the manual). Transactions are an option, but I have no experience with them outside of PostgreSQL so I'll let someone else touch on that. -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.com/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
