Try putting in a full existing pathname the server has write access to as opposed to just a file name.
Walter Heck On Sun, May 17, 2009 at 12:13 PM, mos <mo...@fastmail.fm> wrote: > I'm having a problem defining slow logging file in my.ini (Windows XP). I'm > using MySQL 5.1.30. > > In the MySQL reference manual it says: > As of MySQL 5.1.29, the --log-slow-queries option is deprecated and will be > removed (along with the > log_slow_queries system variable) in MySQL 7.0. Instead, use the > --slow_query_log option to enable the slow query > log and the --slow_query_log_file=file_name option to set the slow query log > file name. > So my.ini has: > > [mysqld] > general_log=1 > log-output=FILE > general_log_file=LOG.TXT > slow_query_log=1 > slow_query_log_file=SLOWLOG.TXT > > After I restart MySQL, the variables have: > Variable_name Value > ------------------------------- ------------------------------ > log ON > log_bin OFF > log_output FILE > log_queries_not_using_indexes OFF > log_slow_queries ON > log_warnings 1 > slow_query_log ON > slow_query_log_file OFF > sql_log_bin ON > sql_log_off OFF > sql_log_update ON > > > So why is the variable "slow_query_log_file" set to "OFF" because it is not > boolean and should be a file name? Why isn't it set to the file name > "SLOWLOG.TXT"? > > TIA > Mike > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=li...@olindata.com > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org