List:General Discussion« Previous MessageNext Message »
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?
View as plain text  
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: varunawithmysql@stripped
> To: mysql@stripped
> 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/
Thread
How to start mysqld server, What is the difference between a server and a server?Varuna Seneviratna4 Oct
  • RE: How to start mysqld server, What is the difference between aserver and a server?Martin Gainty4 Oct