Welcome to WebmasterWorld Guest from 107.20.54.98

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?

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

Junior Member

5+ Year Member

joined:Sept 10, 2007
posts: 50
votes: 0


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.
2:19 pm on Feb 1, 2008 (gmt 0)

Administrator

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

joined:Aug 10, 2004
posts:10544
votes: 8


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

Administrator

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

joined:July 24, 2001
posts:15755
votes: 0


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