Is there any option in mySQL supporting Audit Trail? That is, an option for starting mySQL so that any change in data will be logged somewhere.
If so, could anyone show how the option is used?
I dont know of any MySQL function to do that (not to say there isnt one, i just don't know one). You could write a PHP script to log any queries run though, but I assume you want a record of what data has changed?
I can tell you that it's definitely possible as ive seen it done, but I dont know whether that was with a more complex PHP script or MySQL itself (I suspect it's the former). Maybe a MySQL guru will be able to help, but i'd imagine you'll need a script to do this.
Well, if there are a lot of places doing the update, it is hard to include data logging code in each place.
So is there a simple way to do it?