Is there any utility in MySQL as I want to make a history/Log file of all DML statements excluded from PHP script. The file will be similar to the history file maintained by MySQL client. Whenever we write query in MySQL client it is also recorded in some history file, the queries we executed before, we could see them in lower MySQL client window, and these comes from that history file. I want the same criteria for PHP, when ever my PHP script execute a query by mysql_query($query) command it is recorded in some log/history file maintained by the server.
Please tell me how I could set up my MySQL server so it makes a log file of DML queries for me. The MySQL server software I am using is mysql-4.0.18-win and using PHP4 for scripting.