Welcome to WebmasterWorld Guest from 23.22.250.113

Forum Moderators: open

Message Too Old, No Replies

MySql change log

Has anyone had experience of seen a site that describes how to make it?

     

8kobe

2:18 pm on Feb 1, 2008 (gmt 0)

5+ Year Member



I have a site that I am going to have quite a few people helping with (20-30). What I need is a way to log every change down to the database and also have an easy way of "rolling" it back at a later date if I need to. I am using innodb tables and I think the best way to do it is a trigger that looks for changes. Am I right or is there a much better approach? Looking for some advice on the smart way to do it.

phranque

2:19 pm on Feb 1, 2008 (gmt 0)

WebmasterWorld Administrator phranque is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month



a wiki?

jatar_k

2:23 pm on Feb 1, 2008 (gmt 0)

WebmasterWorld Administrator jatar_k is a WebmasterWorld Top Contributor of All Time 10+ Year Member



in some applications we have just used tables for logging

old data gets dumped to a log table and then new data is written to the active table

 

Featured Threads

Hot Threads This Week

Hot Threads This Month