Hi.
Hope I've got the list sorted out right - I'm sure someone will tell me
if not. ;)
Has anyone got any good ideas or examples for doing version control on
changes to fields in MySQL tables? In many tables I'd like all changes
to fields to be recoverable back to any date-time in the past, without
changing the current state of the database tables (therefore, not
involving any actual restore of backups the database).
My current idea is to maintain a change-log table, something like {
TABLE_NAME, FIELD_NAME, OLD_VALUE, TIMESTAMP }, to be updated each time
a field is changed, which ought to allow me to rollback all changes to a
table or a field. But this feels a bit simplistic and kludgy - does
anyone have any more cunning ideas? Could the database's own logs be
used to achieve the desired result? Are there any built-in features that
might help?
Thanks in advance.
Richard Davis
University of London
---------------------------------------------------------------------
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
