Hi Tony, First, as I just saw that everything is on C:\. In this case you wont even need the two settings basedir and datadir as far as my understanding goes.
I remember that after having registered the service itself "mysqld --install", I used the command "net start mysql" to start the service. I am not sure anymore if I had to go to the services and set it to automatic startup mode or not. I have no Windows machine installed right now to quickly check it. Also I did this on Windows 2000, but I believe thats more or less the same ;-) - I hope nobody is flaming me for that statement. ;-) Thats all really I can remember 1) mysqld --install 2) net start mysql 3) checking if the mysql servie is set to automatic startup in the services processlist. I hope that this helps a bit. Le me know how it went. Best regards Nils Valentin Tokyo/Japan 2003年 8月 11日 月曜日 19:50、Tony Groves さんは書きました: > Nils - Thanks for your response. > > Everything is on the C: drive, in the default locations. > > C:\winnt\my.ini consists of the following: > [client] > port=3306 > [mysqld] > port=3306 > basedir = c:/mysql/ > datadir = c:/mysql/data/ > innodb_data_home_dir = c:/mysql/ibdata/ > innodb_log_group_home_dir = c:/mysql/iblogs/ > innodb_data_file_path = ibdata1:10M:autoextend > set-variable = lower_case_table_names=0 > [WinMySQLAdmin] > Server=C:/mysql/bin/mysqld-max-nt.exe > All the file paths referred to there exist. > > The MySQL service runs using the system account, and uses the following > "ImagePath" value: > c:\mysql\bin\mysqld-max-nt.exe > This is the same command that I use to start the server as an application. > It is strange that the service starts but does not work, while an > application program using the same command does work. > > Any more suggestions would be gratefully acepted. > > Thanks a lot. > > Tony Groves. > > ----- Original Message ----- > From: "Nils Valentin" <[EMAIL PROTECTED]> > To: "Jason Kushmaul" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Monday, August 11, 2003 9:52 AM > Subject: Re: NT service starts, but I still have to start server manually. > > > Hi Tony, > > Just out of interest. The NT installation itself and the MySQL server > are both installed on the C:\ drive ? > > In case the MySQL server would be installed not on C:\ but f.e on E:\, > then I would perhaps have a solution. > > In case the mysql server is installed in another drive (and only then), > then you have to tell this to the MySQL server by setting the option > --basedir or in the my.cnf file like > > [mysqld] > basedir=E:/mysql > > > But only then really. > > Another possibility would be that the installed service is pointing to > the wrong location. I had this when I uninstalled the previous > version,but forgot to unregister the service. The new installation was > installed, but I did not get the service up and running, as it was > pointing to the old installation (which was removed ;-) > > Best regards > > Nils Valentin > Tokyo/Japan > > 2003年 8月 11日 月曜日 16:58、Jason Kushmaul さんは書きました: > > Is there a C:\my.cnf? If not try copying a distributed > > my-<medium,large,small>.cnf it to C:\winnt\my.ini. I had this problem on > > windows NT4, It seemed that everytime I created the file C:\my.cnf, it > > would get renamed to C:\my_cnf.bak, but no C:\my.cnf would exist. I read > > somewhere that this happens when you do not have C:\winnt\my.ini. It > > fixed > > > my problem of mysql appearing to start, but it wasn't... > > > > ----- Original Message ----- > > From: "Tony Groves" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Sunday, August 10, 2003 5:32 PM > > Subject: NT service starts, but I still have to start server manually. > > > > > I have installed MySQL (latest version) on my Windows NT4 (SP6) machine > > > > and > > > > > have started testing it. The MySQL service starts successfully at boot > > > > time > > > > > as expected, but I can never connect to the database until I start the > > > server manually - it makes no difference whether the service is already > > > running or not, and whether it had been started automatically or > > > manually. > > > > > > Any ideas, anybody? > > > > > > > > > -- > > > MySQL Windows Mailing List > > > For list archives: http://lists.mysql.com/win32 > > > To unsubscribe: > > > > http://lists.mysql.com/[EMAIL PROTECTED] > > -- > --- > Valentin Nils > Internet Technology > > E-Mail: [EMAIL PROTECTED] > URL: http://www.knowd.co.jp > Personal URL: http://www.knowd.co.jp/staff/nils -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]