I am running a site with php and mysql. I want to keep the record of all add, update, delete/DML queries which daily run on mysql server in a file.
Please let me know how can i take the history of all those queries in a file.

Are you looking for a MySQL logging file, or do you want to write the activites to a file in your code i.e. adding functionality to the php function you might call to execute a MySQL query?

Matthew McNicol