RE: startup on win2000 as service not working.
That was it! Thank you all for your help. Steve. -Original Message- From: Iikka Meriläinen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 08, 2002 2:21 PM To: Steve Bradwell Cc: [EMAIL PROTECTED]; Oluwagbamila Oyekanmi; Bruce Lewis Subject: RE: startup on win2000 as service not working. Hi, First run 'mysqld-nt --remove' then 'mysqld-max-nt --install' This removes the old installation of the service and then inserts a new InnoDB-enabled registration. Iikka On Tue, 8 Oct 2002, Steve Bradwell wrote: > Hi, > > I checked the path, it is correct. I also tried from > c:\mysql\bin\mysqld-max-nt --install > and got the following, > > The service already exists! > The current server installed: C:/mysql/bin/mysqld-nt.exe > > So what I can tell is I am not running mysqld-max-nt like I thought I was, > but my.ini has all my Innodb definitions. > > Any idea of what I should do, again if I start mysqld-max-nt --console from > command prompt The server runs fine and when I start winmysqladmin.exe, all > server info is correct including databases etc, however when I restart the > pc, and winmysqladmin.exe starts from the startup folder the server does not > start. > > Thanks again, > Steve > > > -Original Message- > From: Bruce Lewis [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 08, 2002 12:10 PM > To: Steve Bradwell; [EMAIL PROTECTED] > Subject: Re: startup on win2000 as service not working. > > > Check your ini file to make sure the path reflects the proper location of > the database. > > Bruce > > - Original Message - > From: "Steve Bradwell" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, October 08, 2002 8:14 AM > Subject: startup on win2000 as service not working. > > > > Hi everyone, > > > > I have recently moved my mysql server from a win98 machine to a win2000 > > machine. After running the self extracting setup for mysql, I copied my > > existing my.ini file over from the win 98 box, made neccesary changes to > > start mysqld-max-nt from correct dir, I copied the my.ini file because of > > the Innodb settings I had setup on the win98 machine. I then copied over > my > > Ibdata, and IbLogs directories and their contents to the win2000 box, and > > the replaced the data directory with the one from the 98 box. I then > started > > mysql from the command prompt with "mysqld-max-nt --console" it said > > > > ..."Innodb: Flushing modified pages from the buffer pool..." > > "Innodb: Started " > > "Ready for connections..." > > > > And all works fine, however when I restarted the pc, and winmysqladmin.exe > > was started as a service, the server is not started, I get the red light > and > > no server, or table information. If I then go and start it through the > > console and run winmysqladmin.exe All my information appears like normal. > > > > Can anyone suggest what I should do? > > > > Thanks alot, > > Steve. > > > > > > > > - > > 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 > > > ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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
RE: startup on win2000 as service not working.
Hi, First run 'mysqld-nt --remove' then 'mysqld-max-nt --install' This removes the old installation of the service and then inserts a new InnoDB-enabled registration. Iikka On Tue, 8 Oct 2002, Steve Bradwell wrote: > Hi, > > I checked the path, it is correct. I also tried from > c:\mysql\bin\mysqld-max-nt --install > and got the following, > > The service already exists! > The current server installed: C:/mysql/bin/mysqld-nt.exe > > So what I can tell is I am not running mysqld-max-nt like I thought I was, > but my.ini has all my Innodb definitions. > > Any idea of what I should do, again if I start mysqld-max-nt --console from > command prompt The server runs fine and when I start winmysqladmin.exe, all > server info is correct including databases etc, however when I restart the > pc, and winmysqladmin.exe starts from the startup folder the server does not > start. > > Thanks again, > Steve > > > -Original Message- > From: Bruce Lewis [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 08, 2002 12:10 PM > To: Steve Bradwell; [EMAIL PROTECTED] > Subject: Re: startup on win2000 as service not working. > > > Check your ini file to make sure the path reflects the proper location of > the database. > > Bruce > > - Original Message - > From: "Steve Bradwell" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, October 08, 2002 8:14 AM > Subject: startup on win2000 as service not working. > > > > Hi everyone, > > > > I have recently moved my mysql server from a win98 machine to a win2000 > > machine. After running the self extracting setup for mysql, I copied my > > existing my.ini file over from the win 98 box, made neccesary changes to > > start mysqld-max-nt from correct dir, I copied the my.ini file because of > > the Innodb settings I had setup on the win98 machine. I then copied over > my > > Ibdata, and IbLogs directories and their contents to the win2000 box, and > > the replaced the data directory with the one from the 98 box. I then > started > > mysql from the command prompt with "mysqld-max-nt --console" it said > > > > ..."Innodb: Flushing modified pages from the buffer pool..." > > "Innodb: Started " > > "Ready for connections..." > > > > And all works fine, however when I restarted the pc, and winmysqladmin.exe > > was started as a service, the server is not started, I get the red light > and > > no server, or table information. If I then go and start it through the > > console and run winmysqladmin.exe All my information appears like normal. > > > > Can anyone suggest what I should do? > > > > Thanks alot, > > Steve. > > > > > > > > - > > 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 > > > ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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
RE: startup on win2000 as service not working.
Hi, I checked the path, it is correct. I also tried from c:\mysql\bin\mysqld-max-nt --install and got the following, The service already exists! The current server installed: C:/mysql/bin/mysqld-nt.exe So what I can tell is I am not running mysqld-max-nt like I thought I was, but my.ini has all my Innodb definitions. Any idea of what I should do, again if I start mysqld-max-nt --console from command prompt The server runs fine and when I start winmysqladmin.exe, all server info is correct including databases etc, however when I restart the pc, and winmysqladmin.exe starts from the startup folder the server does not start. Thanks again, Steve -Original Message- From: Bruce Lewis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 08, 2002 12:10 PM To: Steve Bradwell; [EMAIL PROTECTED] Subject: Re: startup on win2000 as service not working. Check your ini file to make sure the path reflects the proper location of the database. Bruce - Original Message - From: "Steve Bradwell" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 08, 2002 8:14 AM Subject: startup on win2000 as service not working. > Hi everyone, > > I have recently moved my mysql server from a win98 machine to a win2000 > machine. After running the self extracting setup for mysql, I copied my > existing my.ini file over from the win 98 box, made neccesary changes to > start mysqld-max-nt from correct dir, I copied the my.ini file because of > the Innodb settings I had setup on the win98 machine. I then copied over my > Ibdata, and IbLogs directories and their contents to the win2000 box, and > the replaced the data directory with the one from the 98 box. I then started > mysql from the command prompt with "mysqld-max-nt --console" it said > > ..."Innodb: Flushing modified pages from the buffer pool..." > "Innodb: Started " > "Ready for connections..." > > And all works fine, however when I restarted the pc, and winmysqladmin.exe > was started as a service, the server is not started, I get the red light and > no server, or table information. If I then go and start it through the > console and run winmysqladmin.exe All my information appears like normal. > > Can anyone suggest what I should do? > > Thanks alot, > Steve. > > > > - > 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 > - 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
Re: startup on win2000 as service not working.
I had the same thing happen to me. Go in to services and right-click on the mysql service. Go to properties and verify that the service is assigned to the right executable. Mine was not so I had to start MySQL manually every time I restarted. (MySQL, query) >>> Steve Bradwell <[EMAIL PROTECTED]> 10/08/02 07:14AM >>> Hi everyone, I have recently moved my mysql server from a win98 machine to a win2000 machine. After running the self extracting setup for mysql, I copied my existing my.ini file over from the win 98 box, made neccesary changes to start mysqld-max-nt from correct dir, I copied the my.ini file because of the Innodb settings I had setup on the win98 machine. I then copied over my Ibdata, and IbLogs directories and their contents to the win2000 box, and the replaced the data directory with the one from the 98 box. I then started mysql from the command prompt with "mysqld-max-nt --console" it said ..."Innodb: Flushing modified pages from the buffer pool..." "Innodb: Started " "Ready for connections..." And all works fine, however when I restarted the pc, and winmysqladmin.exe was started as a service, the server is not started, I get the red light and no server, or table information. If I then go and start it through the console and run winmysqladmin.exe All my information appears like normal. Can anyone suggest what I should do? Thanks alot, Steve. - 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 - 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
Re: startup on win2000 as service not working.
I had the same problem happen to me. Go in to services and right-click on the mysql service and check the properties. Check that the service is assigned to the right executable. Mine was not so I had to start it manually every time I restarted. >>> Steve Bradwell <[EMAIL PROTECTED]> 10/08/02 07:14AM >>> Hi everyone, I have recently moved my mysql server from a win98 machine to a win2000 machine. After running the self extracting setup for mysql, I copied my existing my.ini file over from the win 98 box, made neccesary changes to start mysqld-max-nt from correct dir, I copied the my.ini file because of the Innodb settings I had setup on the win98 machine. I then copied over my Ibdata, and IbLogs directories and their contents to the win2000 box, and the replaced the data directory with the one from the 98 box. I then started mysql from the command prompt with "mysqld-max-nt --console" it said ..."Innodb: Flushing modified pages from the buffer pool..." "Innodb: Started " "Ready for connections..." And all works fine, however when I restarted the pc, and winmysqladmin.exe was started as a service, the server is not started, I get the red light and no server, or table information. If I then go and start it through the console and run winmysqladmin.exe All my information appears like normal. Can anyone suggest what I should do? Thanks alot, Steve. - 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 - 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
Re: startup on win2000 as service not working.
Check your ini file to make sure the path reflects the proper location of the database. Bruce - Original Message - From: "Steve Bradwell" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 08, 2002 8:14 AM Subject: startup on win2000 as service not working. > Hi everyone, > > I have recently moved my mysql server from a win98 machine to a win2000 > machine. After running the self extracting setup for mysql, I copied my > existing my.ini file over from the win 98 box, made neccesary changes to > start mysqld-max-nt from correct dir, I copied the my.ini file because of > the Innodb settings I had setup on the win98 machine. I then copied over my > Ibdata, and IbLogs directories and their contents to the win2000 box, and > the replaced the data directory with the one from the 98 box. I then started > mysql from the command prompt with "mysqld-max-nt --console" it said > > ..."Innodb: Flushing modified pages from the buffer pool..." > "Innodb: Started " > "Ready for connections..." > > And all works fine, however when I restarted the pc, and winmysqladmin.exe > was started as a service, the server is not started, I get the red light and > no server, or table information. If I then go and start it through the > console and run winmysqladmin.exe All my information appears like normal. > > Can anyone suggest what I should do? > > Thanks alot, > Steve. > > > > - > 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 > - 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
Re: startup on win2000 as service not working.
You need to Install MySQL as a service. Use the following steps on the DOS command prompt: 1. cd \your-path-to-mysql\bin 2. >mysqld-max-nt --install You could then start the service from Services in Control panel or use "NET START mysql" on the command line. Regards 'Gbamila - Original Message - From: "Steve Bradwell" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 08, 2002 2:14 PM Subject: startup on win2000 as service not working. > Hi everyone, > > I have recently moved my mysql server from a win98 machine to a win2000 > machine. After running the self extracting setup for mysql, I copied my > existing my.ini file over from the win 98 box, made neccesary changes to > start mysqld-max-nt from correct dir, I copied the my.ini file because of > the Innodb settings I had setup on the win98 machine. I then copied over my > Ibdata, and IbLogs directories and their contents to the win2000 box, and > the replaced the data directory with the one from the 98 box. I then started > mysql from the command prompt with "mysqld-max-nt --console" it said > > ..."Innodb: Flushing modified pages from the buffer pool..." > "Innodb: Started " > "Ready for connections..." > > And all works fine, however when I restarted the pc, and winmysqladmin.exe > was started as a service, the server is not started, I get the red light and > no server, or table information. If I then go and start it through the > console and run winmysqladmin.exe All my information appears like normal. > > Can anyone suggest what I should do? > > Thanks alot, > Steve. > > > > - > 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 > > - 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
Re: startup on win2000 as service not working.
On Tue, 8 Oct 2002, Steve Bradwell wrote: > Hi everyone, > > I have recently moved my mysql server from a win98 machine to a win2000 > machine. After running the self extracting setup for mysql, I copied my > existing my.ini file over from the win 98 box, made neccesary changes to > start mysqld-max-nt from correct dir, I copied the my.ini file because of > the Innodb settings I had setup on the win98 machine. I then copied over my > Ibdata, and IbLogs directories and their contents to the win2000 box, and > the replaced the data directory with the one from the 98 box. I then started > mysql from the command prompt with "mysqld-max-nt --console" it said > > ..."Innodb: Flushing modified pages from the buffer pool..." > "Innodb: Started " > "Ready for connections..." > > And all works fine, however when I restarted the pc, and winmysqladmin.exe > was started as a service, the server is not started, I get the red light and > no server, or table information. If I then go and start it through the > console and run winmysqladmin.exe All my information appears like normal. > > Can anyone suggest what I should do? Hi, Run mysqld-max-nt --install first in order to install your new MySQL as a service. Then it should work, at least you should be able to start the service by entering 'net start mysql'. Best regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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