Hi!
You are obviously running a 3.23.38 binary.
Sorry, the executable mysqld.exe was
in that version accidentally compiled with __NT__
defined, which means that mysqld.exe does not work
on Win 98. Use mysqld-max.exe from the same
distribution, or download 3.23.39 from www.mysql.com.
InnoDB does not create directories. I assume you
have created c:\ibdata and c:\iblogs yourself?
If InnoDB already created some files to those directories,
remove them, and start mysqld-max.exe again.
I personally run in Windows from the command line:
C:...>mysqld-max --console
which may be the easiest choice for a new user.
Regards,
Heikki
http://www.innodb.com
.................................
I'm relatively new to web development and basically don't have a clue on all
the intricacies of establishing a localhost development environment. I'm
running a Win 98 platform and want to develop using PHP4, Apache, & MySql
that will support transaction processing.
I've found a ton of great information on establishing this dev environment
and have successfully installed & configured apache & php. These process
seem to work just fine, I'm able to serve up my PHP scripts no problem. So
my next step was to install MySql, All the tutorials I've read make it
sound like a piece of cake, however I must be illiterate because MySql is
kicking my butt. It's my impression I must be missing the boat somewhere on
the configuration aspects of this. I was getting an error
innodb_data_file_path not specified so I read some more & setup a C:\my.cnf
file with a slew of InnoDB options;
****************************************************************************
# mysql config file. #
# One can use all long options that the program supports.
# Run the program with --help to get a list of availableoptions
# This will be passed to all mysql clients [client]
#password=my_password
port=3306 #socket=MySQL # Here is entries for some specific programs
# The following values assume you have at least 32M ram # The MySQL
server
[mysqld] port=3306 #socket=MySQL skip-locking
default-character-set=latin1
set-variable = key_buffer=16M set-variable = max_allowed_packet=1M
set-variable = thread_stack=128K set-variable = flush_time=1800
innodb_data_file_path = ibdata1:20M;ibdata2:20M
innodb_data_home_dir = c:\ibdata set-variable =
innodb_mirrored_log_groups=1
innodb_log_group_home_dir = c:\iblogs
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=10M
set-variable = innodb_log_buffer_size=10M
innodb_flush_log_at_trx_commit=1
innodb_log_arch_dir = c:\iblogs innodb_log_archive=0
set-variable = innodb_buffer_pool_size=20M
set-variable = innodb_additional_mem_pool_size=10M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50
# Uncomment the following row if you move the MySQLdistribution to another
# location #basedir = d:/mysql/ [mysqldump] quick
set-variable = max_allowed_packet=16M [mysql] no-auto-rehash [isamchk]
set-variable= key=16M [client_fltk]
help_file= c:\mysql\sql_client\MySQL.help client_file=
c:\mysql\MySQL.options
history_length=20 database = test queries_root= c:\mysql\queries
last_database_file= c:\mysql\lastdb
****************************************************************************
****** I got farther along but evidently what I have must not be appropriate
because it died with the following:
Innobase: Assertion failure in thread 4294132173 in file
M:\mysql-3.23\innobase\ os\os0file.c line 187
Innobase: we intentionally generate a memory trap.
Innobase: Send a bug report to [EMAIL PROTECTED]
010726 19:30:37 C:\MYSQL\BIN\MYSQLD.EXE: Got signal 11.Aborting!
010726 19:30:37 Aborting
InnoDB: Warning: shutting down not properly started database
010726 19:30:37 C:\MYSQL\BIN\MYSQLD.EXE: Shutdown Complete
Any help would be greatly appreciated.
---------------------------------------------------------------------
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
