Sample Header Ad - 728x90

Implementing a Record Keeper/Rollback System for a MySQL Database

1 vote
1 answer
1011 views
What's the best way to create a record keeping table for all actions in my database? I have a number of tables inside one database and I want to create another that records all movements in every other table - adds, removals, delete and edits, which can then be reviewed by a user with top-level administrative privileges and reversed if necessary at the click of a button. Is there a tried and tested method for this **or** a native feature of (InnoDB) MySQL useful for this? If possible, can you point me to resources specific to this please. I'm working on my first database so I apologise if this has been asked here before, but I couldn't find it.
Asked by Dom (113 rep)
Jun 28, 2013, 06:46 PM
Last activity: Jun 29, 2013, 11:15 AM