RE: Query on InnoDB and BDB - Ismael Touama - com.mysql.lists.win32

25 messages in com.mysql.lists.win32RE: Query on InnoDB and BDB

From	Sent On	Attachments
Pramudi, Saraswati	19 Jun 2001 12:59
Pramudi, Saraswati	19 Jun 2001 15:04
Pramudi, Saraswati	19 Jun 2001 16:08
Cynic	19 Jun 2001 16:22
Miguel Angel Solórzano	19 Jun 2001 17:21
Ismael Touama	20 Jun 2001 01:12
Pramudi, Saraswati	20 Jun 2001 10:56
Armin Schöffmann	20 Jun 2001 11:05
Miguel Angel Solórzano	20 Jun 2001 11:14
Pramudi, Saraswati	20 Jun 2001 11:37
Ismael Touama	20 Jun 2001 23:58
Miguel Angel Solórzano	21 Jun 2001 00:24
Ismael Touama	21 Jun 2001 05:59
Ismael Touama	27 Jun 2001 02:19
Ismael Touama	27 Jun 2001 02:32
Miguel Angel Solórzano	27 Jun 2001 02:40
Ismael Touama	27 Jun 2001 03:04
Ismael Touama	27 Jun 2001 03:31
Miguel Angel Solórzano	27 Jun 2001 03:44
Ismael Touama	27 Jun 2001 03:50
Ismael Touama	27 Jun 2001 04:05
Ismael Touama	27 Jun 2001 06:00
Miguel Angel Solórzano	27 Jun 2001 06:19
Ismael Touama	27 Jun 2001 06:46
Ismael Touama	27 Jun 2001 07:15

Subject:	RE: Query on InnoDB and BDB
From:	Ismael Touama (isma...@install.fr)
Date:	06/27/2001 04:05:29 AM
List:	com.mysql.lists.win32

hi,

i've still done it. It's strange because i can connect to the client (dos or mysqlfront). When try starting the same error (service can't be ignit) and when try to stop it says that is not ignit! With the "managment of threads" (ctrl+alt+del), none process relative to mysql is shown! excpet when connected to client. But it doesn't tell me that MySQL is running.

So I go take some steps forward and eating to better reflex! be back in 1 hour, i guess.

-----Message d'origine----- De : Miguel Angel Solórzano [mailto:mig...@mysql.com] Envoyé : mercredi 27 juin 2001 12:45 À : Ismael Touama; Miguel Angel Solórzano Cc : win32 Objet : RE: Query on InnoDB and BDB

At 12:31 27/06/2001 +0200, Ismael Touama wrote: Hi, According with your email before, you had ran the server as standalone, when you see the InnoDB Started message, means that the server is running and ready. However in the standalone mode the dos screen remains open. You need to open other dos screen to work with mysql.exe client. To stop the server you need to use the mysqladmin tool with the command mysqladmin shutdown. I guess that you had closed the dos screen and the server stays running. Do a CTRL+ALT+DEL to see the process running and you should see the mysqld-max-nt.exe. Then force to close the process. After this install the service:

\yourpath\mysqld-max-nt --install

start the service:

net start mysql

The message that you had showed means that the service named mysql doesn't exist.

Regards, Miguel

Content-Type: text/plain; charset="iso-8859-1" X-MIME-Autoconverted: from 8bit to quoted-printable by work.mysql.com id MAA04907

Hi it's me again.

As the first DosPrompt is still waiting, i decide to stop and then re-install mysql from a second one. But i made a mistake, i install it before quiting!

C:\>cd mysql\bin

C:\mysql\bin>mysqld-max-nt --install

So i stop and then:

C:\mysql\bin>net stop mysql Le service MySql s'arrête............Le nom de service n'est pas

valide. -> Mysql service is stopping...............not valid service!

Vous obtiendrez une aide supplémentaire en entrant NET HELPMSG

2185.

Eventhough, Tried to force stop and installation:

C:\mysql\bin>net stop mysql L'erreur système 1060 s'est produite.

Le service spécifié n'existe pas en tant que service installé.

C:\mysql\bin>mysqld-max-nt --install

C:\mysql\bin>net start mysql Le service MySql démarre.--------------------->MySql is starting Le service MySql n'a pas pu être lancé.------->MySQL canno't be

'ignit'

Une erreur système s'est produite.------------>error system

L'erreur système 1067 s'est produite.--------->error system

1067

Le processus s'est arrêté inopinément.-------->prosses

unfortunely stopped.

Here is my mysql.err joined to this message. it seems quite allright.

Thanks, Ismaël

-----Message d'origine----- De : Miguel Angel Solórzano [mailto:mig...@mysql.com] Envoyé : jeudi 21 juin 2001 09:24 À : Ismael Touama; Miguel Angel Solórzano Cc : win32 Objet : RE: Query on InnoDB and BDB

At 08:58 21/06/2001 +0200, Ismael Touama wrote: Hi Ismael,

From MySQL 3.23.38 you have the following servers on Win32:

Max Servers:

mysqld.exe // the debug version including the Max stuff mysqld-max.exe mysqld-max-nt.exe

The servers without the Max stuff:

mysqld-opt.exe mysqld-nt.exe

If you want to run a Max server as service, first you need to remove the service of the above mentioned and re-install the service with a Max server.

Regards, Miguel

Hi Miguel + List!

is that the same for W2KPRO? MySQL is installed as a service but not max.

thx

-----Message d'origine----- De : Miguel Angel Solórzano [mailto:mig...@mysql.com] Envoyé : mercredi 20 juin 2001 20:15 À : Pramudi, Saraswati; 'Miguel Angel Solórzano'; 'win...@lists.mysql.com' Objet : RE: Query on InnoDB and BDB

At 10:57 20/06/2001 -0700, Pramudi, Saraswati wrote: Hi,

Well, do the following steps:

- Enter at \bin directory of MySQL. - Type: net stop mysql //only to be sure that the service it isn't running. - Type: mysqld-max-nt --remove - Type: mysqld-max-nt --standalone

The above command should permit you to see the messages from InnoDB. If you don't see InnoDB Started. Send me the messages and also send me the last lines from /data/mysql.err file.

If all works, stop the server and install again the service:

- mysqld-max-nt --install - net start mysql

Regards, Miguel