How can I record mysql queries in a log file

[matthew1471]

Does anyone know of any software that I can use to record mysql queries as they are run?

Basically, I've got wpmu running locally on my laptop, and want to record what queries are used to create a new blog, so i can write a script to streamline the process.

Cheers

 

[jryan21]

i would guess that you could get what you are looking for from the mysql general query log. What you need to do to get at it depends on your setup; check the mysql documentation to see which commands work best for you.

 

[matthew1471]

I found out how to do this...

add the following to my.ini, and it creates a file called query.log in \mysql\data\

[mysqld]
log = query.log

Hope that helps someone!