>Date: Thu, 06 Sep 2001 17:24:21
>To: Marjolein Katsma <[EMAIL PROTECTED]>
>From: Heikki Tuuri <[EMAIL PROTECTED]>
>Subject: Re:Can't get MySQL running on Win2K
>X-Attachments: C:\MY.CNF;
>
>Hi!
>
>I think it is best to have only one my.ini
>or my.cnf in your system. Otherwise there
>will be confusion. If MySQL finds your
>my.* then the place is obviously ok.
>
>I am running .37 on NT. I got the following
>printout at command prompt:
>.......
>C:\trybuild\client_debug>mysqld --standalone
>mysqld: ready for connections
>010906 17:15:58 mysqld: Normal shutdown
>
>010906 17:15:58 mysqld: Shutdown Complete
>
>
>C:\trybuild\client_debug>mysqld --console
>mysqld: ready for connections
>010906 17:16:14 mysqld: Normal shutdown
>
>010906 17:16:15 mysqld: Shutdown Complete
>.......
>
>But when I deleted my.cnf, I got:
>.......
>C:\trybuild\client_debug>mysqld --console
>Can't initialize InnoDB as 'innodb_data_file_path' is not set
>mysqld: ready for connections
>010906 17:18:15 mysqld: Normal shutdown
>
>010906 17:18:16 mysqld: Shutdown Complete
>
>
>C:\trybuild\client_debug>mysqld --standalone
>Can't initialize InnoDB as 'innodb_data_file_path' is not set
>........
>
>but I was not able to connect to the MySQL server.
>This suggests that your my.cnf is missing something.
>Look in the MySQL manual about startup options.
>
>Regards,
>
>Heikki
>
>
>At 03:53 PM 9/6/01 +0200, you wrote:
>>Heikki,
>>
>>Thanks for the reply.
>>Since I don't even know what "InnoDB' is, obviously I don't want it ;-)
>>
>>I tried adding the line 'skip-innodb' to the [mysqld] section in C:\my.cnf
as you suggested but it didn't make any difference. I wonder whether that
file is actually read, since I next tried *moving* the whole [mysqld]
section to R:\Win2000\my.ini - this time the error does not appear when I
try "mysqld --standalone". However, it still hangs: in the command-line
window it never returns to the command prompt. (Though I can close the
command-line window and mysqld remains loaded - it actually *should* return
to the prompt. Buglet?)
>>
>>Should my.cnf actually be on R:\ on my system since that is the root of
the _system_ drive when I run Win2K (while C: definitely isn't)?
>>
>>Cheers,
>>
>>At 15:11 2001-09-06 +0300, Heikki Tuuri wrote:
>>>Marjolein,
>>>
>>>if you do not want to use transactional InnoDB tables,
>>>add
>>>
>>>skip-innodb
>>>
>>>[snip]
>>>Heikki
>>>http://www.innodb.com
>>>
>>>>Configuration: multiboot system. C: is for DOS and System Commander, R: is
>>>for Win2K. \
>>>>(Most) applications go on F:, (most) data goes on P:.
>>>>- I installed MySQL to F:\Development\Database\MySQL
>>>>- I edited my-example.cnf and added [mysqld]
>>>>basedir=F:/Development/Database/MySQL/datadir=P:/MySQL/
>>>>then Save as to C:\my.cnf (do I *really* have to store this on a drive
that's \
>>>>reserved for DOS and multiboot?) The installation created databases 'mysql'
>>>and \
>>>>'test' on F: - I copied these to the designated data location on P:.
>>>>- I ran winmysqladmin.exe, created an .ini file and designated
>>>mysqld-nt.exe as the \
>>>>service, then tried to start it. The traffic light remains red. (The ini
>>>file is in \
>>>>the Windows directory: R:\WIN2000\my.ini ) - Tried MySqlManager.exe which
>>>wants to \
>>>>connect to localhost - but can't connect. - In the Services applet,
>>>mysqld-nt.exe is \
>>>>registered as a service, automatic, but not started. - After reboot, same
>>>situation: \
>>>>the service is automatic, but not started. Trying to start results in an
>>>error. - \
>>>>Removed the service with F:\Development\Database\MySQL\bin\mysqld-nt
>>>--remove - Tried \
>>>>to start mysqld in debug mode with F:\Development\Database\MySQL\bin\mysqld
>>>--debug \
>>>>--standalone this results in an error: "Can't initialize InnoDB as \
>>>>'innodb_data_file_path' is not set" and mysqld hung - I had to kill it from
>>>task \
>>>>manager. - Tried to start mysqld (no debug) with \
>>>>F:\Development\Database\MySQL\bin\mysqld --standalone this results in the
>>>error - I \
>>>>had to kill it from task manager again. (Note: while mysqld hangs, \
>>>>winmysqladmin.exe's traffic light in the system tray is green, so it does
>>>detect if \
>>>>mysqld is running.)Now what?Thanks,Marjolein Katsma
>>>>HomeSite Help - http://hshelp.com/
>>>>Bookstore for Webmasters - http://hshelp.com/bookstore/bookstore.html
>>
>>Marjolein Katsma [EMAIL PROTECTED]
>>Java Woman - http://javawoman.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
