Mysql – Create second instance of thesqld on windows xp

MySQL

I am trying to install the new version of the mysql on the windows7 and windows xp . In few of the computers already a new version of mysql are installed. Here I just want to create a second instance of the service of mysqld with my my_XX.ini file.

I have successfully configured the instance on the windows 7 pc . But can not create instance on the windows xp for the same .

I am trying this code on the command prompt which run as administrator. but it does not start the service

sc create mysqld2 binPath= c:\mysql\bin\mysqld.exe --defaults-file=c:\mysql\my_XX.ini

Even I have tried with the mysqld command to start the mysql as per other my_xx.ini with 

mysqld --defaults-file=c:\mysql\my_XX.ini

I am not able to create a second instance on the windows xp . Please help me to start the second instance of mysql on windows xp with windows service

Best Answer

=> only set my_ibt.ini in the pateh C:\RailsInstaller\ => my_xxx.ini

[mysqld_xxx]
#if already installed then use that basedir
basedir = "C:\RailsInstaller\MYSQL"

#where you want to set your database
datadir="C:\RailsInstaller\MYSQL\data"
port = 43307
enable-named-pipe
socket = mypipe1

In the command promt which runs as administrator go to
\MYSQL\bin> And run Command :

mysqld --install mysqld_xxx --defaults-file=C:\RailsInstaller\my_xxx.ini

Service successfully installed.

Then :

net start mysqld_xxx

The mysqld_ibt service is starting. The mysqld_ibt service was started successfully.