From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Mysqld-max does not read my.ini config file
Description:
While i was using mysqld-opt my.ini file was working properly.
I am using c:\windows\my.ini file. in file i specified mysql work path.
It was working with mysqld-opt. But not working with mysqld-max.
My mysql path is d:\mysql
but is it giving an error when run server like :
file 'c:\mysql\\share\charsets\?.conf' not found (errcode: 2)
Character set '#30' is not a compiled character set and is not
specified in the 'c:\mysql\\share\chatsets\Index' file
My mysql path is d:\mysql.
Myvariables are included the beginning of the mail.
So if it accepts from my.ini and shows it as a correct variable
why does this error occurs ?
How-To-Repeat:
Just run mysqld-max
Fix:
Synopsis: <synopsis of the problem (one line)>
Submitter-Id: <submitter ID>
Originator: Yusuf INCEKARA
Organization: Avukatpro Limited Sirketi
MySQL support: none
Severity: serious
Priority: high
Category: [mysqld, mysqld-max ]
Class: [ sw-bug ]
Release: mysql-3.23.38-max
Exectutable: [mysqld-max]
Environment: PIII with 128 MB RAM
System: <Bug both in Win95, NT >
Compiler: VC++ 6.0
Architecture: i386
| Variable_name | Value
| ansi_mode | OFF
| back_log | 50
| basedir | d:\mysql\
| bdb_cache_size | 4194304
| bdb_log_buffer_size | 32768
| bdb_home | d:\mysql\data\
| bdb_max_lock | 10000
| bdb_logdir |
| bdb_shared_data | OFF
| bdb_tmpdir | c:\temp\
| bdb_version | Sleepycat Software: Berkeley DB 3.2.9a:
(May 8, 2001)
| binlog_cache_size | 32768
| character_set | latin5
| character_sets | latin1 big5 czech euc_kr gb2312 gbk sjis
tis
620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew
win1
251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5
|
| concurrent_insert | ON
| connect_timeout | 5
| datadir | d:\mysql\data\
| delay_key_write | ON
| delayed_insert_limit | 100
| delayed_insert_timeout | 300
| delayed_queue_size | 1000
| flush | OFF
| flush_time | 1800
| have_bdb | YES
| have_gemini | NO
| have_innodb | DISABLED
| have_isam | YES
| have_raid | NO
| have_ssl | NO
| init_file |
| innodb_data_file_path |
| innodb_data_home_dir |
| innodb_flush_log_at_trx_commit | OFF
| innodb_log_arch_dir |
| innodb_log_archive | OFF
| innodb_log_group_home_dir |
| interactive_timeout | 28800
| join_buffer_size | 131072
| key_buffer_size | 16773120
| language | d:\mysql\share\english\
| large_files_support | ON
| log | OFF
| log_update | OFF
| log_bin | OFF
| log_slave_updates | OFF
| long_query_time | 10
| low_priority_updates | OFF
| lower_case_table_names | 1
| max_allowed_packet | 1047552
| max_binlog_cache_size | 4294967295
| max_binlog_size | 1073741824
| max_connections | 100
| max_connect_errors | 10
| max_delayed_threads | 20
| max_heap_table_size | 16777216
| max_join_size | 4294967295
| max_sort_length | 1024
| max_user_connections | 0
| max_tmp_tables | 32
| max_write_lock_count | 4294967295
| myisam_recover_options | OFF
| myisam_max_extra_sort_file_size | 256
| myisam_max_sort_file_size | 2047
| myisam_sort_buffer_size | 8388608
| net_buffer_length | 16384
| net_read_timeout | 30
| net_retry_count | 10
| net_write_timeout | 60
| open_files_limit | 0
| pid_file | d:\mysql\data\admin.pid
| port | 3306
| protocol_version | 10
| record_buffer | 131072
| query_buffer_size | 0
| safe_show_database | OFF
| server_id | 0
| skip_locking | ON
| skip_networking | OFF
| skip_show_database | OFF
| slow_launch_time | 2
| socket | MySQL
| sort_buffer | 2097144
| table_cache | 64
| table_type | BDB
| thread_cache_size | 0
| thread_stack | 131072
| transaction_isolation | READ-COMMITTED
| timezone | YFT Yaz Saati
| tmp_table_size | 1048576
| transaction_isolation | READ-COMMITTED
| timezone | YFT Yaz Saati
| tmp_table_size | 1048576
| tmpdir | c:\temp\
| version | 3.23.38-max
| wait_timeout | 28800
my.ini file :
located in c:\windows\my.ini
[mysqld-max]
basedir=D:/mysql/
datadir=D:/mysql/data/
language=D:/mysql/share/english/
character-sets-dir=D:/mysql/share/charsets/
default-table-type=BDB
port=3306
set-variable=key_buffer=16M
set-variable=max_allowed_packet=1M
set-variable=thread_stack=128K
default-character-set=latin5
set-variable=bdb_cache_size=4M
set-variable=bdb_max_lock=10000
skip-gemini
skip-innodb
[mysqld-nt-max]
basedir=D:/mysql/
datadir=D:/mysql/data/
language=D:/mysql/share/english/
character-sets-dir=D:/mysql/share/charsets/
default-table-type=BDB
port=3306
set-variable=key_buffer=16M
set-variable=max_allowed_packet=1M
set-variable=thread_stack=128K
default-character-set=latin5
set-variable=bdb_cache_size=4M
set-variable=bdb_max_lock=10000
skip-gemini
skip-innodb
[myodbc]
basedir=D:/mysql/
datadir=D:/mysql/data/
language=D:/mysql/share/english/
character-sets-dir=D:/mysql/share/charsets/
default-table-type=BDB
port=3306
set-variable=key_buffer=16M
set-variable=max_allowed_packet=1M
set-variable=thread_stack=128K
default-character-set=latin5
set-variable=bdb_cache_size=4M
set-variable=bdb_max_lock=10000
skip-gemini
skip-innodb
[mysqld]
basedir=D:/mysql/
datadir=D:/mysql/data/
language=D:/mysql/share/english/
character-sets-dir=D:/mysql/share/charsets/
default-table-type=BDB
port=3306
set-variable=key_buffer=16M
set-variable=max_allowed_packet=1M
set-variable=thread_stack=128K
default-character-set=latin5
set-variable=bdb_cache_size=4M
set-variable=bdb_max_lock=10000
skip-gemini
skip-innodb
[WinMySQLAdmin]
Server=D:/MYSQL/bin/mysqld-max.exe
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
