service usually indicates a background service such as Windows Service MySQL implements Windows Service Functionality thru 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 or possibly a permutation of java jars containing a main 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%, %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=d:t:F:L, documentation on this attribute is scarce and is mostly used by mysql engineers but this may be helpful http://lists.mysql.com/internals/35722 concerning configuration files such as my.ini based I would use the templates found at %MYSQL_HOME% 05/30/2008 08:17 PM 4,954 my-huge.ini 05/30/2008 08:17 PM 21,204 my-innodb-heavy-4G.ini 05/30/2008 08:17 PM 4,931 my-large.ini 05/30/2008 08:17 PM 4,938 my-medium.ini 05/30/2008 08:17 PM 2,469 my-small.ini in other words for ISAM small database requirement ren my-small.ini to my.ini ensure my.ini is placed on %PATH% HTH Martin ______________________________________________ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. > Date: Sat, 4 Oct 2008 17:33:06 +0530 > From: [EMAIL PROTECTED] > To: mysql@lists.mysql.com > Subject: How to start mysqld server, What is the difference between a server > and a server? > > 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 the > first time the command to run is given as C:\>"C:\Program Files\MySQL\MySQL > Server 5.0\bin\mysqld" --console > > But it didn't work, the following was the displayed message > > '"C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld"' is not recognized as > an i > nternal or external command, > operable program or batch file. > > *But when I used "mysqld-nt" The following is the out put* > > C:\>"C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt" --console > 081004 16:56:01 InnoDB: Started; log sequence number 0 43655 > 081004 16:56:01 [Warning] Neither --relay-log nor --relay-log-index were > used; s > o replication may break when this MySQL server acts as a slave and has his > hostn > ame changed!! Please use '--relay-log=varuna-e2a34b74-relay-bin' to avoid > 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) > > 1 In the reference manual there are three server types how can I start the > mysqld server? > 2 What is the difference between installing MySQL as a server and a service, > Is it only that when installed as a service MySQL server starts when Windows > 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 > > > Thanks Varuna _________________________________________________________________ See how Windows connects the people, information, and fun that are part of your life. http://clk.atdmt.com/MRT/go/msnnkwxp1020093175mrt/direct/01/