I am facing the following error while creating the Mysql instance from command line in Windows server 2012.
Steps i follwed for creating a new Mysql Instance as a window service:
I have stopped the existing Mysql service (Mysqld) using mysqladmin.exe -u root -p shutdown.
I havecopied the contents of Mysql data folder located at C:\Programdata\Mysql\Mysql Server 5.6\data to the data directory location on new instacnce which is locate at G:\MYSQL.
And i have created a my.ini file with following lines
Server [Mysqld] port=3306 basedir="C:\Program Files\Mysql\Mysql Server 5.6\" datadir="G:\Mysql\" server_id=1
Now from CMD i ran the following command to create the Mysql instance as window service
mysqld.exe --install mysqld --defaults-file="G:\Mysql\my.ini"
the service has been created Sucessfully
But i am getting an error while i am trying to start the Service as
Net start Mysqld from CMD.
System Error Occured
Error 1067 Process Terminated Unexpectdely
Any help can be Appreciated.
Thanks & Regards