FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


mySQL Audit Trail option?





charliehk
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?
JustaMin
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.
charliehk
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?
Related topics
Forum
[gnu/Linux] ALSA Error on Rhythmbox
MySql to SQL
MySQL and PHP problem in the future
VB + MYSQL
mysql errors. No error given by mysql_error()
MySQL, ports?
CMS for Personal Homepage
php-mysql source code
Biggest Environmental Threat.
Experience of emoving mysql in debian forcefully
mysql databases
UTF-8 from MySQL to PHP
E-Voting system easily hacked.
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.