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 available
options
# 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 MySQL
distribution 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
