problems with sql.log

[tuofeiger]

Hi,

I have a mysql install on windows to play with but in the root directory there is a sql.log file which I suspect is property of MySQL (the only sql server I'm running) but it grew to 165 mb which is ridiculously large for a development server with no active databases. How do I set the log file to a different directory? I tried mysql.ini but there's no line there to set the log file path,

Thanks!

 

[tshot]

i am not sure about win. but in linux there is nof ile as sql.log for mysql. the names are HOSTNAME.log for general log and HOSTNAME.nnn for update log where hostname is the name where mysqlserver is running
general log - client connections, queries and various misc events
update log - reports queries that modify database

in mysql the log files are either started from mysqld script (mysql server starting script) or in options file my.cnf

u can use set command to disable them
set SQL_LOG_OFF = {0 | 1) for enable disbale logging of
set SQL_LOG_UPDATE = {0 | 1 } like above but for update log only




----------------
ur feedback is a very welcome desire

 

[tuofeiger]

Okay thanks anyway. The problem is indeed not with MySQL but with windows. Windows ODBC Datasource administrator traces all ODBC calls in a sql.log file, in this case the MySQL ODBC connection.