homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

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?

 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.



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

a wiki?


 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