Logfile

[joe_need_help]

Hi all,

Is it possible to create a logfile in mysql where I can see what and when someone change my datas ?

Thanx for help

Joe

[Anon]

Sure, just create a file, change permissions on it so your script can write to it. Then every time something happens that you want to log, open the text file and append your data to the end of it.

You could also store your logs in a DB, just depends on your preferences and how much logging you are doing.

[joe_need_help]

Hi David,

thanx for reply !

I am new in mySQL and i do not understand everything. --> Sorry.

What kind of script should be written, and what should it contens (the file and the script).

And how can I store the logs in a DB ?

Joe

[Anon]

how about timestamp in mysql?

set it to null and it will update everytime the record is updated.

then, you will create a function that will update this record when that file is updated / accessed.

instead of update in your SQL query, you could insert a new record, then every update is recorded / logged.

[joe_need_help]

Hi Kai,

what kind of function do u mean that will update the record when the file is updated ?

Thanx

Joe