Heikki,
Thanks a lot for your help! This mail list is a great resource (but I knew that
already ;-))
Now that I have moved the whole [mysqld] section from C:\my.cnf to R:\Win2000\my.ini
and rebooted, everything has started to work - the service now starts automatically.
(If something else will appear not to work, I know where to look now.) I've since
tried MySQL-Front as a GUI client and that works perfectly as well.
(Background: I only tried installing MySQL locally as a workaround because I could not
get MyODBC working to connect from Access2000 to MySQL on my (web) server - and I did
try _everything_ I found in the manual and on this list (latest versions, patches,
etc.)! Now with MySQL running locally and MySQL-Front I will be able to do it the
other way round: import from Access to local MySQL (using the ODBC sriver for Access
rather than MyODBC, of course), and then export to MySQL on the server, both using
MYSQL. That way I can design a database and enter basic (static) data with Access, and
when done, export to the server. I haven't tested all the steps yet but I did
successfully import a table from Access2000 and I can successfully connect to the
server on my web host.)
Thanks again - problem solved within one day!
At 17:25 2001-09-06 +0300, Heikki Tuuri wrote:
>>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.
>>
>[snip]
>
>>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
>>
>>
Marjolein Katsma
HomeSite Help - http://hshelp.com/
Bookstore for Webmasters - http://hshelp.com/bookstore/bookstore.html
---------------------------------------------------------------------
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
