howto Save all queries in mysql to a file

[AffiliateDreamer]

Hi,

Is it possible to save all queries that my web applications send to my mysql database to a file?

I want to trace things in an application, so after I view a few pages I would like to open up a file that has all the queries that mysql handled during that time.

[phranque]

you probably want to turn on the general query log [dev.mysql.com].

[AffiliateDreamer]

generally, will I be able to do this in a shared hosting environment?

[phranque]

you will have to restart the mysql server as described in the linked reference.
if this isn't an option you could implement query logging in your db abstraction layer...