Welcome to WebmasterWorld Guest from 54.234.45.10

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

10+ 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:11134
votes: 115


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:15756
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

 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members