Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Audit Trail

Posted on 2004-04-19
1
Medium Priority
?
623 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 80 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

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month15 days, 17 hours left to enroll

580 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