From: Martin Gainty Date: October 4 2008 2:12pm Subject: RE: How to start mysqld server, What is the difference between a server and a server? List-Archive: http://lists.mysql.com/mysql/214750 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="_059dd1ac-d9b0-4f64-9d0f-1e3a11ea4cd3_" --_059dd1ac-d9b0-4f64-9d0f-1e3a11ea4cd3_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable service usually indicates a background service such as Windows Service MySQL implements Windows Service Functionality thru=20 mysqld-nt binary documentation is available at http://dev.mysql.com/doc/refman/5.0/en/multiple-windows-services.html a server is a standalone binary or even possibly a binary acting in concert= with assocated dll's=20 or possibly a permutation of java jars containing a main=20 to start mysql as a standalone (non-service) server execute mysqld --standalone documentation is located at http://dev.mysql.com/doc/refman/5.0/en/server-options.html if you believe you have a misconfiguration in %MYSQL_HOME%=2C %PATH% or even possibly my.ini configuration settings you would use the debug option for the server such as what is shown here ./mysqld --debug=3Dd:t:F:L=2C documentation on this attribute is scarce and is mostly used by mysql engin= eers but this may be helpful http://lists.mysql.com/internals/35722 concerning configuration files such as my.ini based I would use the templat= es found at %MYSQL_HOME% 05/30/2008 08:17 PM 4=2C954 my-huge.ini 05/30/2008 08:17 PM 21=2C204 my-innodb-heavy-4G.ini 05/30/2008 08:17 PM 4=2C931 my-large.ini 05/30/2008 08:17 PM 4=2C938 my-medium.ini 05/30/2008 08:17 PM 2=2C469 my-small.ini in other words for ISAM small database requirement ren my-small.ini to my.ini=20 ensure my.ini is placed on %PATH% HTH Martin=20 ______________________________________________=20 Disclaimer and confidentiality note=20 Everything in this e-mail and any attachments relates to the official busin= ess of Sender. This transmission is of a confidential nature and Sender doe= s not endorse distribution to any party other than intended recipient. Send= er does not necessarily endorse content contained within this transmission.= =20 > Date: Sat=2C 4 Oct 2008 17:33:06 +0530 > From: varunawithmysql@stripped > To: mysql@stripped > Subject: How to start mysqld server=2C What is the difference between a s= erver and a server? >=20 > Hello Every body! > I stopped the service from the services shortcut in the Administrative > tools.then according to to the reference manual to start the server for t= he > first time the command to run is given as C:\>"C:\Program Files\MySQL\MyS= QL > Server 5.0\bin\mysqld" --console >=20 > But it didn't work=2C the following was the displayed message >=20 > '"C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld"' is not recognized = as > an i > nternal or external command=2C > operable program or batch file. >=20 > *But when I used "mysqld-nt" The following is the out put* >=20 > C:\>"C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt" --console > 081004 16:56:01 InnoDB: Started=3B log sequence number 0 43655 > 081004 16:56:01 [Warning] Neither --relay-log nor --relay-log-index were > used=3B s > o replication may break when this MySQL server acts as a slave and has hi= s > hostn > ame changed!! Please use '--relay-log=3Dvaruna-e2a34b74-relay-bin' to avo= id > this p > roblem. > 081004 16:56:01 [Note] C:\Program Files\MySQL\MySQL Server > 5.0\bin\mysqld-nt: re > ady for connections. > Version: '5.0.67-community-nt' socket: '' port: 3306 MySQL Community > Edition > (GPL) >=20 > 1 In the reference manual there are three server types how can I start th= e > mysqld server? > 2 What is the difference between installing MySQL as a server and a servi= ce=2C > Is it only that when installed as a service MySQL server starts when Wind= ows > starts and when Windows stops it stops? > 3 After starting the server in above mentioned way How can I use MySQL > server Do I have to open another console window and do what? > 4 In Windows is it not possible to start other to two servers mysqld and > mysqld-debug >=20 >=20 > Thanks Varuna _________________________________________________________________ See how Windows connects the people=2C information=2C and fun that are part= of your life. http://clk.atdmt.com/MRT/go/msnnkwxp1020093175mrt/direct/01/= --_059dd1ac-d9b0-4f64-9d0f-1e3a11ea4cd3_--