MySQL, SQL, Query ... Does anyone know of a transaction history utility for MySQL? What I am looking for is something that logs a before/after entry anytime a change occurs in a MySQL table. I want to be able to say definitively "these changes occurred at these times".
There are, of course, two current ways to do this: a) Do it in userland code The obvious caveat is that you don't catch changes made at the MySQL command prompt or by anything that doesn't connect through your userland code. b) Use binlogging, rollback your log to the specified point in time, and then compare the databases before and after and log The caveat there is that it's incredibly resource intensive, and AFIAK, there is no way to easily diff a database Has anyone maybe written an extension to MySQL to support this? I realize that a system running such an extension would probably be much busier, but for some things, the binlog just doesn't contain enough information to logically say, "Okay, this is the change that was made and this was what was changed as a result." Thanks, Philip * Philip Molter * Texas.net Internet * http://www.texas.net/ * [EMAIL PROTECTED] --------------------------------------------------------------------- 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
