At 15:04 11/06/2001 +0300, Heikki Tuuri wrote:
Hi,
Only to complete the Heikki's instructions, also you need to
edit on /my.cnf the variables:
[mysqld]
basedir=F:/mysql
datadir=F:/mysql/data
The above is necessary when MySQL was installed on different location
than the default c:\mysql.
Regards,
Miguel
>Saleel,
>
>mysqld.exe was accidentally compiled with __NT__ defined.
>You should use mysqld-max.exe.
>
>The next version .39 will ask from the OS if it is Win 95, ...,
>and this problem will not appear any more. I am sorry for the
>inconvenience.
>
>Regards,
>
>Heikki Tuuri
>Innobase Oy
>
> >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_passwordport=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=MySQLskip-lockingdefault-character-set=latin1
> >set-variable = key_buffer=16Mset-variable = max_allowed_packet=1M
> >set-variable = thread_stack=128Kset-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.optionshistory_length=20database = test
> >queries_root= c:\mysql\querieslast_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
> fileM:\mysql-3.23\innobase\
> >os\os0file.c line 187Innobase: 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 [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
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Miguel A. Solórzano <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - Săo Paulo, Brazil
<___/ www.mysql.com
---------------------------------------------------------------------
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
