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
