homepage Welcome to WebmasterWorld Guest from 50.17.107.233
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Accredited PayPal World Seller

Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

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




msg:3563866
 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




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

a wiki?

jatar_k




msg:3563873
 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.
Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About
© Webmaster World 1996-2014 all rights reserved