PDA

View Full Version : logging for a MySQL database



brenthberry@Yahoo.com
03-03-2010, 05:10 PM
I am designing the database for my website. I am using MySQL, and am at the point where I'm figuring out how I want to handle event logging.
The database has accounting and content management elements to it, and I would like to be able to track all the changes made to the database.

I was looking around CPanel for MySQL logging information, but couldn't figure out where I would find the logs.

Does hostmonster allow logging for MySQL?
If so, where can I find the information on how to start it, and where to find the logs.

By understanding my options with MySQL through hostmonster, I can determine whether it would be feasible to use the logging functions in MySQL, or whether I will need to create tables in my database that I can use as such.

Thanks in advance for any help! :)

albert
03-06-2010, 06:39 AM
maybe this would work for you?
http://dev.mysql.com/doc/refman/5.1/en/triggers.html