Tracking all DML and DDL Statements in Database Tables

ScarletPimpernal ScarletPimpernal is offline

Member

Join Date: Mar 2007

Posts: 39

#1: Jul 5 '07

Hi Friends,

I want to know one thing, i have a database which contains few tables and few default records in that.

Sometimes unusually some developer is truncating the tables or else dropping the table without my knowlege.

How can i track these changes in my database?

Any answers will be most welcome and useful for me.

In Oracle, i heard that there are DDL and DML Triggers available but iam new to MYSQL. can anyone tell me is that any functionality available in MYSQL?

Thanks

« previous question | next question »

Similar MySQL Database bytes

INSERT statements not INSERTING when using mysql from python (answers)
Tracking structural changes from psql (answers)
Tracking structural changes from psql (answers)
Tracking record insertion and deletion (answers)

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,501 network members.