Hello,
I was wondering if you could help me on a problem I am having with mySQL.
I've installed MySQL (Win32) on F:\mysql. I've placed my.cnf on C:\. This is
the contents of my.cnf:
-------
# Example mysql config file.
# Copy this file to c:\my.cnf to set global options
#
# 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
# 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
--------
My system is a PII 400MHz with 128mb RAM and plenty of hard disk space. (F:\
alone has 17GB free, C:\ has 5.7GB free). It is running Win ME.
I fire up a MS-DOS window, navigate to f:\mysql\bin and type "mysqld". This
is what happens:
--------
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
InnoDB: Setting file .\ibdata1 size to 20971520
InnoDB: Database physically writes the file full: wait...
InnoDB: Data file .\ibdata2 did not exist: new to be created
InnoDB: Setting file .\ibdata2 size to 20971520
InnoDB: Database physically writes the file full: wait...
InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 5242880
InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 5242880
Innobase: Assertion failure in thread 4294430293 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]
010610 22:46:17 F:\MYSQL\BIN\MYSQLD.EXE: Got signal 11. Aborting!
010610 22:46:17 Aborting
InnoDB: Warning: shutting down not properly started database
010610 22:46:17 F:\MYSQL\BIN\MYSQLD.EXE: Shutdown Complete
-------
And I have no clue what to do next. Doing a Ctrl+Alt+Del to see the tasks
shows me that myslq is *not* running (not in programs list).
I don't think it matters, but I am running Apache/1.3.19 (Win32), PHP/4.0.5
and ActiveState Perl (F:\php and F:\perl). Before attempting to start mysql,
I did close done Apache.
Any help would be much appreciated.
Thanks.
---
Saleel Majeed
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
