Сервис MySQL установлен следующей строкой:
mysqld-nt --install MySQL --defaults-file="d:\web\mysql\conf\my.conf"
Код:
[client]
port=3306
character-sets-dir=d:/web/mysql/share/charsets
default-character-set=cp1251
[mysqld]
port=3306
key_buffer_size=256k
set-variable = max_allowed_packet=1M
thread_stack=128k
table_cache=16
sort_buffer_size=256k
set-variable = net_buffer_length=2K
server-id = 1
basedir = d:/web/mysql/
datadir = d:/web/mysql/data/
tmpdir = d:/web/temp/
query_cache_limit=1M
query_cache_size=8
safe-user-create
skip-show-database
skip-innodb
log-warnings
log=d:/web/apache/logs/mysql_query.log
log-bin=d:/web/apache/logs/mysql_binary.log
log-error=d:/web/apache/logs/mysql_error.log
log-slow-queries=d:/web/apache/logs/mysql_slowq.log
log-update=d:/web/apache/logs/mysql_update.log
log-isam=d:/web/apache/logs/mysql_isam.log
max_binlog_size=16M
long_query_time=2
slow_launch_time=2
bind-address=127.0.0.1
character-sets-dir=d:/web/mysql/share/charsets
default-character-set=cp1251
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[mysql]
no-auto-rehash
default-character-set=cp1251
[isamchk]
set-variable = key_buffer=8M
set-variable = sort_buffer=8M
[myisamchk]
set-variable = key_buffer=8M
set-variable = sort_buffer=8M
[mysqlhotcopy]
interactive-timeout
Так удобнее.
[s]Исправлено:
Prisoner, 5:16 17-10-2004[/s]