At 10:04 22/11/2001 +0000, Sandeep Murthy wrote:
Hi,
When you are having problems for to start the server as service on
NT/Win2000 machine. Follow the below troubleshooting:
1- Enter in the \mysql\bin directory opening a DOS prompt screen.
2- Execute the remove service command with any server e.g.:
mysqld-max-nt --remove
Even the service doesn't exist, this command doesn't create any
problem.
IMPORTANT: When performing command for install and remove the
MySQL service in the shell prompt, the SCM (Service
Control Manager) should be closed.
3- Now with the SCM (Service Control Manager) take a look if effectively
the service called mysql doesn't exists.
If you see, the service above this means that for any reason your
SCM is in bad state, so you need to re-boot the machine.
4- If you are using any Max server:
mysqld.exe
mysqld-max.exe
mysqld-max-nt.exe
You should need the use of the /winnt/my.ini file for to set the
variables for InnoDB table or adding the variable skip-innodb if
you don't want to use this type of table. You need to read
complementary instructions for to set the InnoDB in our Manual.
Also if you installation directory is other than the default
c:\mysql, you need to set the variables basedir and datadir.
Below I show you, the my.ini file that there is on my machine,
as a sample:
[mysqld]
basedir=c:\mysql
datadir=c:\mysql\data
innodb_data_file_path = ibdata1:200M
innodb_data_home_dir = c:\ibdata
set-variable = innodb_mirrored_log_groups=1
innodb_log_group_home_dir = c:\iblogs
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=30M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
innodb_log_arch_dir = c:\iblogs
innodb_log_archive=0
set-variable = innodb_buffer_pool_size=80M
set-variable = innodb_additional_mem_pool_size=10M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50
You should use the notepad.exe or other ASCII editor like the
edit.exe or Xemacs for Win32 for to create the my.ini file.
5- Back for the DOS screen shell.
Do the below command with the server you want, e.g.:
Microsoft Windows 2000 [Versăo 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.
C:\>cd\mysql\bin
C:\mysql\bin>mysqld-max-nt --standalone --console
011122 21:54:27 InnoDB: Started
mysqld-max-nt: ready for connections
In the sample above I had a successfully start. However below I
show you, a failed start:
C:\mysql\bin>mysqld-max-nt --standalone --console
mysqld-max-nt: Fatal error: Can't find messagefile
'c:\mysql\share\english\errmsg.sys'
011122 21:57:03 Aborting
Then how you can guess that the purpose to try the server as
standalone mode is to find the message error which cause the
failed start. Also you can find in the /mysql/data/mysql.err
file, useful information about.
6- If necessary fix the problems found in the step above.
7- Stop the server using the mysqladmin tool:
mysqladmin shutdown
Maybe you need to perform twice the command above. This problem
should will fixed as soon as possible.
8- Install the service:
mysqld-max-nt --install
9- Start the service:
net mysql start
I hope this help you.
Regards,
Miguel
>hi,
>
>I had posted a few days back regarding having problems running MySQL on WIN
>2000...
>
>I forgot to add before, I can ping my localhost but unable to do a telnet
>localhost too...
>I had installed and was running MySQL and PHP with IIS successfully for
>nearly 2 mths now... All of sudden since a few days back the MySQL service
>refuses to start and keeps giving various errors such as unable to find path
>etc...
>
>I uninstalled and reinstalled MySQL a couple of times all in vain..
>
>What could have happened and how may I rectify this problem...
>
>Would appreciate much if anyone can help me out on this..
>
>TIA,
>sandeep
>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Miguel A. Solórzano <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - Săo Paulo, Brazil
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
