Hi
The .err file shows that the service is stopped Normally and no error was found. sure the
service is properly shutdown.
Try,
a)
>net stop mysql
>mysqld-nt remove
>mysqld-nt install
>net start mysql
b)
Also run 'services.msc' and double click on the mysql service, make sure its comming from
C:\\www\mysql\bin
Thanks
ViSolve DB Team.
----- Original Message -----
From: Renish
To: Visolve DB Team ; mysql@stripped
Sent: Tuesday, October 10, 2006 10:07 AM
Subject: Fw: Query Help plss
----- Original Message -----
From: Renish
To: Visolve DB Team ; mysql@stripped
Sent: Tuesday, October 10, 2006 12:35 PM
Subject: Fw: Query Help plss
----- Original Message -----
From: Renish
To: mysql@stripped ; Visolve DB Team
Sent: Tuesday, October 10, 2006 12:34 PM
Subject: Re: Query Help plss
b) And what happend when you open cmd.exe and run.
mysql -u root- It shows cant connect to local host error 10061
*.error file shows this
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
060717 10:32:22 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
060717 10:32:23 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 10 MB
InnoDB: Database physically writes the file full: wait...
060717 10:32:23 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
060717 10:32:24 InnoDB: Started; log sequence number 0 0
C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt: ready for connections.
Version: '4.1.20-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
060717 13:47:31 [Note] C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt: Normal
shutdown
061009 15:02:37 InnoDB: Starting shutdown...
061009 15:02:42 InnoDB: Shutdown completed; log sequence number 0 543205221
061009 15:02:42 [Note] C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt: Shutdown
complete
061009 15:03:46 InnoDB: Started; log sequence number 0 543205221
C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt: ready for connections.
Version: '4.1.21-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
061010 11:58:13 [Note] C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt: Normal
shutdown
061010 11:58:13 InnoDB: Starting shutdown...
061010 11:58:15 InnoDB: Shutdown completed; log sequence number 0 543205231
061010 11:58:15 [Note] C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt: Shutdown
complete
----- Original Message -----
From: Visolve DB Team
To: Renish
Sent: Tuesday, October 10, 2006 12:16 PM
Subject: Re: Query Help plss
Hi,
a) check the file /mysql/data/*.err file and what it shows.
b) And what happend when you open cmd.exe and run.
mysql -u root
Thanks,
ViSolve DB Team.
----- Original Message -----
From: "Renish" <koshy.renish@stripped>
To: "Visolve DB Team" <mysql_support@stripped>
Sent: Tuesday, October 10, 2006 9:17 AM
Subject: Re: Query Help plss
>
> ----- Original Message -----
> From: "Visolve DB Team" <mysql_support@stripped>
> To: "Renish koshy" <koshy.renish@stripped>
> Sent: Tuesday, October 10, 2006 11:42 AM
> Subject: Re: Query Help plss
>
>
>> Hi,
>>
>> On which platform?
>>
>> Thanks
>> ViSolve DB Team.
>> ----- Original Message -----
>> From: "Renish koshy" <koshy.renish@stripped>
>> To: <mysql@stripped>; <koshy.renish@stripped>
>> Sent: Tuesday, October 10, 2006 8:03 AM
>> Subject: Query Help plss
>>
>>
>>> Hi all,
>>>>>
>>>>> I have installed MySql 4.1 in my system. when I tried to run
Mysql , I
>>>>> always gets this error.
>>>>>
>>>>> Could not start MySql service on a local computer
>>>>> Error 1067: the process terminated unexpectedly.
>>>>>
>>>>> Any help is highly appreciated.
>>>>>
>>>>> Regards,
>>>>> Renish
>>>
>
