Solved

Audit Trail

Posted on 2004-04-19
1
607 Views
Last Modified: 2008-02-01
Hi, I am a newcomer for the EE. I am a student and now I have a few questions to ask , hope that you can help me out.

These are my system development tools ->
Database : Mysql
Language : JSP,java,js

I got to do a audit trail report which is keep track what data in the database have been changed by users.
This report will show all the changes to master data.
In order to do this report, I got to keep track every data in the database so that I can know what data have been changed and when it changed.
 
Can I know Mysql got provide any build-in functions so that I can check it out when and what data has been changed for each table?

If there is no build-in function, do you have any advise for me in order to complete this assignment?

Thank you.

0
Comment
Question by:ttlguk
1 Comment
 
LVL 2

Accepted Solution

by:
chrisbolt earned 20 total points
ID: 10940208
Enable mysql's binary log, which is usually meant for replication.

http://dev.mysql.com/doc/mysql/en/Binary_log.html
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now