Bug #18738 Can't create log, neither in file nor in table

• Submitted: 3 Apr 2006 14:30
• Modified: 4 Dec 2006 14:16
• Reporter: Tonci Grgin
• Status: Can't repeat
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 5.1.7-beta-nt-max-log
• OS: Windows (WINXP SP2)
• Assigned to: Alexey Botchkov
• CPU Architecture: Any

[3 Apr 2006 14:30] Tonci Grgin

Description:
Taken in consideration texts in manual, there is no combination of switches (--log-output... as you can see from my.ini file) that starts MySQL general log or slow query log.

5.1.7-beta-nt-max-log, WINXP SP2
my.ini
# The MySQL server
[mysqld]

# set basedir to your installation path
basedir=C:/mysql507
# set datadir to the location of your data directory
datadir=C:/mysql507/data
port		= 3306
#socket		= /tmp/mysql.sock
enable-named-pipe
socket = mypipe1
skip-locking
key_buffer = 16K
max_allowed_packet = 8M
table_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 8K
thread_stack = 64K

#tried all combinations of following:
#log-output=FILE
log
#=C:/mysql507/data/tong1.log
log-slow-queries
#=C:/mysql507/data/tong1slow.log

How to repeat:
Start 5.1.7-beta-nt-max-log on WINXP SP2 with logging option.

Suggested fix:
None that I think of.

[5 May 2006 10:44] Victor Pyankov

mysql-noinstall-5.1.9-beta-win32.zip don't have CSV engine support:

have_archive,YES
have_bdb,YES
have_blackhole_engine,YES
have_compress,YES
have_crypt,NO
have_csv,NO
have_dlopen,YES
have_example_engine,YES
have_federated_engine,YES
have_geometry,YES
have_innodb,YES
have_partitioning,YES

[4 Dec 2006 14:16] Alexey Botchkov

Tried it with all the 5.1, everythig logged fine. Maybe this issue was fixed meanwhile

[4 Dec 2006 14:20] Alexey Botchkov

> mysql-noinstall-5.1.9-beta-win32.zip don't have CSV engine support:

5.1.12 has it - try newer version