homepage Welcome to WebmasterWorld Guest from 107.20.34.144
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
MySql change log
Has anyone had experience of seen a site that describes how to make it?
8kobe

5+ Year Member



 
Msg#: 3563864 posted 2:18 pm on Feb 1, 2008 (gmt 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.

 

phranque

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



 
Msg#: 3563864 posted 2:19 pm on Feb 1, 2008 (gmt 0)

a wiki?

jatar_k

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



 
Msg#: 3563864 posted 2:23 pm on Feb 1, 2008 (gmt 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

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved