How do I start Logging on Windows Live MySQL Server?

[Chris Gilbert]

Can someone tell me what is the best way to start the MySQL Logging on an actual production database on Windows.

As I understand it, the server has to be shut down for the logging to be successfully started. Is this correct?

I have been experimenting on a local MySQL server to make sure I know what to do on the production server. My production server has a my.ini file at the location c:\Program Files\MySQL\MySQL Server 4.1\my.ini with various config stuff in it. Would it be ok for me to add the following under the [mysqld] part of the file:

log=/logs/mysqld.log

Thus creating a file named 'mysqld.log' in the folder 'logs'.
The main things I need to log are the SQL Statements being executed and the IP Addresses/hostname of the connections. What type of log would be best for this? Also how do I make it so that the log doesn't grow ridiculously large?

Thanks in advance,

Chris