MYSQL 4.0.18 INSTALLATION PROBLEM WITH WIN2K3 SERVER

[srajeevkumar]

Hello,

I installed MySQl version 4.0.18 in our new Windows 2003 Small Business server. Insated of installing the database in the default location
I changed it from c:\mysql to f:\mysql
and
location of data to f:\mysql\data .
I created this my.cnf file and edited the contents of the it to be:-

[mysqld]
basedir=f:\mysql
datadir=f:\mysql\data

Now when I tried to start the MySQL service from the services in Administrative tools in this Win2003 server. it tries to start and then comes up with a message box error message.

Could not start the MySQl service on local computer
Error 1067: The process terminated unexpectedly.

I am just stuck at this and cant proceed with the installation. Any ideas suggestions or solutions will be welcomed with a lot of joy.

Rgds

Rajeev

 

[jmlynn]

I encountered the same problem after installing the MySQL V4.0.20c. I installed it on my notebook running Windows XP with all the latest security patches and entered D:\MySQL as the installed directory.

I can run MySQL and successfully use it if I start it using the following command:

mysqld-nt --console

Any suggestion?

jml

 

[jmlynn]

After reading a bit from the rest of the postings on other this forum. I had solved the problem and want to repost it here as a summary of what get my MySQL Windows service going.

You have to create my.ini under your Windows directory, which should be C:\Windows for most Windows and C:\WinNT for WinNT and Win2K as follow.

[mysqld]
basedir=D:/mysql
datadir=D:/mysql/data

I did not go back to verify it, but I had first entered the my.ini using the following did not work:
BaseDir=D:\mysql
DataDir=D:\mysql\data.

so do exactly as my first my.ini definition. In my case, I had already specified D:/mysql as my installation during installation and also had ran D:/mysql/bin/mysqld-nt --console as well as D:/mysql/bibn/mysqld-nt --install and manually start the service using "net start MySQL".

Good luck!

jml

 

[srajeevkumar]

Oh it was my mistake.
I created a new file My.cnf and then tried to edit it.
Infact the my.ini file was already created during the MySQl server installation. Anyway now after editing the correct ini file it is resolved.

Thanks