16 messages in com.mysql.lists.win32Re: installation on windows 2000 as a...
FromSent OnAttachments
Sylvain Hamel07 Jan 2002 13:19 
Peter07 Jan 2002 13:42 
Heikki Tuuri07 Jan 2002 14:14 
Sylvain Hamel07 Jan 2002 14:15 
Sylvain Hamel07 Jan 2002 14:17 
Land, Christopher07 Jan 2002 14:27 
Heikki Tuuri07 Jan 2002 14:55 
Miguel Angel Solorzano07 Jan 2002 17:43 
Sylvain Hamel07 Jan 2002 20:10 
Nathan J Wright07 Jan 2002 23:09 
Mattias Persson07 Jan 2002 23:41 
Frank J. Schmuck21 Jan 2002 04:06 
Pete French21 Jan 2002 04:10 
Peter21 Jan 2002 05:19 
Corey Tisdale21 Jan 2002 09:35 
Robert Raisch21 Jan 2002 10:10 
Subject:Re: installation on windows 2000 as a service
From:Heikki Tuuri (Heik@innodb.com)
Date:01/07/2002 02:55:02 PM
List:com.mysql.lists.win32

Hi!

From the manual:

" There are two configuration files with the same function: `my.cnf' and `my.ini' file, however please note that only of one these should can used. Both files are plain text. The `my.cnf' file should be created in the root directory of drive C and the `my.ini' file on the WinDir directory e.g: `C:\WINDOWS' or `C:\WINNT'. If your PC uses a boot loader where the C drive isn't the boot drive, then your only option is to use the `my.ini' file. Also note that if you use the WinMySQLAdmin tool, only the `my.ini' file is used. The `\mysql\bin' directory contains a help file with instructions for using this tool. "

If you call

SET

at an MS-DOS prompt, what does it say about the value of WINDIR?

Please put your my.ini to WINDIR and start mysqld-max-nt from the MS-DOS prompt:

...>mysqld-max-nt --console --standalone

What does it print?

Best regards,

Heikki Tuuri Innobase Oy

--- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com

----- Original Message -----> From: "Sylvain Hamel" <sylv@webnet.qc.ca> To: "MySQL Win32" <win@lists.mysql.com> Sent: Monday, January 07, 2002 10:19 PM Subject: installation on windows 2000 as a service

I have a problem installing mysql as a service under win2k pro.

mysql version : 3.23.47 basedir = d:/mysql

Here is what I did to install it : 1) installed into d:/mysql 2) ran mysqld-max-nt --install (runs fine, I can see it in the services console)

Please note that at this point there is neither a c:/my.cnf or d:/winnt/my.ini files.

When I start it with [net start mysql] or through the services consoleit fails with error 1067 (service failed unexpectedly). BUT, if I go into the services management console, double click to bring its> > properties dialog, put the following startup parameters [--basedir d:/mysql --skip-innodb] and hit start the service runs fine. IphpMyAdmin has no problem talking to the server and a mysqladmin variables works perfectly. This would be fine except that windows 2000 does not retain those> > parameters when you close the dialog by any way.> > When I call the command line help of mysqld-max-nt it says my default basedir is d:/mysql and all ... From that I thought I only need --skip-innodb in the preceding procedure but no the service willnot start if I omit either param.> > I read all the comments about this specific problem in the manual and> tried them all as you can see by the following tries :> > 0) I tried with no my.ini and no my.cnf files. NO SUCCESS 1) I tried making a c:/my.cnf (no my.ini) with just those 2 params. NO SUCCESS 2) I tried a d:/winnt/my.ini (no my.cnf) with just those 2 params. NO SUCCESS> > 3) Tried both with these 2 params. NO SUCCESS 4) Tried creating a c:/my.cnf based on my-example.cnf and changing the directory values for d:/ instead of c:/ and uncommenting skip-innodb. NO SUCCESS> > 5) same as above but with my.ini and no my.cnf. NO SUCCESS 6) both a my.ini and my.cnf with example configuration modified. NO>

SUCCESS

..... O and dont even think about asking me if I have rebooted! ;-)>

I'm rather stumped and would appreciate any help...> >> > Sylvain